Flat File

Flat files are data files that store records with no structured relationships. You can define the data source of a flat file present locally or on a remote server.

Flat-File present in local data source resides in the staging area of the Infrastructure Database Server. Additional metadata information such as file format properties is required to interpret these files. Flat-File present on a remote server can be accessed through FTP connection to load the remote data-file into the Staging area of the Infrastructure Database Server.

The Data Source for a Flat-File serves the purpose of logically grouping a set of Flat-Files getting loaded into the Warehouse from a defined source application.