Without the 4 MOD() functions the CPU utilization is still close to 90% for the entire time the job runs. Andrw, when I monitor the statistics for transformer, The %CPU usage is very high (168). I think the transformer is too loaded so I added another transformer which carried few data validations. What I am trying to achive here is load balance between the two transformers in terms of the operations they are carrying out. I think this should work for me. Any thoughts for this pointer?
Also please suggest me, which of the following to codes will work more efficently.
Code: Select all
IF
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.NUM_UNITS))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.CS))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.ORIG_TERM))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.ORIG_LTV))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.ORIG_NOTE_RATE))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.POOL_ISS_NOTE_RATE))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.AUX_NOTE_RATE))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.NET_NOTE_RATE))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.ORIG_LOAN_AMT))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.POOL_ISS_RPB))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.CURR_RPB))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.LOAN_AGE))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.REM_TERM))) and
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.MONTHS_TO_AMORT)))
THEN
'0'
ELSE
'-01722'
Or
Just a single
Code: Select all
IF
IsValid('DECIMAL[38,10]',TrimLeadingTrailing(NullToZero(LNK_Read_Input2.MONTHS_TO_AMORT)))
THEN
'0'
ELSE
'-01722'
But for all the columns individually?
Andrw I really appreciate your promt replies...
![Smile :)](./images/smilies/icon_smile.gif)