Difference Stage
Posted: Tue Jul 19, 2011 11:25 pm
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
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