Bulk Load on informatica

[Sats]

I got the following on Informatica bulk load from the help files. I thought you could not load to a table with indexes on it. What does the 3rd point mean? How do i disable and enable parallel modes? Is it an oracle attribute?

Oracle Guidelines

When bulk loading to Oracle, the Integration Service invokes the SQL*Loader.

Use the following guidelines when bulk loading to Oracle:

Do not define CHECK constraints in the database.

Do not define primary and foreign keys in the database. However, you can define primary and foreign keys for the target definitions in the Designer.

To bulk load into indexed tables, choose non-parallel mode and disable the Enable Parallel Mode option. For more information, see Relational Database Connections.

Note that when you disable parallel mode, you cannot load multiple target instances, partitions, or sessions into the same table.

To bulk load in parallel mode, you must drop indexes and constraints in the target tables before running a bulk load session. After the session completes, you can rebuild them. If you use bulk loading with the session on a regular basis, use pre- and post-session SQL to drop and rebuild indexes and key constraints.

When you use the LONG datatype, verify it is the last column in the table.

Specify the Table Name Prefix for the target when you use Oracle client 9i. If you do not specify the table name prefix, the Integration Service uses the database login as the prefix.

[Nirmal Ramalingam]

That option is in the relational connections. When you edit the relational connection, you can see that option.