impact of warning message on oracle table
Posted: Sat Sep 20, 2008 1:45 am
Hi all,
Warning message like
1) Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute failed.
0 Rows affected.
2) MetaData mismatch
COLUMN.TYPE Expected = Decimal Actual = Double
3) Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute returned informational message.
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
Just want to know out of these which type of warning will affect the oracle table or which warning should be taken care with high priority and whether warnings will affect the running time of the job.
Whether If I am chaning the Outlink datatype of the transformer to avoid warnings will it affect the oracle table or data flowing to that table?
Can any one share your views
Thanks in Advance
Warning message like
1) Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute failed.
0 Rows affected.
2) MetaData mismatch
COLUMN.TYPE Expected = Decimal Actual = Double
3) Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute returned informational message.
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
Just want to know out of these which type of warning will affect the oracle table or which warning should be taken care with high priority and whether warnings will affect the running time of the job.
Whether If I am chaning the Outlink datatype of the transformer to avoid warnings will it affect the oracle table or data flowing to that table?
Can any one share your views
Thanks in Advance