SQLLDR is a basic ETL tool to load data from a text file into an Oracle database table. The control file (filename.ctl) maps the file data to the Oracle table structure and some basic transformations (Oracle functions or custom functions) can be called during load, which can have some impact on the load performance (TO_DATE(:last_sold_date, 'YYYYMMDD') in example below). For direct loads, there cannot be any transformations. The example shown below is to execute SQLLDR in Microsoft Windows environment. The same can be setup as a UNIX/Linux shell script with necessary OS settings (ORACLE_HOME, bin directory etc.). The data file in this example is in csv format. |
On execution of the batch file, the user will be prompted for password. When executed in an automated load setup, the password will be passed by a parameter file. The files will be uploaded to designated directories, setup as database directories |
22133