Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Explain the importance of surrogate key in data warehousing?

1128


On which interface you will be working as a developer?

986


What are the types of containers in datastage?

1143


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

2042


AGGREGATOR default datatype

1387


What are the different options associated with dsjob command?

1371


project Steps,hits, Project level HArd things,Solved methods?

2064


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.

3264


Define repository tables in datastage?

1099


What is the project in datastage?

1047


How to read multiple files using a single datastage job if files have the same metadata?

1176


Can you explain kafka connector?

1244


What is the roundrobin collector?

1038


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2757


Difference between data warehousing and olap?

1042