Hi All,
I am using ChangeCapture stage to compare 2 datsets in my job.
I am getting below warning message:
Change_Capture_8: When checking operator: Defaulting "ACRL_MTHD" in transfer from "beforeRec" to "outputRec".
How to over come with this warnings?
I am getting this warnings for all my columns specified in Change Capture stage
Thanks in advance
Change Capture Warnings in Log
Moderators: chulett, rschirm, roy
Change Capture Warnings in Log
Thanx&Regards
scorpion
scorpion
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
You get these warnings when you don't set the properties of CDC correctly..
To figure out the exact problem we need additional info..
1) How many columns do you have?
2) What are the key columns and value columns?
To figure out the exact problem we need additional info..
1) How many columns do you have?
2) What are the key columns and value columns?
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
So, do you just want to track the inserts and deletes?
Then use the option explicit keys all values
Then use the option explicit keys all values
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Choose Explicit Keys, All Values . It's different from explicit keys and values.Options category Change mode This mode determines how keys and values are specified. Choose Explicit Keys & Values to specify the keys and values yourself. Choose All keys, Explicit values to specify that value columns must be defined, but all other columns are key columns unless excluded. Choose Explicit Keys, All Values to specify that key columns must be defined but all other columns are value columns unless they are excluded.
But again, this is if you just want to track your inserts and deletes ..
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse