In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 14495 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
What are routines in datastage? Enlist various types of routines.
how to write server Routine coding?
what is the difference between == and eq in UNIX shell scripting?
How do you reject records in a transformer?
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 ibm datastage?
What are stage variables and constants?
Explain how a source file is populated?
What are the types of jobs we have in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
how to implement scd2 in datastage 7.5 with lookup stage
Is the value of staging variable stored temporarily or permanently?
Where the datastage stored his repository?
In Datastage, how you can fix the truncated data error?
Can you explain repository tables in datastage?
