Data Warehouse Sources › Sample Data Warehouse CSV Source File

Sample Data Warehouse CSV Source File

The following is an example of a data warehouse source file:

/*Table Descriptions*/
1,"DWXT",0,0,"DWXS",0,"EMPLOYEE",""
2,"DWXT",0,0,"DWXS",0,"DEPARTMENT",""

/*Column Descriptions*/
1,"DWXC",0,1,"DWXT",0,"emp_id","integer","Uniquely identifies an employee."
2,"DWXC",0,1,"DWXT"1,"emp_name","varchar(100)","The employee's name."

3,"DWXC",0,2,"DWXT",0,"dep_id","integer","Uniquely identifies a department."
4,"DWXC",0,2,"DWXT",1,"dep_name","varchar(100)","Name of a department."
5,"DWXC",0,2,"DWXT",2,"dep_desc","varchar(256)","Description of a department."

This file creates two tables, EMPLOYEE and DEPARTMENT. It also creates the emp_id and emp_name columns for the EMPLOYEE table, and the dep_id, dep_name, and dep_desc columns for the DEPARTMENT table.

More information:

CSV File Column Description Format

CSV File Table Description Format