Issue with Change capture Stage

balu536 · Post by **balu536** » Mon Nov 09, 2009 7:22 am

Hi,
I am having two Tables(Table_old) and (Table_new).I need to find out 1.records which are new(inserted) in Table_new,
2.records which are deleted from Table_new when compared to Table_old
3. records which are updated in Table_new.

I've used CHANGE DATA CAPTURE stage and got the output as
57 - Inserts,19-Updates,12-Deletes.

But when i'm querying on the two tables in oracle i'm getting
76 - Inserts,31 - deletes
INSERTS - (SELECT * FROM TABLE_NEW MINUS SELECT * FROM TABLE_OLD)
DELETED - (SELECT * FROM TABLE_OLD MINUS SELECT * FROM TABLE_NEW)

The settings i have used in chage capture are
Change Mode : Explicit Keys,All Values
Dropout for Copy = True
Dropout for Delete = False
Dropout for Edit = False
Dropout for Insert = False

Please help me in resolving the issue.

Regards,
Balakrishna

Kryt0n · Post by **Kryt0n** » Mon Nov 09, 2009 2:32 pm

Your updates are appearing on both sides of your queries

balu536 · Post by **balu536** » Tue Nov 10, 2009 6:05 am

Got the problem
There's no issue with the Change Capture stage.The query which i am using for testing purpose is giving both insert+update count and the same way the other is giving delete+update count.

Regards,
Balakrishna