Interested to Buy Any Domain ? << Click Here >> for more details...
In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 15733 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subbuchamala
Sparse LookUp:
for each source value, It will go refernce Database and get the Output.
Normal lookup:- 90% data in primary like(source
table) and 10% data of Refference link(lookup table)then we can use normal lookup.and the normal
lookup data uses in the temporary memory(RAM).
Sparse lookup:- 10% data in primary like(source
table) and 90% data of Refference link(lookup table)then we can use sparse lookup.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How you can fix the truncated data error in datastage?
Could anyone give brief explanation bout datastage admin
What are routines in datastage? Enlist various types of routines.
What are orabulk and bcp stages?
What is a quality stage in datastage tool?
What are the features of datastage flow designer?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the different types of lookups in datastage?
why do u need the IOS upgradation in a FC switch
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
To see hidden files in LINIX?
State the difference between an operational datastage and a data warehouse?
