I am have Job Design where i am using Two Stage Variables In transformer stage.I am Validating data Format for Decimal and Integer Values ,Both stage Variables has got almost 150 and 35 'AND' Clauses respectively.But whole design is Taking Too much time for Compilation almost nearly 2-3 hours.
sample Stagevariable Code:
StageVariable1:
Code: Select all
IF
(IsValid('DECIMAL[22,6]',TrimLeadingTrailing(NullToZero(LNK_Read_Input.FF_BOOK_VALUE_PS)))) AND
(IsValid('DECIMAL[22,6]',TrimLeadingTrailing(NullToZero(LNK_Read_Input.FF_DIV_FY8)))) AND
(IsValid('DECIMAL[22,6]',TrimLeadingTrailing(NullToZero(LNK_Read_Input.FF_DIV_FY7)))).........
Then
0
else
-1
Stagevariable2:
IF
(IsValid('INT32',TrimLeadingTrailing(NullToZero(LNK_Read_Input.FF_BOOK_VALUE_FLG)))) AND
(IsValid('INT32',TrimLeadingTrailing(NullToZero(LNK_Read_Input.FF_FY_LAST_DT)))) AND
(IsValid('INT32',TrimLeadingTrailing(NullToZero(LNK_Read_Input.FF_FQ_LAST_DT))))........
Then
0
Else
-1
If you have better suggestions to minimise the compilation Time,please Share with us.