InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Do You Do Incremental Load? |
|
Answer» Fastest way to do INCREMENTAL load is by USING Timestamp column in source table and then storing last ETL timestamp, In ETL process pick all the rows having Timestamp greater than the STORED Timestamp so as to pick only new and updated records. Fastest way to do incremental load is by using Timestamp column in source table and then storing last ETL timestamp, In ETL process pick all the rows having Timestamp greater than the stored Timestamp so as to pick only new and updated records. |
|