Change capture stage actions is wierd

Ragunathan Gunasekaran · Thu Apr 03, 2008 3:53 am

Hi ,
I am using a .csv file as the after link and the Oracle stage as the before link to the Change capture stage. The data in both of them are the same and the metadata are varchar in nature.The key for both are varchar datatype.

(Additional columns are droped and metadata are made as the metadata of the oracle stage in the modify stage )

.CSV File ------> Modify stage -----> Change capture <------------Oracle stage

I am testing with a single record which is the same in the oracle table and the .csv file, Mandated it should have only the change code as 0(copy) but it has 1 and 2 ( Means comes as insert and delete record) . This is the issue now . Any help on this please. I have made the metadat perfect on both the after and the before links .

Ragunathan Gunasekaran · Thu Apr 03, 2008 6:10 am

Does change capture stage cant work with Different after and before source. I am able to get the results if i work with smillar stages such as the before and the after links were oracle stage or datasets but the change capture fails to do so if the stages are a mix in their before and the after links . Is this a correct one ?

keshav0307 · Post by **keshav0307** » Thu Apr 03, 2008 6:54 am

are the metada of the before link and after link same??
what is the padchar?? '' is better

priyadarshikunal · Post by **priyadarshikunal** » Thu Apr 03, 2008 7:05 am

Ragunathan Gunasekaran wrote:Does change capture stage cant work with Different after and before source. I am able to get the results if i work with smillar stages such as the before and the after links were oracle stage or datasets but the change capture fails to do so if the stages are a mix in their before and the after links . Is this a correct one ?

change capture goves weired results when keys are duplicate.

make sure you don't have duplicate keys present in both source as well as target (before and after links)

priyadarshikunal · Post by **priyadarshikunal** » Thu Apr 03, 2008 7:12 am

one more thing is I faced is 'It doesn't give the desired result when there is any field having double data type without scale and precision.'

Make sure you define the scale and precision for double/float data type

Regards,

Ragunathan Gunasekaran · Thu Apr 03, 2008 11:46 am

I have the metadata intact and i have only integer columns . Any help on this please

ray.wurlod · Post by **ray.wurlod** » Thu Apr 03, 2008 5:32 pm

What's the matter with the help already given? Did you de-duplicate the inputs?