Data Warehouse Sources › Overview of Importing Comma-Separated Values (CSV) Files
Overview of Importing Comma-Separated Values (CSV) Files
Using the Data Warehouse Sources dialog, you can manually define data sources or import source information from an existing database, script file, .erwin file, a model located in a mart, or comma-separated value (CSV) file. Before you can import a CSV file as a data source, you must create the file using your preferred text editor, and it must contain the following information:
- Table descriptions
- Column descriptions
Use the following guidelines when you create a CSV file that you want to import as a data source:
- Precede table and column descriptions by only a single comment section. The format for comments is /*<Insert comment here>*/.
- Precede column descriptions with table descriptions.
- Group column descriptions by the tables in which they are contained.
- Enclose text entries in double quotes.
- Embed blank lines in the file to increase readability. Blank lines are ignored when importing the file.
More information:
CSV File Column Description Format
CSV File Table Description Format
Sample Data Warehouse CSV Source File
