How to go for Incremental Loading

[raj4Informatica]

Hello,
I want to Implement Incremental Loading from the Source to target, on per day basis, as the current source DB Table does not have any flag like update_date ,so should I create an extra coulmn in the target table and do the look up . Please suggest the best way to implement this with good output performance.

Thanks & Regards

Raj

 

[orameenal]

If there is no update date then u will have to read all the records everytime you load. This should not be a problem if the table is a small one. If there is a primary key on your table and you want to use Type 1 loading (i.e. overwriting existing record), then use the Update strategy for Update else insert i.e. if the key already exists in your table then update it , else insert it.

According to me you should have an update date on your source table. It is easier to implement it then since you will be reading only the records modified the previous day.

Hope this helps.
Meenal