In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 14958 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
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the method of removing duplicates, without the remove duplicate stage?
Can you implement SCD2 using join, transformer and funnel stage?
How to perform incremental load in datastage?
How can we improve the performance in datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
What is "fatal error/rdbms code 3996" error?
Define data aggregation?
What are the different layers in the information server architecture?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
how to write server Routine coding?
Where do the datastage jobs get stored?
What is the difference between Datastage 7.5 and 7.0?
What is a merge in datastage?
Can you explain kafka connector?
