Data Services Delete Records

[Former Member]

Hi All,

I have a table with key and last updated time and we are using the LastUpdatedTime field to load the delta records once a day but my concern is how we capture the deleted records that was created a week ago but deleted now

For

Source System

ID            LastUpdatedOn

1               10/12/14 1pm

2               10/12/14  2pm

BODS job is executed at 3 PM

Target Table

ID            LastUpdatedOn

1               10/12/14 1pm

2               10/12/14  2pm 

Next Day at Source System (They have created the ID = 3 and deleted the ID = 2)

ID            LastUpdatedOn

1               10/12/14 1pm

3               10/13/14  2pm 

BODS job is executed at 3 PM

BODS job looks at Max Time in Target in this case its 10/12/14 2pm and then it retrieves  all the records greater than 10/12/14 2pm from source in this case it will just picks up

3	10/13/14  2pm

and loads into Target but my concern how do identify the ID = 2 and delete in Target

Anyhelp is appreciated

Thanks

[mageshwaran_subramanian]

Here you go