Change Capture stage warning
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
Change Capture stage warning
Hi All,
I am getting the warning below and warnings are not allowed in our project.I am using the column mentioned in the warning in both "after" and "before" datasets but excluded that from being a value column and it is present in the output column for the updates on the tables.
RCP is disabled on the project level.
One solution I have is to have a copy stage before CDC stage and drop that column and rejoin.
Please suggest if there is another way....
Warning:
CDC_Knid: When checking operator: Defaulting "InsertType" in transfer from "beforeRec" to "outputRec".
I am getting the warning below and warnings are not allowed in our project.I am using the column mentioned in the warning in both "after" and "before" datasets but excluded that from being a value column and it is present in the output column for the updates on the tables.
RCP is disabled on the project level.
One solution I have is to have a copy stage before CDC stage and drop that column and rejoin.
Please suggest if there is another way....
Warning:
CDC_Knid: When checking operator: Defaulting "InsertType" in transfer from "beforeRec" to "outputRec".
N.Srinivas
India.
India.
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
I am having exactly this same issue. I have a set of updates to perform on about 40 columns, but I only want to do Change Capture on 5 of them. All of the other 35 or so columns that I am passing through on the "After" link (which is the update data) but not doing Change Capture on show in the job log as warnings. I also have Explicit Keys & Values set. It makes no difference whether I have these columns coming in on the Before link or not.
Looks like we will have to do a Message Handler.
Looks like we will have to do a Message Handler.
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant
CDC needs identical input-columns on both links. If a column is missing on one link you will get the quoted warning, even if you are not using the column.
Add the column on the before-input-link (set to Null if necessary). Obviously, use explicit values, since you do not want to compare this column to the after record.
Add the column on the before-input-link (set to Null if necessary). Obviously, use explicit values, since you do not want to compare this column to the after record.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
It makes no difference whether I have these columns coming in on the Before link or not.BI-RMA wrote:CDC needs identical input-columns on both links. If a column is missing on one link you will get the quoted warning, even if you are not using the column.
Add the column on the before-input-link (set to Null if necessary). Obviously, use explicit values, since you do not want to compare this column to the after record.
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant
Double checked this. They can if they are on the after-input-link, but the mentioned warning will be issued in this case.fmou wrote:I thought only the key columns and the value columns can pass the CDC. For all the rest of the columns, ie. the don't-care ones, they can't pass through the CDC. Correct?
thanks
To avoid the warning it would be necessary to send the extra-columns around the CDC in another stream to rejoin them behind it. I would personally use message-handlers only as a last-resort solution, because not all of the messages are related to a unique scenario. Demoting the (obsolete) message for one scenario may result in a different (potentially problematic) message demoted after a change in the job.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon