When checking operator: Defaulting "COL9" in transfer from "beforeRec" to "outputRec"
I am getting the same warning. Data types and column order are exactly the same except the change_code column.
I went through every possible post here and came up with the following solutions:
1) Enable RCP at job level and disable RCP at the stage level.
--Doesn't work for me.--
2)According to Ray, might be a information message (eventhough displayed as a warning) from Datastage.
--I can promote it to informational but don't want to.--
3)Make All non-key columns Value Keys.
--That'll complete defeat my purpose as I do NOT want this column to be considered during comparison. The output will not be what I want.--
What else can be the reason for this warning?
Change Capture stage warning
Moderators: chulett, rschirm, roy
Re: Change Capture stage warning
You need to select Explicit Keys and Explicit Values and specifically mention the columns you want to do the compare on.abc123 wrote: 3)Make All non-key columns Value Keys.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
Yes, I saw that solution in another post. That requires me to put a copy stage before and a join stage after the ChangeCapture just to get rid of this warning. Seems like a lot of work (and overhead) just to get rid of a warning.
I just want to know why ChangeCapture is producing this warning? Is it because that, on an insert, these columns are null?
I have sure people have encountered this before.
I just want to know why ChangeCapture is producing this warning? Is it because that, on an insert, these columns are null?
I have sure people have encountered this before.