Change Capture Warnings in Log

[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

[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?

[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

[Minhajuddin]

So, do you just want to track the inserts and deletes?

Then use the option explicit keys all values

[scorpion]

I am using the same value...

[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 ..

[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.