ETL Studio 3.3 does not have a transformation which will write a data step merge. You can substitute a SQL Join transformation. You have two options at this point:
1. Let ETL Studio generate the SQL code for you while you set the properties
2. Use your own code that you specify in the Properties tab.
Remember that you can only have 1 output using this approach.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of
SUBSCRIBE SAS-L Kedar Shakargouda
Sent: Wednesday, June 21, 2006 6:03 AM
Subject: Merge in ETL Studio
Can Any body how to perform merge operation of 5 dataset in ETL