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

My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers   Wipro,


Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  


1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,


I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,


i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  






how to create document in datastage?

1 Answers   Cap Gemini,


what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

2 Answers   Satyam,


What is APT_DUMP_SCORE?

2 Answers   IBM,


I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers   IBM,


What is the flow of loading data into fact & dimensional tables?

0 Answers  


how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,


Categories