change capture warnings
Posted: Fri Feb 24, 2006 4:50 pm
Hi ,
this is not the new warning . I have read the number of post on this warnings ,The warning is :
Change_Capture_28: When checking operator: Defaulting "TRANSACTION_AMOUNT" in transfer from "beforeRec" to "outputRec".
I am using CC stage with the option explicit values and keys , I have to consider only 2 column . one is key and other is value columnwhich might get updated and depending on this value column I have to update the taget ,
Everything works fine but the problem is I am getting no of warnigs for all column which i am not including in CC stage ,
I have read in one of the post , and I am only passing 2 columns through change capture , I am using copy stage to pass two links one with all columns and 2nd with only 2 columns , these 2 colunm passing through CC stage to get key column and change code from CC stage and again joing with other columns from the copy stage based on the key column ,doing remaining processing(look up for various dimensions ) and then updating or inserting records in the target ,
Everything is fine , the problem is though I am not passing all these column fron CC stage still I am getting above warnigns for all column , I have tried no of things ,
Please suggest the solution ,
thanks in advance
this is not the new warning . I have read the number of post on this warnings ,The warning is :
Change_Capture_28: When checking operator: Defaulting "TRANSACTION_AMOUNT" in transfer from "beforeRec" to "outputRec".
I am using CC stage with the option explicit values and keys , I have to consider only 2 column . one is key and other is value columnwhich might get updated and depending on this value column I have to update the taget ,
Everything works fine but the problem is I am getting no of warnigs for all column which i am not including in CC stage ,
I have read in one of the post , and I am only passing 2 columns through change capture , I am using copy stage to pass two links one with all columns and 2nd with only 2 columns , these 2 colunm passing through CC stage to get key column and change code from CC stage and again joing with other columns from the copy stage based on the key column ,doing remaining processing(look up for various dimensions ) and then updating or inserting records in the target ,
Everything is fine , the problem is though I am not passing all these column fron CC stage still I am getting above warnigns for all column , I have tried no of things ,
Please suggest the solution ,
thanks in advance