Answer / vinay kumar

join stage is the best,why means data getting from buffer
area.

Answer / swetha

use the join stage rather than using lookup and merge stages. join stage supports all the joins like inner join,leftouter join,right outer join,full outer join
lookup supports only inner,leftouter only

Answer / bharath

Hi,
Join stage is best 4 full outer join bcoz
lookup is RAM intensive where as join uses less memory.

Answer / rajesh

join stage

Answer / kiransitams

join is the best because join uses the less memory compare with lookup

What is a quality stage in datastage tool?

0 Answers  

How to Convert the columns into rows?

2 Answers  

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,

how to handle null values in sequential file?

1 Answers   HCL,

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

What is the use of datastage director?

0 Answers  

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers