Table of Contents

Search

  1. Preface
  2. Introduction to Enterprise Data Manager
  3. Enterprise Data Manager
  4. ILM Repository Constraints
  5. Partition Exchange Purging
  6. APIs
  7. Salesforce Accelerator
  8. SAP Application Retirement Entities
  9. Import Formats for Constraints
  10. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

CSV File Format

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 matches in the child column.
CHILD_UNMATCHED
Optional. Percentages of values in the child column that do not have 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 example shows sample rows of a CSV file:

0 COMMENTS

We’d like to hear from you!