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
Is the value of staging variable stored temporarily or permanently?
What are data elements?
What are the different types of lookups in datastage?
What is the importance of the exception activity in datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
How to clean the datastage repository?
What could be a data source system?
How many types of stage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Why we use surrogate key?
If you want to use the same piece of code in different jobs, how will you achieve it?
Describe the architecture of datastage?
How do you run datastage job from the command line?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
describe the Steps to confiure a Qlogic switch