Consider the following rules and guidelines when you exchange metadata with BI or data modeling tools:
You can export and import relational source and target definitions.
You can import multiple source and target definitions at a time.
You can export multiple source definitions or multiple target definitions at a time. You cannot export source and target definitions at the same time.
You cannot export cubes and dimensions. However, you can export targets to some tools as dimensions.
You cannot export shortcuts.
When you export a source or target with a foreign key, the Repository Service also exports the source or target containing the corresponding primary key.
When you import metadata into PowerCenter through MIMB, keys and referential integrity constraints are not persisted.
You must have a Metadata Exchange option license to exchange metadata for a specific tool.