Loading data into a flat file
This recipe will teach you how to export information from a table into a flat file using Data Services.
Flat files are a popular choice when you need to store data externally for backup purposes or in order to transfer and feed it into another system or even send to another company.
The simplest file format usually describes a list of columns in specific order and a delimiter used to separate field values. In most cases, it's all you need. As you will see a bit later, Data Services has many extra configuration options available in the File Format object, allowing you to load the contents of the flat files into a database or export the data from a database table to a delimited text file.
How to do it…
- Create a new dataflow and use the
EMPLOYEE
table from the OLTP datastore imported earlier as a source object. - Link the source table with a Query transform and drag - and - drop all source columns to the output schema for mapping configuration.
- In the Query...