Hi,
We have a post for this but I felt we do not have enough info on that one.
I am getting following waring when I pull all columns from after dataset as I have not added all columns in explicit keys & values.
However I need all those columns to do another cdc to differentiate two updates. ( second cdc is fine as I added all those columns under explicit values)
warning for first cdc..
cc1: When checking operator: Defaulting "First_Name" in transfer from "beforeRec" to "outputRec".
Appreciated for your help!
CDC Warning
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
It's a dangerous warning because it is putting NULL into your FIRST_NAME field on output. I think it occurs when you have a field that is not matched between your two inputs so it defaults it to empty on output.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Let's be clear here.
Is this the Change Data Capture product (which typically identifies changes from transaction logs in databases), or is this the Change Capture stage?
Is this the Change Data Capture product (which typically identifies changes from transaction logs in databases), or is this the Change Capture stage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.