what is sparse lookup?
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 |
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
What are the job parameters?
Enlist various types of routines in datastage.
How we can covert server job to a parallel job?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
What is apt_config in datastage?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
ename like ibm,tcs,hcl need display those records only how?
Differentiate between odbc and drs stage?