Loading data to oracle table

[krisna]

Hi Everybody,

I have to load data from a dataset file to a oracle table. There are no transformation rules(i.e., its a column to column mapping).
In dataset we have 5,07,120 records and this needs to loaded into oracle table.
In my production environment we can have 6 times of the record count (above mentioned)

I defined Array size = 1 and Transaction size = 5000

The total elapsed time take is 1hr 15 mins.

Please advice to improve performance.

Thanks in advance

[chulett]

What stage and 'action' are you using?

ps. That array size will kill your performance, it should be something larger - for lack of knowledge and thus any better suggestion try 1000 and see if that helps.

[krisna]

Using DRS stage