Answer Posted / naresh
Sparce Lookup : if u use normal lookup it takes the entire
table into memory and perform lookup..coming to sparce
lookup it directly perform the lookup in database level.
one more difference is we can update the data into reference
tables.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
On which interface you will be working as a developer?
How to RD using transformer?
What are routines in datastage? Enlist various types of routines.
How to perform incremental load in datastage?
What is process model?
Give an idea of system variables.
What are the main differences you have observed between 7.x and 8.x version of datastage?
How can we improve performance of data stage jobs?
Explain usage analysis in datastage?
What is job control?
What are stage variables, derivations and constants?
What is oci?
Difference between server jobs & parallel jobs?
Explain how a source file is populated?
How and where you used hash file?