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 could be a data source system?
What are the types of containers and how to create them?
Explain connectivity between datastage with datasources?
How a source file is populated?
What all the types of jobs you developed?
What are the main features of datastage?
What is apt_config in datastage?
What is the use of datastage director?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the functionalities of link collector?
What are system variables and sequencers in datastage
Differentiate between hash file and sequential file?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How do you run datastage job from the command line?
Differentiate between operational datastage (ods) and data warehouse?
