Hi,
I'm having some issues in production job.
My requirement is based on condition we'll load data either insert or upsert.
In source Tran_type one column.If Tran_type ='IN' then insert mode.
If Tran_type ='UP' then upsert mode
If Tran_type='IN' then insert mode.Please suggest me to design a job to satisfy this requirement.
I have two ideas.I'll create two jobs and in Transformer stage I'll write a constraint as Tran_type='IN' then insert mode.
In another job in Transformer stage I'll write a constraint as Tran_type='UP'
then upsert mode.
I'll design one job and in database I'll write insert query with condition where
Tran_type='IN' and I'll write update query with condition where Tran_type='UP' using upsert mode.
Please suggest me these design will satisfy the given requirement else anything I have to do .
Thanks
insert or upsert the records based on condition
Moderators: chulett, rschirm, roy