Change Capture Stage

anu123 · Post by **anu123** » Thu May 29, 2008 10:24 am

Gurus:

I have 2 key and 3 value columns in after dataset and 2 key and 4 (4th one is modified date) value columns in before dataset.

I want to compare after and before datasets using 2 keys and 3 values columns.
If incoming row exists in before dataset then I need to bring the 4th value column and append to current row. In all other cases append the business date.

I using Change capture stage to achive this. But since I did not add 4th column to 'Change Values' in the stage I am below warning.

When checking operator: Defaulting "MOD_DT" in transfer from "beforeRec" to "outputRec".

Thanks in advance.

keshav0307 · Post by **keshav0307** » Thu May 29, 2008 11:06 pm

this has been discussed may times. try searching in this foroum.

reason being the MOD_DT is not in after dataset.
but what is the error/problem you have?

anu123 · Post by **anu123** » Sun Jun 01, 2008 9:22 am

keshav0307 wrote:this has been discussed may times. try searching in this foroum.

reason being the MOD_DT is not in after dataset.
but what is the error/problem you have?

It has been solved. Thank you.

ray.wurlod · Post by **ray.wurlod** » Sun Jun 01, 2008 2:32 pm

Please post a message indicating how it has been solved and mark the thread as Resolved.
This will assist future searchers.

dtv2002 · Post by **dtv2002** » Tue Jun 17, 2008 12:29 pm

keshav0307 wrote:this has been discussed may times. try searching in this foroum.

reason being the MOD_DT is not in after dataset.
but what is the error/problem you have?

I have been Searching in the forum but don't find any discussion about this problem !

rocket1234 · Post by **rocket1234** » Wed Aug 27, 2008 12:51 am

i have same problem