what is sparse lookup?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the functionalities of link collector?

629


How do you schedule or monitoring the job?

675


how many rows sorted in sort stage by default in server jobs

3565


What are the different kinds of views available in a datastage director?

609


In Datastage, how you can fix the truncated data error?

643






Nls stands for what in datastage?

730


What can we do with datastage director?

678


What all the types of jobs you developed?

669


How do you reject records in a transformer?

632


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1671


Can you explain how could anyone drop the index before loading the data in target in datastage?

901


Is it possible to query a hash file?

1569


How to read the length of word in unix?

888


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1053


What is the use of datastage director?

594