Easy way to do an update only when needed
Posted: Fri May 20, 2016 11:32 am
so I`m a newbie with datastage, learning the ropes, so this might be a dumb question.
Is there and easy way/stage to do this?
So I want to insert new, and only update rows that have changed. Something like the SCD stage, but without the surrogate key.
For simplicity sake, three fields: Key, Data, Mod_Date
- new Key.....insert with sysdate as Mod_Date
- existing Key with existing Data.... do nothing
- Existing Key with new data... update row with sysdate as Mod_Date
It`s a simple/common task, I'm hoping there is a simple/common solution that I just don't know yet.
Thanks!
Charles
Is there and easy way/stage to do this?
So I want to insert new, and only update rows that have changed. Something like the SCD stage, but without the surrogate key.
For simplicity sake, three fields: Key, Data, Mod_Date
- new Key.....insert with sysdate as Mod_Date
- existing Key with existing Data.... do nothing
- Existing Key with new data... update row with sysdate as Mod_Date
It`s a simple/common task, I'm hoping there is a simple/common solution that I just don't know yet.
Thanks!
Charles