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 the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

detail about sdlc

4 Answers  

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers  

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,

How do you remove duplicate values in datastage?

0 Answers  

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  

What are the types of containers?

0 Answers  

how CAN we remove duplicates in dataset?

2 Answers   IBM,