Page 1 of 1

Change data Capture Warning[api/transfer_rep.C:1832]

Posted: Tue Mar 30, 2010 7:24 am
by deepa_shenoy
Hi,

I am constantly getting this warning while using the Change data Capture Stage:

When checking operator: Defaulting "PD_GRD_EFF_DT" in transfer from "beforeRec" to "outputRec". [api/transfer_rep.C:1832]

I have 5 columns in Reference link and 6 columns in Primary link and the 6 th column of the primary (after) link is throwing this warning.
Change Mode is 'Explicit Keys & Values'

Need help ASAP.

Thanks.

Deepa

Posted: Tue Mar 30, 2010 7:59 am
by JSWARBRI
You're getting this warning because you don't have the column "PD_GRD_EFF_DT" in your before dataset.

Posted: Tue Mar 30, 2010 10:06 am
by deepa_shenoy
I have it in my Before link as well. Even when I include it, it throws be the same warning as I have not put it under Change Value nor Change Key.

I don't want to compare that column and its not a part of the key but I want it from my After Link.

Posted: Tue Mar 30, 2010 10:08 am
by deepa_shenoy
I have it in my Before link as well. Even when I include it, it throws be the same warning as I have not put it under Change Value nor Change Key.

I don't want to compare that column and its not a part of the key but I want it from my After Link.

Posted: Tue Mar 30, 2010 12:41 pm
by shivajid2k
Is the columns in both data sets are in same order with same data types?

Posted: Tue Mar 30, 2010 12:43 pm
by shivajid2k
Is the columns in both data sets are in same order with same data types?

Posted: Tue Mar 30, 2010 10:30 pm
by deepa_shenoy
Same data types but different order.

Posted: Tue Mar 30, 2010 11:20 pm
by ray.wurlod
Try using identical metadata (same order) on all links.

Posted: Thu Apr 01, 2010 3:21 am
by deepa_shenoy
I gave the same order. The warning still persists.