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)

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

5 Answers   TCS,

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers   HCL,

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

Describe stream connector?

0 Answers  

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

What is a folder? Difference types of stages?

0 Answers  

How we can convert rows to columns in datastage?

4 Answers   IBM,

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,

Give an idea of system variables.

0 Answers  

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,