In which situations we can use normal and sparse lookup
stages
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / poornachandrababu.l
When the reference is database then we will go for Sparse
look and If reference is Sequential file or DataSet then
we go for normal look up
Is This Answer Correct ? | 6 Yes | 5 No |
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 |
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 |
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
What is the flow of loading data into fact & dimensional tables?
What is the project in datastage?
How can we run same job in 1 day 2 times
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Could anyone give brief explanation bout datastage admin
Triggers,VIEW,Procedures
What is process model?
How a source file is populated?
I have a few records all are same structures data, I want to store data in multiple targets how?
Can you explain engine tier in information server?