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.