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
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Why do you need stage variables?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the sortmerge collector?
What is datastage?
Enlist various types of routines in datastage.
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)
How a server job can be converted to a parallel job?
What are the important features of datastage?
What could be a data source system?
Highlight the main features of datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Differentiate between Join, Merge and Lookup stage?
What is job control?
Define oconv () and iconv () functions in datastage?
