Interested to Buy Any Domain ? << Click Here >> for more details...
In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 15740 Views
- IBM, I also Faced
- E-Mail Answers
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 |
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks
What is datastage?
What is orabulk stage?
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
how can we create rank using datastage?what is the meaning of rank?
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
What is difference between symmetric multiprocessing and massive parallel processing?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
Teradata 
