Hi every one..
i am new to this form..
source is from flat file
i am getting Transfromation parse error...
i it is skipping one line saying line buffer size is not sufficent...
so i am pasting the error log file ..
can any one please please... let me know what is the cause of this error and how to resolve it...
**************************************************
TE_7022 TShmWriter: Initialized
MAPPING> DBG_21641 JNR_EMP_SAL: Index cache size = [1048576], Data cache size = [2097152]
MAPPING> TT_11098 INFO: Joiner [JNR_EMP_SAL] is set up with join algorithm: Nested-Loop.
MAPPING> Fri Jun 27 20:28:29 2008
MAPPING> TE_7004 Transformation Parse Warning; transformation continues...
TE_7004 ['('||SUBSTR(PHONE_NUMBER,1,3)||')'||SUBSTR(PHONE_NUMBER,4,3)||'-'||SUBSTR(PHONE_NUMBER,7)]
MAPPING> Fri Jun 27 20:28:29 2008
MAPPING> TE_7004 Transformation Parse Warning; transformation continues...
TE_7004 [<<PM Parse Warning>> [SUBSTR]: operand converted to a string
... '('||SUBSTR(>>>>PHONE_NUMBER<<<<,1,3)||')'||SUBSTR(PHONE_NUMBER,4,3)||'-'||SUBSTR(PHONE_NUMBER,7)<<PM Parse Warning>> [SUBSTR]: operand converted to a string
... '('||SUBSTR(PHONE_NUMBER,1,3)||')'||SUBSTR(>>>>PHONE_NUMBER<<<<,4,3)||'-'||SUBSTR(PHONE_NUMBER,7)<<PM Parse Warning>> [SUBSTR]: operand converted to a string
... '('||SUBSTR(PHONE_NUMBER,1,3)||')'||SUBSTR(PHONE_NUMBER,4,3)||'-'||SUBSTR(>>>>PHONE_NUMBER<<<<,7)]
i am new to this form..
source is from flat file
i am getting Transfromation parse error...
i it is skipping one line saying line buffer size is not sufficent...
so i am pasting the error log file ..
can any one please please... let me know what is the cause of this error and how to resolve it...
**************************************************
TE_7022 TShmWriter: Initialized
MAPPING> DBG_21641 JNR_EMP_SAL: Index cache size = [1048576], Data cache size = [2097152]
MAPPING> TT_11098 INFO: Joiner [JNR_EMP_SAL] is set up with join algorithm: Nested-Loop.
MAPPING> Fri Jun 27 20:28:29 2008
MAPPING> TE_7004 Transformation Parse Warning; transformation continues...
TE_7004 ['('||SUBSTR(PHONE_NUMBER,1,3)||')'||SUBSTR(PHONE_NUMBER,4,3)||'-'||SUBSTR(PHONE_NUMBER,7)]
MAPPING> Fri Jun 27 20:28:29 2008
MAPPING> TE_7004 Transformation Parse Warning; transformation continues...
TE_7004 [<<PM Parse Warning>> [SUBSTR]: operand converted to a string
... '('||SUBSTR(>>>>PHONE_NUMBER<<<<,1,3)||')'||SUBSTR(PHONE_NUMBER,4,3)||'-'||SUBSTR(PHONE_NUMBER,7)<<PM Parse Warning>> [SUBSTR]: operand converted to a string
... '('||SUBSTR(PHONE_NUMBER,1,3)||')'||SUBSTR(>>>>PHONE_NUMBER<<<<,4,3)||'-'||SUBSTR(PHONE_NUMBER,7)<<PM Parse Warning>> [SUBSTR]: operand converted to a string
... '('||SUBSTR(PHONE_NUMBER,1,3)||')'||SUBSTR(PHONE_NUMBER,4,3)||'-'||SUBSTR(>>>>PHONE_NUMBER<<<<,7)]