Data Warehouse Sources › CSV File Column Description Format

CSV File Column Description Format

You must format the column descriptions in the CSV file that you want to import as specified below. Otherwise, you will not be able to import the file.

Unique ID

A unique number for a column

Column Type

Must always be set to "DWXC"

Diagram ID

Must always be set to 0 (zero)

Table ID

A unique identifier for the table that contains this column

Table Type

Must always be set to "DWXT"

Column Sequence Number

A number that identifies the order in which columns appear in the Detail tab of the Data Warehouse Sources dialog; the range is 0 to n

Column Name

The name of the column

Data Type

The data type of the column

Comment

The comment associated with a column

More information:

CSV File Table Description Format

Sample Data Warehouse CSV Source File