what is sparse lookup?

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


Please Help Members By Posting Answers For Below Questions

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2268


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2024


whom do you report?

1500


How the ipc stage work?

667


how do u catch bad rows from OCI stage? And what CLI stands for?

2279






root tree will find which is server job and which is parallel job?

1443


Define orabulk and bcp stages?

671


What is the use of datastage designer?

634


Why do we use link partitioner and link collector in datastage?

679


Could anyone give brief explanation bout datastage admin

1965


What is the purpose of interprocessor stage in server jobs?

1722


To see hidden files in LINIX?

941


Describe the main features of datastage?

650


How a routine is called in datastage job?

601


How and where you used hash file?

653