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
What are the repository tables in datastage?
What are stage variables and constants?
Why fact table is in normal form?
how to sort two columns in single job in datastage.
what is use of SDR function?
How can we improve performance of data stage jobs?
What are the important features of datastage?
What are the components of ascential data stage?
Explain connectivity between datastage with datasources?
Define Data Stage?
What could be a data source system?
Define Routines and their types?
To see hidden files in LINIX?
What is quality stage?
what is the use of materialized view?