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.
Prerequisite:Create a mapping model in a data design project.
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. |
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)
|
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.
The contents of the mapping model are transformed into CSV file format,
and the resulting file is saved in the location that you specified.