DSXchange

In change capture stage,can key columnn be a VARCHAR?(On column I m comparing value)

Yes.

I couldn't get exactly.Can it be VARCHAR or it need to be Int only

Roopanwita wrote:I couldn't get exactly.Can it be VARCHAR or it need to be Int only

Key column can be varchar. What is the error you get?

I didn't get any error,but changed record is not getting captured..

My job design is as -

src1(before)--
CC---Filter(on changed code)---insert-updt(src2)/Insert(Hist)
src2(after)--

In this I have changed some values in SRC2,still CC is unable to capture that record..

What is the output of the changed records through CC. Is it Edit or Insert or any other?

Output should be Edit,but no record is coming out of CC

Roopanwita wrote:Output should be Edit,but no record is coming out of CC

In that case it should be Copy record if you had set drop copy record.

Is metadata for before and after dataset same?

once check the link order and what method your using? (Example:Allkeys Explicit values,Explicit keys Explicit values like this...)

I m using Explict Key & Values option

what is the $APT_PAD_CHAR value. for varchar columns i find it realy matters.

Roopanwita wrote:I m using Explict Key & Values option

The stream link should be after and refrence link should be the before in CC link order.Finally what Change code it returns identify if it is 3 then the source record was changed if it is 1 then new record.

I coudn't find $APT_PAD_CHAR parameter.
Already I have made Ref as Bedor & Stream as After link and also set same logic (1 -insert,3 update)
But though there r changed value in reference no record is coming out of CC.

The environment variable name is APT_STRING_PADCHAR.