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 composite keys and validating the information. As per documentation there is a difference code which has 4 values 0,1,2 and 3 to identify Delete, Copy, Insert,, Update
But the datastage job is giving a problem when there are more rows in the AFTER table which are not there in BEFORE table because the AFTER table data is not moving to the OUTPUT. The output stage mapping just has BEFORE table columns showing up in the mapping panel. In the documentation it is given that the tool can identify inserts which I think is extra rows in AFTER table that are not present in BEFORE table.
Thanks
Difference Stage
Moderators: chulett, rschirm, roy
Re: Difference Stage
Can you use change capture stage for this because this will also give you the changes you are looking for...
Re: Difference Stage
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: