what is sparse lookup?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

table actions available in oracle connector?

1099


What are the partitioning techniques available in link partitioner?

1760


What are the types of hashed files in data stage

649


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

551


client know skid info?

1638






What is ibm datastage flow designer?

692


Where the datastage stored his repository?

621


Explain usage analysis in datastage?

657


What are sequencers?

618


How we can covert server job to a parallel job?

601


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

2738


what is flow of project?

1561


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1640


What are the types of containers?

695


Define oconv () and iconv () functions in datastage?

886