How to load data by doing record by record comparision

[saxena_richa]

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

[Meera]

I still do not understand why a source with 230 million rows doesnt have a key column. And if there is no key, how do you define delta rows?

[gateleys]

Not having source system keys can be a pain. Now, while there is a possibility that there may be duplicity, but computing a CRC value on the concatenated values of the row and then comparing it against the same for target may be the way to go.

[keshav0307]

how many computing nodes you are using??
what is type of partition used??