System is a tool, similar to a machine, can be divided into these categories:
1. Operational tools---------------------only for users, data entry operation OLTP
2. Processing Tools---------------------Calculate the data according to the business model, then give a result to the user OLTP
3. Analytical tools----------------------Multi-dimensional analysis of data OLAP
But some systems, the acquisition of data is very troublesome, for example, a cost accounting system, the basis is all from other systems, so customers need to export the required data in other systems (sub-Library sub-table is not shared), this time there is a lot of work, such as export files, manual processing of files before importing the system, for accounting.
is a data import process: ETL, of course, can use professional tools, but now like the version of Oracle, although the function is very powerful, but the project is only a few functions, because the needs of the scene, there is no need for some advanced features, and a professional ETL tools, Perhaps more expensive than the customer's system, may use it???? , so you have to do the job, the total work for people to do it!!! This is also the current display requirement.
==========================
Sql-load: A dedicated Data import processing solution
Write a configuration file and your data file
In fact, the current ETL tool ideas and sql-load a bit similar, such as the core: caching mechanism, batch processing mechanism, exception handling mechanism, data compensation mechanism.
Oracle Import Database