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
Explain the importance of surrogate key in data warehousing?
On which interface you will be working as a developer?
What are the types of containers in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
AGGREGATOR default datatype
What are the different options associated with dsjob command?
project Steps,hits, Project level HArd things,Solved methods?
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.
Define repository tables in datastage?
What is the project in datastage?
How to read multiple files using a single datastage job if files have the same metadata?
Can you explain kafka connector?
What is the roundrobin collector?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Difference between data warehousing and olap?