MapGen Plus, as we call it, is not just one utility, but rather a collection of various tools and utilities available on Marketplace. When put together, it enables you to generate scores of mappings with a single command. Following are the required component to put MapGen Plus to work. 1) DBMetadata: This tool is included in the download file. DBMetadata allows you to connect to any popular relational databases and lets you generate PowerCenter compatible source and target definition quickly in the XML file format. These definitions are needed to generate the mapping. 2) Visio Templates: These are the building blocks for generating the mapping. You can choose one of the available Visio templates e.g.
- Dimension Building: SCD 1,2 or 3
- Mapping to load staging area
- Data Cleansing mappings
- And more?
- Informatica PowerCenter 9.1 and above
- Microsoft Visio 2007 and above
- Informatica Add-in for Visio