This section illustrates how to create and use ETL files.
In the ETL interface, you can define a database table or a text file as the source table and set up to import or export data from the source file. During the export setup, you can define dimension table mapping for an enumerated field coming from the source table through the numberized table. All settings in the ETL interface can be saved as an splx file in the form of SPL script. When esProc executes this splx file, it generates a result CTX or BTX file according to the exported setups. In the CTX/BTX file, the text type fields in the source table are transformed to numeric codes according to the predefined rule. The transformation can noticeably increase data querying efficiency, and the method is suitable for dealing with big data scenarios that call for high performance.