Steps for bulk load in Oracle:
1) Use parallel direct path load using SQL loader with native option =
SKIP_INDEX_MAINTENACE=TRUE (use MFS layout in output table component)
2) You can define a generic db stored procedure to rebuild the indexes on
target table. Otherwise define a graph parameter and construct the index
rebuild sql statement (with online parallel option) by using
m_db command and PDL expression.
3) Use RUN SQL to call the db procedure/SQL parameter(constructed in graph
parameter) in order to rebuild the indexes.
4) analyze the table.
Ref : http://datawarehouse.ittoolbox.com/groups/technical-functional/abinitio-l/loading-mfs-file-to-oracle-table-4968984
1) Use parallel direct path load using SQL loader with native option =
SKIP_INDEX_MAINTENACE=TRUE (use MFS layout in output table component)
2) You can define a generic db stored procedure to rebuild the indexes on
target table. Otherwise define a graph parameter and construct the index
rebuild sql statement (with online parallel option) by using
m_db command and PDL expression.
3) Use RUN SQL to call the db procedure/SQL parameter(constructed in graph
parameter) in order to rebuild the indexes.
4) analyze the table.
Ref : http://datawarehouse.ittoolbox.com/groups/technical-functional/abinitio-l/loading-mfs-file-to-oracle-table-4968984
No comments:
Post a Comment