Connectors support multiple input links

shivadrash · Post by **shivadrash** » Tue Aug 09, 2011 12:08 am

Hi I have some queries regarding the new feature in Datastage 8.5 where
Connectors support multiple input links

I am not able to find a detailed spec about this new feature. But would like to know what is the advantage over using multiple connectors? How does it help in perfomance? What is limitation especially when we have huge tables and many input links.

Looking forward for your thoughts.

eostic · Post by **eostic** » Tue Aug 09, 2011 6:37 am

...it's so that you can manage more complex transactions.....having multiple SQL statements (ie..a link for table1 and a link for table2) on the same unit of work.

Ernie

chulett · Post by **chulett** » Tue Aug 09, 2011 7:39 am

It makes them more 'Server like' and as Ernie notes, they work thru a single connection in the same unit of work, so issues like parent/child loads can be simplified as a new child record would be aware of a new parent record inserted in the same transaction.