Incremental Table Transfer....
Posted: Thu Feb 20, 2003 2:24 pm
Hi All,
I designed Job using DataStage to do ETL from Relational Oracle schema to Star Schema.I finished creating jobs it is working fine.I want to do incremenal backup of the tables.I hope u can understand what it means.ie I want first time Insertion (Update Action of ODBC Stage) 2nd time onwards i want do (Insert New or Update existing rows OF odbc Stage).how can i do this.Can any one please help me.
Eg
Source Oracle Table (A) ---> ETL ---> Target Oracle Table (TA)
when I run the job first time it needs to insert rows. when i m suppose running the job for 2nd time or nth time it needs to do (Insert New or Update Existing Rows Update ACtion of ODBC Stage).
So Please give me solution for this problem.
Note:it is very urgent , SO please Please any one of you help me.
Thanks & Regards,
K.S.Rajan.
I designed Job using DataStage to do ETL from Relational Oracle schema to Star Schema.I finished creating jobs it is working fine.I want to do incremenal backup of the tables.I hope u can understand what it means.ie I want first time Insertion (Update Action of ODBC Stage) 2nd time onwards i want do (Insert New or Update existing rows OF odbc Stage).how can i do this.Can any one please help me.
Eg
Source Oracle Table (A) ---> ETL ---> Target Oracle Table (TA)
when I run the job first time it needs to insert rows. when i m suppose running the job for 2nd time or nth time it needs to do (Insert New or Update Existing Rows Update ACtion of ODBC Stage).
So Please give me solution for this problem.
Note:it is very urgent , SO please Please any one of you help me.
Thanks & Regards,
K.S.Rajan.