ODI Error While Running ODI Interface
ORA-01840: input value not long enough for date format
When checked all the Date columns in Source tables found that There are some dates with no time stamps and also some values of “0”.
Removed the 24hr Date format to 12 hour date format and used select Distinct
Select distinct
TO_DATE
(substr(decode(ral.interface_line_attribute4,'0',null,ral.interface_line_attribute4),1,10),
'YYYY/MM/DD' ) from ra_customer_trx_lines_all
No comments :
Post a Comment