Which type of joins Merge stage can support?

Answers were Sorted based on User's Feedback



Which type of joins Merge stage can support?..

Answer / nagaraz

MERGE STAGE CAN SUPPORT INNER JOINT AND LEFT OUTER JOINT

Is This Answer Correct ?    32 Yes 0 No

Which type of joins Merge stage can support?..

Answer / rajeshchunduri

merge supports only inner and left outer join.

chunduri

Is This Answer Correct ?    15 Yes 0 No

Which type of joins Merge stage can support?..

Answer / chunduri

Its supports inner join by default and with a property it can support left outer join.

Is This Answer Correct ?    13 Yes 0 No

Which type of joins Merge stage can support?..

Answer / sai

Merge will support inner join(Drop) and Left outer join
(Keep)

Is This Answer Correct ?    6 Yes 0 No

Which type of joins Merge stage can support?..

Answer / narayana.3ds

Its supports inner join by default. but based on the link
ordering suports eightr left join and right join do.......

Is This Answer Correct ?    4 Yes 11 No

Which type of joins Merge stage can support?..

Answer / arshad nasha

by default it supports full outer join

Is This Answer Correct ?    0 Yes 24 No

Which type of joins Merge stage can support?..

Answer / arshad basha

merge stage doesn't support inner and left outer join.

Is This Answer Correct ?    1 Yes 29 No

Post New Answer

More Data Stage Interview Questions

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

0 Answers  


What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  


what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,


how to convert rows into columns

2 Answers   IBM,


Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,






Is the value of staging variable stored temporarily or permanently?

0 Answers  


What are the job parameters?

0 Answers  


What is difference between join, merge and lookup stage?

0 Answers  


i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,


Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,


What is datastage?

0 Answers  


1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,


Categories