Interested to Buy Any Domain ? << Click Here >> for more details...
In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 15930 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subbuchamala
Sparse LookUp:
for each source value, It will go refernce Database and get the Output.
Normal lookup:- 90% data in primary like(source
table) and 10% data of Refference link(lookup table)then we can use normal lookup.and the normal
lookup data uses in the temporary memory(RAM).
Sparse lookup:- 10% data in primary like(source
table) and 90% data of Refference link(lookup table)then we can use sparse lookup.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is the value of staging variable stored temporarily or permanently?
What is quality stage?
What are the differences between datastage and informatica?
Define APT_CONFIG in Datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are the different options associated with dsjob command?
How rejected rows are managed in datastage?
Define Data Stage?
Name the different sorting methods in datastage.
How can you write parallel routines in datastage PX?
Difference between sequential file and data set?
What are the partitioning techniques available in link partitioner?
What are the different types of lookups in datastage?
What is the difference between odbc and drs stage?
Difference between data warehousing and olap?
