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
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are sequencers?
Define oconv () and iconv () functions in datastage?
What is job control?
Terminate Activity
Define Merge?
What is the difference between the local container and shared container?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
why do u need the IOS upgradation in a FC switch
Why we use surrogate key?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is oci?
Why do we use link partitioner and link collector in datastage?
EXPLAIN SCD
How do u convert the columns to rows in datastage?
