Interested to Buy Any Domain ? << Click Here >> for more details...
which memory is used by lookup and join
- 5 Answers
- 12908 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kala
Join use the buffer memory and Lookup use the physical memory(RAM)
| Is This Answer Correct ? | 14 Yes | 1 No |
-->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 |
Answer / raam chowdary
join is used in permanent memory and lookup is used in buffer(ram)
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / naren
join is use the disc memory,look up use the buffer memory(ram)
| Is This Answer Correct ? | 2 Yes | 2 No |
What are the different plug-ins stages used in your projects?
What are the different type of jobs in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
Can you explain kafka connector?
how can find maximum salary by using Remove duplicate stage?
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
how to identifie,is it innerjoin,leftouter join in lookup?
What is the command line function to import and export the ds jobs?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
What are the steps required to kill the job in Datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Teradata 
