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)

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

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  

---

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  

---

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

---

How do you register plug-ins?

0 Answers  

---

---

how to find out number of records imported into source file?

1 Answers  

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

Lookup constraints

0 Answers   CTS,

---

what is the difference between the join and look up explin me one exmple

3 Answers  

---

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

---

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,

---

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

---