Read performance from multivalued UV table

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
datastage
Participant
Posts: 229
Joined: Wed Oct 23, 2002 10:10 am
Location: Omaha

Read performance from multivalued UV table

Post by datastage »

I have some jobs that are reading an UniVerse tables with multivalued columns and load to SQL Server after the transformer breaks out multivalues into multiple columns. Displayed by the performance when having the ODBC stage set to 'Insert new or update existing' I changed it to 'Clear the table before insert' to compare times. I got the same load times and then began to think the slow performance was at the UV stage. It appears the tables with more multivalues were the ones that were running longest.

Is it common to expect slower read performance from UV when the table has many multivalues? If there any performance tweaking to improve the read from UV?
Post Reply