Hi,
we are trying to run one session which is pointing to large mapping, it has many conversions. In this mapping we are doing conversion like lpad(SUP,7,0)||'0'||lpad(ITEM,7,0) for joining with other port. Here we didnt get any error while validating the mapping.
But while running the session, some times we r getting the error
'transformation parse warning lpad(SUP,7,0)||'0'||lpad(ITEM,7,0); operand converted to a string',
we are getting error some times, not always..
if we tried to run this session again and again, it gets succeeded. every time we are getting some different errors like internal sort error.
If some thing wrong in mapping, we should get this error always right? but we r getting this error sometimes...
Can anyone help to resolve this...?
Thanks in advance