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 |
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.
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
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?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
how to create document in datastage?
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
What is APT_DUMP_SCORE?
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
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?
What is the flow of loading data into fact & dimensional tables?
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