Dear Experts
I am working on a File to Database scenario. My requirement is to update the database with latest information. For example
1. First day i got a file of 100 records...Insert all the 100 records.
2. Second day i will get 110 records (here 100 records is old data and 10 records is the delta). Now PI needs to lookup with DB and insert the updates of 100 records and insert the delta 10 records...
3. Third day i got 125 records file (here 110 is previous days data and 15 is todays delta). I need to update the changes of all the 110 and insert 15 delta records
Thanks