Skip to Content
0
Nov 27, 2014 at 12:42 PM

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

66 Views

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