parallel job performance
Posted: 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.
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.