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 |
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me
How do you design PX Routines ?
How many Key we can define in remove duplicate stage?
What is the difference between datastage and informatica?
How to convert table data into xml file using xml output stage? please explain step by step;
Does datastage support slowly changing dimensions ?
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
ename like ibm,tcs,hcl need display those records only how?
how many types of sorting the data in data stage?