In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 14494 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subbuchamala
Normal lookup:-
If we have 90% data in primary like(source
table) and 10% data of Refference link(lookup table)in kind
of sutivation we can use normal lookup.and the normal
lookup data can stores in the temporary memory(RAM).
Sparse lookup:-
If we have 10% data in primary like(source
table) and 90% data of Refference link(lookup table)in kind
of sutivation we can use sparse lookup.and the sparse
lookup data can not stores in the temporary memory because
Refernce will have Huge data and for record(KEY Columns) from Source it will go to Reference Database and get the Output of it.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the features of datastage flow designer?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How do you schedule or monitoring the job?
Is the value of staging variable stored temporarily or permanently?
What are the stages in datastage?
What is a folder? Difference types of stages?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Which commands are used to import and export the datastage jobs?
What are the processing stages?
What is the precedence of stage variables,derivations, and constraints?
What is the difference between operational data stage (ods) and data warehouse?
Have you used Unstructured data?
Whats difference betweeen operational data stage (ods) and data warehouse?
Define orabulk and bcp stages?
how can we create rank using datastage?what is the meaning of rank?
