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 .
Change capture stage actions is wierd
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
Change capture stage actions is wierd
Regards
Ragu
Ragu
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
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 ?
Regards
Ragu
Ragu
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
change capture goves weired results when keys are duplicate.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 ?
make sure you don't have duplicate keys present in both source as well as target (before and after links)
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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,
Make sure you define the scale and precision for double/float data type
Regards,
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: