1.

Define The Record Modes For Delta (assume For Example The Sales Qty Changed From 20 To 10)?

Answer»

a. Before IMAGE : before the record got changed; in this CASE it is 20.
B. After image: after the record got changed; in this EXAMPLE it is 10. 
c. Additive image: in this case only the difference; ie -10. 
d. Reverse image — used for deletion; reverse with the qty to NULLIFY
e. Delete image — only the ODS keys are given for deletion; not supported for cubes.

a. Before Image : before the record got changed; in this case it is 20.
b. After image: after the record got changed; in this example it is 10. 
c. Additive image: in this case only the difference; ie -10. 
d. Reverse image — used for deletion; reverse with the qty to nullify. 
e. Delete image — only the ODS keys are given for deletion; not supported for cubes.



Discussion

No Comment Found

Related InterviewSolutions