CAPTURING THE DELETEDRECORDS...............

akansha123 · Post by **akansha123** » Thu Oct 26, 2006 1:50 pm

Hai,
Can anyone tell me how to catch catch the deleted records while performing CDC(Change Data Capture)

samsuf2002 · Post by **samsuf2002** » Thu Oct 26, 2006 2:21 pm

make the "drop deletes" option equal false in CDC.

meena · Post by **meena** » Thu Oct 26, 2006 2:43 pm

Hi,
Move this to Parallel Forum.

gateleys · Post by **gateleys** » Thu Oct 26, 2006 3:08 pm

It seems he is on Server and means the CDD technique and not the stage (as available in EE). Akansa, in order that the deleted rows are accounted for, you will have to maintain an image of the previous load. Only then will you be able to do what you were asking for. There was a job design that was posted here some time back which dealt with this, interestingly; but I just could not find it.

gateleys

akansha123 · Post by **akansha123** » Thu Oct 26, 2006 3:15 pm

Its a server job and iam using hash file to capture the changed and unchanged data using CRC32 function but also need to capture the deleted data

kris007 · Post by **kris007** » Thu Oct 26, 2006 3:16 pm

To capture records from target table which are no longer present in the source you can do the following:

Read all the Keys from the Target. This is your primary input. Load all the keys from the source in the hashed file and use that as lookup. Now bring out only those rows from your target which don't have a match in your hashed file and set your update action as "Delete existing rows" and that will delete all the records in the target. Now to capture them, just write those rows to a sequential file instead of deleting. It's upto your requirement.

IHTH

meena · Post by **meena** » Thu Oct 26, 2006 4:58 pm

I thought this is regarding chage capture stage.

meena wrote:Hi,
Move this to Parallel Forum.

.

chulett · Post by **chulett** » Thu Oct 26, 2006 5:33 pm

Nope. Turns out to be a wrong choice of terminology... as noted later, the OP is actually attempting CDD.