Enterprise Data Manager Guide

6.5
- 6.5.1
- 6.5 HotFix 1
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

CSV File Format

To import table relationships from CSV files, the CSV file must be in the required format. When you import the file, the Enterprise Data Manager imports the contents of the file to a table relationship suggestions table in the ILM repository.

The table relationship suggestion table dictates the format of the CSV file. The CSV file requires the following columns:

Column	Description
PARENT_SCHEMA	Schema of the parent table that contains the primary key.
PARENT_TABLE	Table that contains the primary key.
PARENT_COLUMNS	Column that contains the primary key. If you have more than one column that identifies the primary key, use the following separator between columns: #<Key column index># There is no limit to the amount of columns that can identify a primary key. To specify the end of a column, use the following separator: #<key column index> . For example, enter TICKET_NUMBER#1 if the primary key is based on one column. Enter TICKET_NUM#1#CREATION_DATE#2 if the primary key is based on two columns.
CHILD_SCHEMA	Schema of the child table that contains the foreign key.
CHILD_TABLE	Table that contains the foreign key.
CHILD_COLUMNS	Column that includes the foreign key.
OVERLAP_PERCENTAGE	Optional. Percentage of overlap between the parent and child columns. User defined value. You can enter any number. For example, you can use a range of 0-100. 0 is no overlap.
PARENT_UNMATCHED	Optional. Percentage of values in the parent column that do not have any matches in the child column.
CHILD_UNMATCHED	Optional. Percentages of values in the child column that do not have any matches in the parent column.

Use the following rules and guidelines when you create a CSV file:

When you discover relationships from CSV files, you import one file at a time.

You can include multiple schemas in the same file.

The header row is required.

All columns are required in the file. However, values for the

OVERLAP_PERCENTAGE

PARENT_UNMATCHED

, and

CHILD_UNMATCHED

columns are optional.

Enter one table relationship per row.

Case-sensitivity depends on the source database. Use the same case that the source database uses.

If you import a file that is not in the correct format, the Enterprise Data Manager cannot import the contents to the ILM repository.

Example

The following table displays sample rows of a CSV file:

PARENT_SCHEMA	PARENT_TABLE	PARENT_COLUMNS	CHILD_SCHEMA	CHILD_TABLE	CHILD_COLUMNS	OVERLAP_PERCENTAGE	PARENT_UNMATCHED	CHILD_UNMATCHED
LOYALTY	CUSTOMER	CUST_ID#1	LOYALTY	CUSTOMER_TICKET	CUST_ID#1	0	11	12
LOYALTY	TICKET	TICKET_NUM#1#CREATION_DATE#2	LOYALTY	TICKET_COUPON	TICKET_NUM#1#COUPON_DATE#2	0		22

Rename Saved Search

Table of Contents

Enterprise Data Manager Guide

Enterprise Data Manager Guide

CSV File Format

CSV File Format

Example