Question

What are the different mapping design tips for Informatica?

Answer 1

The different mapping design tips are as follows:

1. Standards - The design should be of a good standard. Following a standard consistently is proven to be beneficial in the long run projects. Standards include naming descriptions, conventions, environmental settings, documentation and parameter files, etc. 
2. Reusability - Using reusable transformation is the best way to react to the potential changes as quickly as possible. applets and worklets, these types of Informatica components are best suited to be used. 
3. Scalability - It is important to scale while designing. In the development of mappings, the volume must be correct. 
4. Simplicity - It is always better to create different mappings instead of creating one complex mapping. It is all about creating a simple and logical process of design 
5. Modularity - This includes reprocessing and using modular techniques for designing.