In one of my jobs the source table is defined with 27 columns and the target is defined with 25 columns. Both source and target metadata data exactly matches, except that the 2 columns (CUST_NBR,TYP_CODE) that are defined in source table are not there in the target.
I'm doing a comparison between the source and target. The CDC expects the same metadata in the source and target.
Code: Select all
Target table (25 rows - trying to get CUST_NBR &TYP_CODE) |
|
Sort
|
Source table -->Sort-->CDC--> other stages-----target table
(27 rows)
Target DB2 custom SQL
Code: Select all
SELECT CUST_NBR, TYP_CODE FROM SCHEMA.TARGET_TABLE
WHERE CUST_NBR = (SELECT CUST_NBR FROM SCHEMA.SOURCE_TABLE)
AND TYP_CODE = (SELECT TYP_CODE FROM SCHEMA.SOURCE_TABLE)
Is there a way to bring these two new fields in target DB2 stage just to satisfy CDC stage? I tried different ways but couldn't get these 2 columns in target table. Could you please share your valuable suggestions with me.
Many thanks & Kind Regards