Flat File Data Load

The applicationdoes not allow to overwrite any column or change the data type of existing data.

The supported file types are: .xls  .csv  .xlsx

 

pron:  quick and easy data load

con:    No delta logic available , no transformation capabilities

 

 

if a .xls or .xlsx file is selected, choose the corresponding worksheet.

if a .csv file is selected, select a delimiter. A delimiter is used to determine columns and pick correct data against them. In a .csv file , the accepted delimiters are , ;