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 to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
what is use of SDR function?
How do u convert the columns to rows in datastage?
What is ds designer?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Why do we use exception activity in Datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is merge stage?
Is the value of staging variable stored temporarily or permanently?
how to write server Routine coding?
How a source file is populated?
How will you move hashed file from one location to another location?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is ibm datastage?