1 Reply Latest reply: Feb 8, 2011 11:34 AM by Mikereiche-Oracle RSS

    How to extract incremental data from SQL server to oracle tables in ODI

    837827
      HI All,

      In my ODI sql server is install.My Source is in SQL server and my target is in Oracle.
      I need to create a interface where i need to extract incremental data from sql server to oracle.
      There is a datetime(with Timestamp) field in sql server .I need to pull incremental data based on dateime.

      Example = tablename.DateTime > (select '1-jan-11' from dual) .....i am using this query but its not woking.the error is Invalid object name"dual"

      Request you to please provide any suggestion ASAP.

      Thanks,
      Lony