At the max how many tranformations can be us in a mapping?

Showing Answers 1 - 5 of 5 Answers


  • Sep 27th, 2005

n number of transformations

  Was this answer useful?  Yes


  • Nov 4th, 2005

22 transformation, expression, joiner, aggregator, router, stored procedure etc. You can find on Informatica transformation tool bar.

  Was this answer useful?  Yes


  • Nov 10th, 2005

In a mapping we can use any number of transformations depending on the project, and the included transformations in the perticular related transformatons.

  Was this answer useful?  Yes


  • Dec 13th, 2005

There is no such limitation to use this number of transformations. But in performance point of view using too many transformations will reduce the session performance. 

My idea is "if needed more tranformations to use in a mapping its better to go for some stored procedure."  


  • Mar 22nd, 2006

Always remember when designing a mapping: less for more

design with the least number of transformations that can do the most jobs.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions