How to load data by doing record by record comparision
Posted: Mon Jun 09, 2008 7:15 am
Hello,
I hv to load data frm a source view in foll way:-
Compare the incoming record with existing ones in target, and if there is any difference, load the incoming record else dont load. There is no key column defined in the source, so we cant check any 1 column but need to check data in all the columns of a record
Based on this requirement, I thought of using a change capture stage. Is there any other way of achieving this? As of now I am getting the foll error and the job aborts after abt loading 11 million recs..
Fatal Error: Pipe read failed: short read and
Fatal Error: Tsort merger aborting: Scratch space full
The source is a view with arnd 230 million recds.
Thnks
Richa
I hv to load data frm a source view in foll way:-
Compare the incoming record with existing ones in target, and if there is any difference, load the incoming record else dont load. There is no key column defined in the source, so we cant check any 1 column but need to check data in all the columns of a record
Based on this requirement, I thought of using a change capture stage. Is there any other way of achieving this? As of now I am getting the foll error and the job aborts after abt loading 11 million recs..
Fatal Error: Pipe read failed: short read and
Fatal Error: Tsort merger aborting: Scratch space full
The source is a view with arnd 230 million recds.
Thnks
Richa