You can export the contents of a mapping model file to
a file in comma separated values (CSV) format by using a wizard. After
the contents of the mapping model are in CSV format, they can be easily
imported into other tools (for example, spreadsheets). You can use
this feature to more easily view mapping model contents and also communicate
information about mapping models to team members who do not have access
to the workbench.
Before you begin
Create a mapping model in a data design project.
About this task
When you export a mapping model to a file in CSV format,
the contents of the mapping model are transformed as follows:
- For one-to-one mappings, the resulting CSV file contains one row
for each mapping.
- For many-to-one mappings, there are multiple rows, one for each
source and target pair.
The following mapping model elements are included in
the CSV file:
Mapping model element |
Description |
Mapping status |
Identifies whether the mapping has been proposed
or accepted. A proposed status means that a relationship has been
discovered, but has not been explicitly accepted as a mapping. |
Mapping annotations |
User-defined annotations that provide additional
information about the mapping. These annotations are added to the
CVS file at the end of the row for each mapping. For example: Annotation1
– Value1, Annotation2 – Value2 |
Source and target node information |
Information about the source and target nodes,
including:
|
Source and target table information |
Information about the source and target tables,
including:- Name - for example: Table1
- Owner (Schema)
|
Procedure
To export a mapping model to a file in CSV format:
- Click from the main menu.
- On the first page of the wizard that opens, expand the
Data node, select Export a mapping model to a file in CSV
format, and click Next.
- Specify an existing mapping model to export, and specify
a name and location for the CSV file. You must specify
a new CSV file.
- Click Finish.
Results
The contents of the mapping model are transformed into CSV
file format, and the resulting file is saved in the location that
you specified.