Database Reference
In-Depth Information
Working with flat files - the Import option
In the previous section, we discussed about importing the relational tables. Before we start
working on importing the flat files, we will discuss some important aspects about flat
files.
Flat files are of two types: delimited and fixed width. They are explained as follows:
• In delimited files, the values are separated from each other by a delimiter. Any
character or number can be used as delimiter, but usually for better interpretation
we use special characters as delimiters. In delimited files, the width of each field
is not a mandatory option as each value gets separated from the other using a de-
limiter. Please see the following screenshot to understand a delimited file. The de-
limiter used in the file is a comma (
,
).
