Hi All,
I have a source table and target table ,i want to transfer some records into target based on records exist in target table i.e. if target table is empty then i want to transfer all the records from source and if target table is not empty , i want to transfer the records from source which are not in target and updated records from source .
Thanks in Advance
Check for Empty Table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Wed Oct 01, 2008 10:30 am
Check for Empty Table
IBM Websphere Datastage Certified Professional
Re: Check for Empty Table
Simply use update action -- update existing records and insert new records option i.e upsert load mode in target table.
Specify what stage you are using to load target table?
Specify what stage you are using to load target table?
Shiva