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 active and passive stage?
What is the different type of jobs in datastage?
Can you explain repository tables in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Define Data Stage?
What is the difference between odbc and drs stage?
What are the steps needed to create a simple basic datastage job?
Why we use surrogate key?
What are the difference types of stages?
What is the differentiate between data file and descriptor file?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
State the difference between an operational datastage and a data warehouse?
Is it possible to query a hash file?
How you Implemented SCD Type 1 & Type 2 in your project?