cancel
Showing results for 
Search instead for 
Did you mean: 

can we implement DELTA RECORD Loading without using Table Comparision any help

kumarminfo
Explorer
0 Kudos

Can we implement DELTA RECORDs (Insetr/Update/Delete) Loading  without using Table Comparision

EX :

Table A :

EID ENAME SALARY

100  ABC      1000

101  XYZ       2000

102  DFG       3000

104   Pavan     9000 (While implementing the Delta's We need to Delete the  this record "104   Pavan     9000"

This is Initial Load (Master Data)

After Delata loaded in the same table

In the same table (Table : A)  Delta's are loaded

EID ENAME SALARY

100  ABC      5000-----Update

101  XYZ       2000

102  DFG       3000

103   HARI     8000------Insert

104   Pavan     9000------Delete(Because in Delta these record is not present)

So can you please give me brief discussion on this ...Thanks in Advance

Accepted Solutions (0)

Answers (2)

Answers (2)

kumarminfo
Explorer
0 Kudos

Hi Ancy,

In Target Table -->Options Tab --> Use the Auto Correct Load Option and Use Input Keys The Above requirement is work??

Can you please help me on this ??

Former Member
0 Kudos

Hi Pavan,

Auto correct load will not work for delete.

It is usually used to avoid duplicate data load.(while recovery)

Thanks,
Ancy

former_member208363
Active Participant
0 Kudos

Curious to know.

WHy you don't want to use table comparison?

kumarminfo
Explorer
0 Kudos

Hi Arjun,

This is my Requirement ....

Former Member
0 Kudos

Hi Pavan,

Let me know if it worked.

Thanks,
Ancy

Former Member
0 Kudos

Hi Pavan,

Can you try using the below:

We need 2 joins :

1) Source left outer target - for insert/update

2) Target left outer source - for delete

Case 1:  insert/update

1) After join check if EID is present is null, if null mark a flag field as 'I'

2)If not null check if any fields are changed i

ie. src.ENAME = tgt.ENAME or src.SALRY = tgt.SALRY ..

if changed mark the flag as 'U'

3)Use a MAP_CDC transform and update/insert the target. Use the flag field as row opertaion type

Case 2: Delete

1)  After join check if EID is present is null, if null mark a flag field as 'D'

2)Use MAP_CDC

or

After join filter the no match records and use EID field to delete from target using map_opertaion.

Opertaion type for normal should be delete.

Thanks,
Ancy

kumarminfo
Explorer
0 Kudos

Thank you Ancy  for Quick reply ....Let me check and let you know