Data WareHouse & Informatica Interview Questions & answers Update
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
We can use do this by identifying the granularity of the target table .
We can use CRC external procedure after that to compare newly generated CRC no. with the old one and if they do not match then update the row.
No comments:
Post a Comment