Change Capture stage

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 3:08 am

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

balajisr · Post by **balajisr** » Tue May 27, 2008 3:30 am

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 3:31 am

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

balajisr · Post by **balajisr** » Tue May 27, 2008 3:40 am

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?

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 3:46 am

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

balajisr · Post by **balajisr** » Tue May 27, 2008 3:56 am

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

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 4:06 am

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

balajisr · Post by **balajisr** » Tue May 27, 2008 4:23 am

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?

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 4:45 am

thumati.praveen · Post by **thumati.praveen** » Tue May 27, 2008 5:30 am

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

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 5:40 am

I m using Explict Key & Values option

keshav0307 · Post by **keshav0307** » Tue May 27, 2008 6:06 am

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

thumati.praveen · Post by **thumati.praveen** » Tue May 27, 2008 6:10 am

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.

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 6:31 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue May 27, 2008 6:48 am

The environment variable name is APT_STRING_PADCHAR.