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 are system variables and sequencers in datastage
what is the use of surogate key in datastage
what is 'reconsideration error' and how can i respond to this error and how to debug this
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are the different kinds of views available in a datastage director?
EXPLAIN SCD
What are the different type of jobs in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the types of hashed files in data stage
Name the third party tools that can be used in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Define Merge?
Where do the datastage jobs get stored?
Is possible to create skid in dim,fact tables?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu