The Change Capture stage provides endless entertaining warning messages for the whole family. It works best when the column list on the After (primary) stream exactly matches the Before (reference) stream. If you have a column on the After stream that is not on the Before stream then you need to choose Explicit Values, when you leave this column out of the Key and Values list then you will get a warning for that column. It is a completely valid action, you are simply passing a value through the stage without using it as a key or value column, but you cannot avoid the warning. Filter out the warning using a message handler.
If you think you have the CPRFBRN on both the Before and After links then check that the spelling and data type of the column matches on both links and that it comes up when you choose Explicit values and try to add it as a value column.
vmcburney wrote:
If you think you have the CPRFBRN on both the Before and After links then check that the spelling and data type of the column matches on both links and that it comes up when you choose Explicit values and try to add it as a value column.
Hi vincent,
it is not only for one column, i just place a sample, but it gives for all the columns. And fortunately, both are of same layout....
Ray,
As i told i had given defaluts....(no need to loose points, coz i still need your help )
Hi,
Mine is huge data, hence the suggestion povided (change capture for only the key and the value and by pass rest of the values to join) may not be much helpful.
Is there any other way to get rid of this warnings.
(right now just for this single stage i have replace a full outer join and transformer to give the codes and funnel to collect back, Excepting a smart solution...)
Hi,
I'm currently facing a similar situation.
In my case 2 DataSets are prepared with Identical scheme and passing them to CC stage in another job causes warnings as mentioned in the original post.
I'll try to post my findings sd they develop.
To be continued ...
My problem was resolved after rebuilding the CC stage a new.
Kinda reminds me of the merge stage in server
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.