APT_ORACLE_LOAD_OPTION

[karrisuresh]

Hi
I am trying to perform truncate and load option

for that in ADMIN,
I am giving APT_DUMP_SCORE for APT_ORACLE_LOAD_OPTIONS

but still i am getting error

any suggestion

thanks
suresh

[chulett]

What error? You should be able to set Write Method to Load and Write Mode to Truncate in the OE stage to do this, unless there is more here than you are telling us.

[nagarjuna]

Hi ,

APT_ORACLE_LOAD_OPTIONS is used to tell datastage whether loading is direct or not .Tell the exact error message you are getting .

[karrisuresh]

PS_NW_DBALEAA_F_SF: Indexes on table 'PS_NW_DBALEAA_F_SF' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.

[karrisuresh]

Hi All
the error is as follows........


PS_NW_DBALEAA_F_SF: Indexes on table 'PS_NW_DBALEAA_F_SF' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.

[chulett]

Have you tried doing what it says? For example, adding the appropriate "Index Mode" option: Rebuild or Maintenance? Or is there some specific reason you need to take the APT_ORACLE_LOAD_OPTION path?

[karrisuresh]

Hi All
Thanks I got It

[Oritech]

Also its good to mention here how u resolved it..

[ray.wurlod]

Since U wasn't involved, perhaps karrisuresh would like to post how this particular issue was resolved. And to mark the thread as Resolved