05-28-2012 05:20 AM
I have a requirement in DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE.
I have SAS user written code it is using 3 input tables and creating 5 output tables.
Now I have to impliment this existing code in DATA INTEGRATION STUDIO 3.4 using USER WRITTEN CODE transformation.
Can any one help me to give me the process flow for this requirement.
How can I connect 3 input tables to SER WRITTEN CODE transformation and how can i connect 5 output tables.
05-28-2012 05:34 AM
Well, 3.4 isn't quite flexible, and you would love to upgrade...
From the documentation 3.4 about User Written Code:
"This approach works particularly well with jobs that need quick custom code or require only one input and output and no parameters."
Since I'm on 4.21 I can't really test this, bit I think you can use the SQL Join transform, and make that "User Written".
Perhaps you can split you code logic, and use part of it in a succeeding Split transform to handle multiple outputs?
05-28-2012 06:17 AM
Thank you for your comment LinusH.
There is no other go, we need to use DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE.
Provide me exact flow for this requirement. Thanks in advance
05-28-2012 06:26 AM
since I don't have 3.4 no more, It's hard to provide exact instructions.
You'll have to experiment around my guidelines...