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

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 Answers  

Nls stands for what in datastage?

0 Answers  

what is operator combinality in datastage?

1 Answers   TCS,

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

How do you remove duplicate values in datastage?

0 Answers  

What are some different alternative commands associated with "dsjob"?

0 Answers  

How to create user defined environment varibale(parameter)?

1 Answers   TCS,

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

How many Key we can define in remove duplicate stage?

0 Answers   CTS,

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers