what is sparse lookup?

Answers were Sorted based on User's Feedback



what is sparse lookup?..

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

what is sparse lookup?..

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

what is sparse lookup?..

Answer / naresh

Sparce Lookup : if u use normal lookup it takes the entire
table into memory and perform lookup..coming to sparce
lookup it directly perform the lookup in database level.

one more difference is we can update the data into reference
tables.

Is This Answer Correct ?    12 Yes 0 No

what is sparse lookup?..

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

what is sparse lookup?..

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

what is sparse lookup?..

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

what is sparse lookup?..

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

Post New Answer

More Data Stage Interview Questions

what is the unix script to run the job? Please mention commands which we use often?

3 Answers   TCS,


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers   Alpharithm Technologies,


I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 Answers  


I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,


HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,






What is ibm datastage flow designer?

0 Answers  


Explain usage analysis in datastage?

0 Answers  


Difference between sequential file and data set?

0 Answers  


What are the partitioning techniques available in link partitioner?

0 Answers  


DataStage Scenario based Interview Questions

1 Answers  


what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

2 Answers   Satyam,


what is initial load and incremental load

3 Answers   ADP,


Categories