This discussion is archived
1 Reply Latest reply: Mar 28, 2012 2:13 PM by 913903 RSS

ERROR while loading time dimension table

913903 Newbie
Currently Being Moderated
i need to load time dimension from csv to oracle table, while loading i got the error.
my source data type is date and target is date.

ODI-1226: Step sample day fails after 1 attempt(s).
ODI-1240: Flow sample day fails while performing a Loading operation. This flow loads target table W_SAMPLE_DATE.
ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection Target_Oracle.
Caused By: java.sql.SQLException: ORA-30088: datetime/interval precision is out of range

while creating c$ table
create table WORKSCHEMA.C$_0W_SAMPLE_DATE
(
     C3_ROW_WID     NUMBER(10) NULL,
     C1_CALENDAR_DATE     TIMESTAMP() NULL,
     C2_DAY_DT     TIMESTAMP() NULL
)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points