In which situations we can use normal and sparse lookup
stages
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
What are the components of ascential data stage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Explain entity, attribute and relationship in datastage?
How to implement complex jobs in data stage?
Define meta stage?
Triggers,VIEW,Procedures
What is the purpose of interprocessor stage in server jobs?
How a routine is called in datastage job?
How do y read Sequential file from job control?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
options available in sequence job to run,validate?
what is the use of materialized view?
What is the command line function to import and export the ds jobs?
Nls stands for what in datastage?