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

[SYN]

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.

[shivas]

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

[LinusH]

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