SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How to highlight add input/add output in DI Studio 3.4 in transformations

Reply
Contributor SYN
Contributor
Posts: 39

How to highlight add input/add output in DI Studio 3.4 in transformations

I have to add three tables to my user written transformation. But add input/add input is not highlighting.

Can you please anybody help me on this. Thanks in advance.

Super Contributor
Posts: 349

Re: How to highlight add input/add output in DI Studio 3.4 in transformations

Hi,

If I remember properly in 3.4 version you cannot add input/output in the transformation,but you can add three user written code transformation for three tables and then append or do a SQL join what ever you want.But for sure in 4.2 version of DI this can done very easily by just doing drag and drop.

eg: table1----> user written code

     Table2----->User written code

     Table3----->User written code

or in one user written code write you code in properties--->process---->userwritten---->edit and all the code you want to write.

If I am wrong please correct me.

Thanks,

Shiva

Super User
Posts: 5,260

Re: How to highlight add input/add output in DI Studio 3.4 in transformations

If I recall right, the last screen in the Generated Transform wizard, you can specify the minimum and the maximum no of inputs and outputs to the transformation. This should also be available at the properties window of the transformation object (in the inventory/Custom tree).

http://support.sas.com/onlinedoc/913/docMainpage.jsp?_topic=etlug.hlp/a003162717.htm

Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 186 views
  • 0 likes
  • 3 in conversation