Which type of joins Merge stage can support?
Answers were Sorted based on User's Feedback
Answer / nagaraz
MERGE STAGE CAN SUPPORT INNER JOINT AND LEFT OUTER JOINT
Is This Answer Correct ? | 32 Yes | 0 No |
Answer / rajeshchunduri
merge supports only inner and left outer join.
chunduri
Is This Answer Correct ? | 15 Yes | 0 No |
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 |
Answer / sai
Merge will support inner join(Drop) and Left outer join
(Keep)
Is This Answer Correct ? | 6 Yes | 0 No |
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 |
Answer / arshad basha
merge stage doesn't support inner and left outer join.
Is This Answer Correct ? | 1 Yes | 29 No |
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are the main differences you have observed between 7.x and 8.x version of datastage?
what is the exact difference between dataset and fileset in datastage?
how to convert rows into columns
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
Is the value of staging variable stored temporarily or permanently?
What are the job parameters?
What is difference between join, merge and lookup stage?
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
Difference in the implementation of lookup and join stages,in joining two tables?
What is datastage?
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?