1 Reply Latest reply: Mar 28, 2012 4:13 PM by Drona RSS

    ERROR while loading time dimension table

    Drona
      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
      )