Skip to Content
0
Former Member
Jun 15, 2011 at 03:15 AM

Simple File to Database Scenario

30 Views

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