Rishi

• Dec 5th, 2005

 

As per my knowledge there is no such restriction to use this number of sources or targets inside a mapping.

Question is " if you make N number of tables to participate at a time in processing what is the position of your database. I orginzation point of view it is never encouraged to use N number of tables at a time, It reduces database and informatica server performance"

pat

• Dec 7th, 2005

 

the restriction is only on the database side. how many concurrent threads r u allowed to run on the db server?

reddeppa

• Jan 1st, 2006

 

there is one formula..

no.of bloccks=0.9*( DTM buffer size/block size)*no.of partitions.

here no.of blocks=(source+targets)*2