Which type of joins Merge stage can support?

Answer Posted / rajeshchunduri

merge supports only inner and left outer join.

chunduri

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a quality stage in datastage tool?

632


How to clean the datastage repository?

697


What are constraints and derivations?

658


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2547


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1637






how to export or import the jobs in .ISX file

722


What steps should be taken to improve Datastage jobs?

642


Is the value of staging variable stored temporarily or permanently?

581


How many types of views are there in a datastage director?

837


How to reverse the string using SQL?

897


Can you explain kafka connector?

780


What are the features of datastage flow designer?

636


What are the difference types of stages?

624


sed,awk,head

972


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1903