Interested to Buy Any Domain ? << Click Here >> for more details...
In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 16074 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nandini
Normal lookup:- U r having 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 temprovary memory.
Sparse lookup:-U r having 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 temprovary memory because
it s having the huge data.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
which r the connectors used in san?
What is the purpose of interprocessor stage in server jobs?
options available in sequence job to run,validate?
What is usage analysis in datastage?
root tree will find which is server job and which is parallel job?
On which interface you will be working as a developer?
How many types of stage?
Explain how a source file is populated?
In Datastage, how you can fix the truncated data error?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the repository tables in datastage?
Explain usage analysis in datastage?
How to manage date conversion in Datastage?
Can you filter data in hashed file?
how to implement scd2 in datastage 7.5 with lookup stage
