Answer Posted / subbuchamala
-->LOOK-UP runs based on physical memory(RAM).
While doing Look-Up, Data will be loaded into the Physical Memory(RAM) which faster and better for LOW Valume of data.
-->JOIN Uses the Buffer Memory(disc memory)
Buffer Memory(disc memory)--> this path is specified in the Configuration file and parameter name is: SCRATCH DISK path
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How the ipc stage work?
What is the method of removing duplicates, without the remove duplicate stage?
What are system variables and sequencers in datastage
What is ibm datastage flow designer?
How we can covert server job to a parallel job?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
root tree will find which is server job and which is parallel job?
What are sequencers?
what is the use of skid in reporting?
Can you explain engine tier in information server?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
table actions available in oracle connector?
What are the types of containers?
How to implement complex jobs in data stage?
What is the project in datastage?