Answer / kala

Join use the buffer memory and Lookup use the physical memory(RAM)

Answer / kiran

Lookup runing based on RAM

Answer / 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

Answer / raam chowdary

join is used in permanent memory and lookup is used in buffer(ram)

Answer / naren

join is use the disc memory,look up use the buffer memory(ram)

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  

---

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  

---

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,

---

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?

0 Answers   HCL,

---

---

What could be a data source system?

0 Answers  

---

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

---

how to convert rows into columns

2 Answers   IBM,

---

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

---

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

---

what is snow flack schema?

2 Answers  

---

Differentiate between hash file and sequential file?

0 Answers  

---