Advanced-etl-processor
Loading data from a Flat File(s)
Supported Flat File(s) formats
Data can be loaded from ASCII and Unicode files in UTf8, UTF16BE and UTF16LE formats with BOM marker and without
Unicode is a computing industry standard allowing computers to consistently represent and manipulate text expressed in most of the world’s writing systems.
To perform data mapping:
- Click Data Target Options button
- Dialog box will appear
- Select appropriate target type
- Click Get tables list
- Select Table you would like to import data into from the Drop Down List
- Click Transformation tab
- Select Add Records
- Click OK
- Click Data Source Option Button
- Dialog box will Appear
- Set Delimiter and Quota to appropriate values
Note: If you want to load data from several files specify a mask.
Click OK. Click and select the file you would like to import data from.
- Select Fist field in the Data Target fields list and drag and drop it above [F1] field.
You may change field mapping by using the mapping panel at any time.
How to perform Auto mapping
If the Data Source and Data Target have got the same fields’ names you may use the Automap feature.
Click
Now we are ready to import data.
Let’s check the script first.
(Click to check the script)
Here is an example of the error, the date format is missing.
Click to load data into the database
Once loading is finished you may check the Log file or the Rejected records file.
Video Tutorial
We have more videos on ETL-Tools.com YouTube Channel,
Please take a look and subscribe to stay updated with the latest content.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum