Performance issue

reddy · Post by **reddy** » Wed Dec 06, 2006 4:32 pm

Hello sir,

I am loading 12 million records of a mainframe COBOL file having 800 record length into a Oracle 9i table.
In that file we have lot of comp3 fields and comp fields.In the transformer i used data type convertions to split into columns.
Every thing looks good.
But i am getting performance issues.
I tested with Oracle normal and bulk loads.It is taking around 81/2 hours.
Can you please help me out on this performance issue.

Thanks in advance.

Reddy

ArndW · Post by **ArndW** » Wed Dec 06, 2006 5:04 pm

What is the bottleneck? Is your CPU for the transform stage at 90% or higher? Is Oracle on the same machine? If not, what is the network throughput capacity at?

ray.wurlod · Post by **ray.wurlod** » Wed Dec 06, 2006 7:32 pm

Try using a Complex Flat File stage to read the file. It will decode the COMP and COMP-3 fields for you, faster than the Transformer stage can do it.