which memory is used by lookup and join

Answer Posted / naren

join is use the disc memory,look up use the buffer memory(ram)

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain usage analysis in datastage?

657


Is it possible to query a hash file?

1569


Notification Activity

903


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

545


What are the main features of datastage?

668






What is active and passive stage?

887


Difference between server jobs & parallel jobs?

657


How to reverse the string using SQL?

898


What is use Array size in datastage

1313


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1638


What is the difference between odbc and drs stage?

645


Explain ibm infosphere information server and highlight its main features?

615


Can you define merge?

670


How a source file is populated?

620


Give an idea of system variables.

593