hi guys
i have job to do. i dont know how am i suppose to do it. i have a job in which i have a sequatial file which has a file. now it load's the data to a teradata multiload. i have to modify that job into insert and update operation. splitting into two. means insert when when data not found and update when matching data found with updated values. did anyone did like this job.
please let me know. i shall be very greatfull to you. thank you.
insert/update
Moderators: chulett, rschirm, roy
For the category of Insert/Update, you need to do a lookup on the target to find whether the data is New or Update.
So it can be a merely a lookup stage if the data can fit into memory or a join transformer, or CangeCapture stage.
Based on the flag, you an insert or update the data in different stream. You can check the database option for Teradata link Upsert.
So it can be a merely a lookup stage if the data can fit into memory or a join transformer, or CangeCapture stage.
Based on the flag, you an insert or update the data in different stream. You can check the database option for Teradata link Upsert.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Charter Member
- Posts: 47
- Joined: Fri Mar 18, 2005 5:59 am