parallel job performance

just4u_sharath · Post by **just4u_sharath** » Wed Dec 19, 2007 2:55 pm

In My Job, for a single column i have the option of using either
left,right functions (column is date column)
or type conversions (stringtodate, dateto string).
i can use any of these to populate the date columns. Now my question is
will there be any performance degradation if i use type conversions in place of left and right functions to extract data. How can i check whether my job performance is increased or not. is there any specifc environment variable which indicates the job performance. please reply. Input data is nearly 5million records.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 19, 2007 4:22 pm

Define "performance" in an ETL context.

Rows/sec is almost totally meaningless as a metric of ETL performance, as I will tell anyone who'll listen.

chulett · Post by **chulett** » Wed Dec 19, 2007 4:23 pm

And anyone who won't listen as well.