DSXchange

Yes from what i have tested the difference stage just compares the BEFORE and AFTER file and is capable of determining the changes that have happened only for the BEFORE file.

Thanks,
Jayadeep

You can use the AFTER SQL to commit the data at once that has been inserted into Oracle table

Yes the CDC worked and that I already had implemented, I was just trying to see what is the basic difference between Change Capture and Difference Stage because as per the document both of them provide the same output

I have two tables BEFORE and AFTER both of them have 4 columns EQT_NAME HUB_CODE LOCATION_CODE OS_TURN_TIME I want to know what is the difference between 2 tables in terms of data content so I am using the Difference stage. In the difference stage I have put EQT_NAME HUB_CODE LOCATION_CODE as compos...