Page 1 of 1
Change Capture Warnings in Log
Posted: Wed Sep 12, 2007 11:55 am
by scorpion
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
Posted: Wed Sep 12, 2007 12:05 pm
by Minhajuddin
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?
Posted: Wed Sep 12, 2007 12:33 pm
by scorpion
Hi Thanks for the reply,
Below are the details
To figure out the exact problem we need additional info..
1) How many columns do you have?
50 Columns
2) What are the key columns and value columns?
only one is the key column and i mentioned
changemode = explicit keys and values
Posted: Wed Sep 12, 2007 12:39 pm
by Minhajuddin
So, do you just want to track the inserts and deletes?
Then use the option explicit keys all values
Posted: Wed Sep 12, 2007 12:45 pm
by scorpion
I am using the same value...
Posted: Wed Sep 12, 2007 1:10 pm
by Minhajuddin
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.
Choose Explicit Keys, All Values . It's different from explicit keys and values.
But again, this is if you just want to track your inserts and deletes ..
Posted: Wed Sep 12, 2007 9:20 pm
by samsuf2002
Check that all the properties , data types and keys in both input files are same and change the CDC property tp Explicit Keys, All Values as suggested by minaj if u want to compare all the columns.