Used to define the method used to insert data into the database table.
If left blank, then the system defaults to the "Batch" method.
"Batch" will cause the system to load the records using mulitiple insert statements. After each batch of commands is sent the database system will update any existing indexes and fire any defined triggers.
"Bulk" will cause ETL to use the high speed bulk loading API provided by the destination database system. ETL will automatically generate any required format and data files.
Bulk loading is currently available for Microsoft SQL, MySQL, and Oracle database servers. Many bulk loading APIs do not provide support for complex data types such as image or blob. |