Interested to Buy Any Domain ? << Click Here >> for more details...
In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 16071 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 types of containers in datastage?
Why do we use link partitioner and link collector in datastage?
What is the command line function to import and export the ds jobs?
How to read the length of word in unix?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is a quality stage in datastage tool?
What are routines in datastage? Enlist various types of routines.
What is the difference between in process and inter process?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How many Key we can define in remove duplicate stage?
what is repositery?
How to find value from a column in a dataset?
What is the differentiate between data file and descriptor file?
how do u catch bad rows from OCI stage? And what CLI stands for?
Define Merge?
