You probably know that you can and must validate the integrity of your Data Model using the Metadata Manager Tool workbench (MET), but you can also do much more. In this blog I focus on three additional things you can do with the MET.
Once you have used MET to obtain a valid Data Model, you can continue using MET to:
Migrate your project from development to test, and to production via change lists.
A change list is a list of changes in XML format to make a target repository (whether test or production). There are two kinds of change lists:
- A creation change list is the result of exporting the contents of a repository. Creation change lists represent an entire repository. They are used as sources for “import” and “promote” operations.
- A comparison change list is the result of comparing the contents of two repositories and generating a list of changes to make to the target repository. Comparison change lists are used when promoting design objects, (e.g. updates).
This is a screenshot of Informatica Metadata Manager Tool. Highlighted are all the functions available for you to use within the MET.
1. View your data model schema in the Graphical Model View
You can use the Schema Viewer icon in the MET to display a graphical view of the data model for any repository or loaded from an XML file. The Schema Viewer is particularly helpful for visualizing a complex schema, graphically showing base objects and foreign-key relationships in the schema. The Schema Viewer gives you the ability to visually examine an existing schema before applying changes to it or exporting its metadata to a change list.
2. Use the MET Command language.
This is an advanced topic that may be applicable to Informatica MDM Hub (Master Data Management) Developers and Administrators. I include it here because it is important to automate and script the operations in production.
Met Command is a command-line interface which includes:
- applyChangeList to Apply a change list
- createChangeList to Create a change list
- getOrsMetadata to Export metadata to the specified file
- validateChangeList to Validate a change list
- validateMetadata to Validate a repository.
Here is an example using Get Metadata:
- metcommand -getOrsMetadata -sourceOrsId localhost-orcl-cmx_ors2 The ORS Metadata has been written to: localhost-orcl-cmx_ors2.change.xml
MET will continue to grow in features to help you sustain, grow and administrate your Informatica MDM Hub. Please post your comments below, send your comments to Informatica University or join our community discussion at the Informatica University LinkedIn Group.
For more information about MET, visit the Metadata Manager Guide. Registration is required to download it.