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 |
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
1)Source file contains one record, I want 100 records in target file.
Difference between sequential file and data set?
If the job aborted in a sequencer, how can we start that from the previews successful job.
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
Give an idea of system variables.
How to get max salary of an organization using data stage stages........... can any body help me plz.......
What are the features of datastage flow designer?
What are the various kinds of containers available in datastage?
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please
What is datastage engine?