Typical Warning : Implicit conversion from source type
Posted: Mon Jul 26, 2010 4:06 am
Query:-
I am using oracle enterprise stage to extract the data from XXXXXX table by using user defined SQL query (Query Mentioned in the CODE path). Meta data imported from table, and it is like Column Name = TOT_AGENT_ID, Datatype = Bigint, Nullable = YES.
Job is running without any errors , but only one warning message I am getting with:
Warning:-
When checking operator: When binding output interface field "TOT_AGENT_ID" to field "TOT_AGENT_ID": Implicit conversion from source type "decimal[38,0]" to result type "int64": Possible range limitation.
Job Design is Like:
Oracle Stage Transformer Stage Dataset Stage
Metadata is same for entire flow ( Including Datatype, Length and Nullability). No where mentioned source datatype as DECIMAL in Datastage job and Oracle.
What would be the cause of this warning?
Where I have done wrong?
Can anybody please assist?
Thanks in advance.
Code: Select all
SELECT a.ABCDEFGHIJ ,
Cast(COUNT(a.AGENT_ID) as Integer) AS TOT_AGENT_ID
FROM TABLE_AAAA a
LEFT OUTER JOIN
TABLE_CCCCC c
on a.AGENT_ID=c.AGENT_ID
WHERE
a.XYZ <= TO_DATE('#p_Rundate#','YYYY-MM-DD') - 1
AND a.ZYX >= TO_DATE('#p_Rundate#','YYYY-MM-DD') - 1
AND Trim(c.ABC)='XXXXXX'
GROUP BY a.ABCDEFGHIJ
Job is running without any errors , but only one warning message I am getting with:
Warning:-
When checking operator: When binding output interface field "TOT_AGENT_ID" to field "TOT_AGENT_ID": Implicit conversion from source type "decimal[38,0]" to result type "int64": Possible range limitation.
Job Design is Like:
Oracle Stage Transformer Stage Dataset Stage
Metadata is same for entire flow ( Including Datatype, Length and Nullability). No where mentioned source datatype as DECIMAL in Datastage job and Oracle.
What would be the cause of this warning?
Where I have done wrong?
Can anybody please assist?
Thanks in advance.