Incremental Loading Flat File Data Capture

How can we do incremental loading if the source is flat file?

Showing Answers 1 - 1 of 1 Answers

Ratnesh

  • Dec 31st, 2020
 

If your source flat file is always full file , based on the natural keys, you can identify the records by lookup on the target table , whether records are existing or new. If records are new, go ahead and insert them. If records are existing , check whether any real changes on any fields and update the existing records.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions