Interested to Buy Any Domain ? << Click Here >> for more details...
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 read multiple files using a single datastage job if files have the same metadata?
What is the difference between hashfile and sequential file?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is the method of removing duplicates, without the remove duplicate stage?
Can you explain repository tables in datastage?
How to convert RGB Value to Hexadecimal values in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Can you highlight the main features of ibm infosphere information server?
What is the purpose of interprocessor stage in server jobs?
Triggers,VIEW,Procedures
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is the precedence of stage variables,derivations, and constraints?
how do u catch bad rows from OCI stage? And what CLI stands for?
If you want to use a same piece of code in different jobs, how will you achieve this?
