DSXchange

when i an trying to populate data to a sdatabse table ,the job is aborting with error message as

When checking operator: APT_ORACLE_LOAD_OPTIONS has been set by user. Therefore, Orchestrate assumes that the DIRECT and/or PARALLEL options have been set to FALSE, and that it is okay to load table 'TABLENAME', even though it is indexed, and an index option (rebuild or maintenance) has not been included. APT_ORACLE_LOAD_OPTIONS has been set by the user to 'OPTIONS(DIRECT=FALSE,PARALLEL=TRUE)'.

can any body help

You need to check the valid cvobminations of options with Oracle. I don't have the documentation at the moment but I think if this is causing and error you need to "disable constraints" option turned on in the Oracle stage when you have Parallel = True in the load options.

It sounds like you are using Write Method = Load, If so, add the option:
Disable Constraints = False
Index Mode = Rebuild