Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is a merge in datastage?
how can we create rank using datastage?what is the meaning of rank?
What is the difference between in process and inter process?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the steps needed to create a simple basic datastage job?
What is the different type of jobs in datastage?
What is a quality stage in datastage tool?
Explain how a source file is populated?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is a datastage job?
How to convert RGB Value to Hexadecimal values in datastage?
Demonstrate experience in maintaining quality process standards?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
On which Dimension Table you implemented SCD Type in your Project
