change capture
Posted: Wed Jan 04, 2006 10:18 am
Hi ,
I am using scd type 2 ,
I am using change capture stage , which is working fine with the sample data , but when I am trying to load the real data , update is failing , though the records in before and after sets are similar it is giving update that is change_code=3 ,
I ceated two table with 5 records which are exact copy , then from after data set I changed 2 for update , 1 for insert and 1 delete , I got the exact result , but with real data total count for after data(source) set 414925 , before (target ) data set is 414926 , output of change capture stage gives me 414928 out of which 414923 are update 3 delete and 2 insert ,
but when I checked the update data it is exactly same as target source ,
it shouldnt give update it should be copy ,
I selected the option implicit keys and all values and I did not even include the field like rec_effective_date, rec_exeration_date or delete_flag which may cause the problem , but then also I am not getting exact count for update ,
please suggest ,
I am using scd type 2 ,
I am using change capture stage , which is working fine with the sample data , but when I am trying to load the real data , update is failing , though the records in before and after sets are similar it is giving update that is change_code=3 ,
I ceated two table with 5 records which are exact copy , then from after data set I changed 2 for update , 1 for insert and 1 delete , I got the exact result , but with real data total count for after data(source) set 414925 , before (target ) data set is 414926 , output of change capture stage gives me 414928 out of which 414923 are update 3 delete and 2 insert ,
but when I checked the update data it is exactly same as target source ,
it shouldnt give update it should be copy ,
I selected the option implicit keys and all values and I did not even include the field like rec_effective_date, rec_exeration_date or delete_flag which may cause the problem , but then also I am not getting exact count for update ,
please suggest ,