Hi:
I am using the Dynamic RDBMS Stage to load the data in SQL SERVER database in the target side.
My requirement is inserting the new records only.
For example im getting the 12 records from source, but 10 records already therein the target table,i have to insert only 2 records means ignore the existing records,no need updation also for existing records.
Please advice me which property can i choose from the updateaction combo in the Dynamic RDBMS Stage .
Thanks in advance
cnu
Load the data by using Dynamic RDBMS Stage in the SQLSERVER
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No, this rule says to generate INSERT statements only. It will attempt to process all the rows that you send to the stage.
YOU have to organize that only the new rows reach the stage.
YOU have to organize that only the new rows reach the stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: