Complex Mapping in Informatica

Hello all,

I am here to learn and share my knowledge about Complex Mapping in Informatica.

Complex Mapping are basically contains 'n' number of mappings based on the complex business logic. In General, Complex Mapping are controlled by the Informatica designers who chose it and develops according to the complex business logic. When we design the complex mappings, the designer should consider in terms of Manageability  Scalability & flexibility. Managing the Complex mapping is not easy unless it is designed in that way. In order to Maintain Complex mapping ,It is advisable to split the mappings in to multiple pieces. Designers should considered and  give equal importance to the Scalability, Flexibility & Maintainability while designing the complex mappings. Since complex mapping has lot of transformations, designer might face some challenges in modify or debug when there is a need. I personally feel that it is up to the designers choice the one who makes the call and control on it. Complex mapping should be easy to maintain, easy to extend & easy to scale.

Any Experts can correct me if i am wrong and kindly suggest me the best if you can on this complex mapping.