DSXchange

hi

I am just refereing the datastage pdf's, and had doubt avout using the variable APT_ORACLE_LOAD_OPTIONS to "OPTIONS (DIRECT=TRUE, PARALLEL=FALSE) options.

If we use this it will skip the Index creation, when the index will be created to improve the retrieval performance for Busienss Users. orelse do we need to do this database level?

That particular option simply says to run a single-threaded direct path sqlldr session. It implies something about any indexes but doesn't "skip" anything. Have a chat with your DBA if you are unsure how sqlldr and those kind of options work.

If you this value (OPTIONS(SKIP_INDEX_MAINTENANCE=TRUE) then It will skip indexes while loading. It will enable the indexes automatically once loading got completed.