Interested to Buy Any Domain ? << Click Here >> for more details...
what is sparse lookup?
- 7 Answers
- 31665 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramya
use sparse lookup when reference database is huge i.e ratio
of input data and reference data is 1:100 or more
| Is This Answer Correct ? | 37 Yes | 7 No |
Answer / venugopal
When the reference data is more and source data is very
very less at that time we are using the Sparce lookup i.e
the ratio is 1:100
| Is This Answer Correct ? | 23 Yes | 5 No |
Answer / prasad
whenever the reference data is very huge than the primary
data then it will be problem for usig lookup stage,b'se the
data stored in buffer in lookup stage.using sparse lookup we
can perform the lookup in database level not in the
buffer,so the performance can be automatically improved...
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / chenna
sparse lookup has more memory so that if reference table
contains huge amount of data perfer to use sparse lookup
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / ananda
Join: When volume of data is more than 10 million in both
source and reference link.
Sparse Lookup: When reference data is > 500 million and
source data is <10 million.
| Is This Answer Correct ? | 2 Yes | 8 No |
Answer / vin
If reference data is huge then we will go for join stage.
Then when we will use join and sparce is useful?
| Is This Answer Correct ? | 1 Yes | 15 No |
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
how to call routines in stages?
What are the components of datastage?
How to transfer file from one system to another system in UNIX?which command to be use?
If the job aborted in a sequencer, how can we start that from the previews successful job.
Name the command line functions to import and export the DS jobs?
Can aggregator and transformer stages use to sort the data? How ?
How to reverse the string using SQL?
what is the Difference Between Datastage Server Edition and Parallel Edition?
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
Teradata 
