Number of I/P & O/P connection per transformer

svga · Post by **svga** » Fri Apr 17, 2009 5:36 am

Hi,

Are there any limitation to the number of input and output connections and stage variables per transformer stage?

ray.wurlod · Post by **ray.wurlod** » Fri Apr 17, 2009 5:42 am

Number of connections yes, number of stage variables no.

How many do you want to have to maintain?

svga · Post by **svga** » Fri Apr 17, 2009 7:26 am

I have 35 inputs (lookups) & 35 output links.Will I have more impact on performance?

chulett · Post by **chulett** » Fri Apr 17, 2009 8:17 am

More than what?

ray.wurlod · Post by **ray.wurlod** » Fri Apr 17, 2009 2:50 pm

Every object in the job design is more work. Each link is an object.

svga · Post by **svga** » Sat Apr 18, 2009 8:18 am

Will the job get hanged if I use 35 i/p and 35 o/ps?. Pls give me the max no of connection (i/p & o/p) that is possible per transformer.

chulett · Post by **chulett** » Sat Apr 18, 2009 11:35 am

No, not simply because of that and any 'max' would be theoretical and based on too many factors to list here or worry about. A lookup is a lookup, whether it's 35 on one transformer or 35 split across two or more transformers. Perhaps with multiple transformers and IPC use so that multiple processes are created you would be better off, but the same amount of work would still be done.

svga · Post by **svga** » Mon Apr 20, 2009 3:24 am

Thanks for your answer....