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
Give an idea of system variables.
Why do we use link partitioner and link collector in datastage?
What are some prerequisites for datastage?
How do you start developing a datastage project?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the different common services in datastage?
Differentiate between datastage and informatica?
What all are the different way to run a job?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
If you want to use the same piece of code in different jobs, how will you achieve it?
What is a merge in datastage?
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?
How a routine is called in datastage job?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How can you write parallel routines in datastage PX?
