Bulk Bind Procedure
The bulk bind procedure is only available for Oracle. It uses memory arrays to join all the information before writing it to the table. It can be the fastest method of performing a stage table update when a lot of dimension joins are being used.
Note: The bulk bind procedure is only available for Oracle.
There are also some options available in this dialog:
Allow modification of the Where clause. The where clause dialog is displayed automatically if the table has more than one source table, but not for a single source table stage table unless this option is chosen.
Distinct data select. Choosing this option adds the DISTINCT key word to the SELECT statement in the staging procedure.
Use Minimal Logging (for set insert). DB2 only. The staging procedure uses the LOAD FROM CURSOR option in DB2 to minimize database logging.
Insert hint. SQL Server only. Enter a database hint to be used in the INSERT statement.
Update hint. SQL Server only. Enter a database hint to be used in the UPDATE statement.