Interested to Buy Any Domain ? << Click Here >> for more details...
In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 15745 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 is the difference between datastage and datastage tx?
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 a datastage job?
What is quality stage?
what is the difference between == and eq in UNIX shell scripting?
Notification Activity
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
root tree will find which is server job and which is parallel job?
what is use of SDR function?
table actions available in oracle connector?
Explain usage analysis in datastage?
Which commands are used to import and export the datastage jobs?
Can we use target hash file as a lookup ?
