Has anyone experienced the following problem and have found a possible solution to it?
In one of my DS jobs I am passing 25 columns from Sort to CDC stage. While doing so all the 24 columns are getting into the CDC stage and only one column is found missing. I have checked the Output--> Columns and Mapping tabs within the Sort stages in before and after paths. I'm able to see the missing column.
Code: Select all
DB2 Stage (Before run)
|
Sort
|
Seq File----Transformer---Sort---CDC ...
(After Run)
In CDC stage
1. I have set the Options-->Change Mode as "Explicit Keys, All values".
2. This column is available in the Input tab.
However, within the Column Selection window one of the columns from the previous stage is missing.
Initially I looked into the column propagation within columns tab and searched this forum. I don't find a solution for this scenario. (Not sure if I need to use a different key word for search.. ) Thought of seeking your help.
Kind Regards and Many Thanks in advance