DSXchange

I have a simple job sequential file -> transformer -> Oracle enterprise
The table I am loading into is partitioned by a date field. I have specified in my job that Oracle should disable the constraint (which is a local index).

So when the job starts DataStage drops the index and disables the constraint. When the job finishes it re-creates the index.

When DataStage re-creates the index, it creates it as a normal index not local which is not good when utilizing partitioning.

Any ideas?

Thanks

Adjust the CREATE INDEX command?

fyi on this issue:

I just talked to IBM support.
This is going in as a enhancement request.

Until then, I have scripted a work around.

The workaround will load the table into a temporary normal table with a primary key. I then use the alter table exhchange partition...including indexes to move the data over to the partitioned table. It works quite well and my load times are more consistant.

Thanks