Drop Index

[dsisbank]

I want to drop all index to improve loading proceses,But i have to upsert medhod because primary key of table is increasing by trigger automatically.
oracle target stage hasnt open/close command.
how can i drop index before ınserting and create after inserting.

[hema arvind]

You can create a procedure which contains the SQL related to dropping and re creating the indexes.

From the datastage job,you can call the procedure.

[keshav0307]

if you want to use write method=Load, then there is a option for Index Mode=Rebuild.

if you drop the index, Upsert will not work, it may insert duplicate records

[dsisbank]

but i cant use load medhod because of primary key loaded by triger

[kumar_s]

If you are going for Upsert method, droping index before loading will inturns degrade the performance. Upsert should look for the presence of key in the table before loading into it. Index will help for this.