DSXchange

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

Your updates are appearing on both sides of your queries

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