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 datastage?
What all the types of jobs you developed?
How one source columns or rows to be loaded in to two different tables?
How many types of views are there in a datastage director?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Highlight the main features of datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Why do we use link partitioner and link collector in datastage?
how to delete one row in target dataset
What are the types of containers in datastage?
What is a ds designer?
root tree will find which is server job and which is parallel job?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Difference between data warehousing and olap?
What are the different common services in datastage?
