Transfering Data to an Oracle Database
Posted: Tue Jun 28, 2011 8:26 am
I created a parallel job that is taking data from SQL Server doing some tranformations and such on the data but I am never changing data types. Once it goes into Oracle I can no longer see the Timestamp it is only a date in Oracle SQL Developer. Is this a problem in my job aka DataStage or is there an issue when placing a Timestamp into Oracle.
The think the main problem I am having is that my logic is not working for picking data with the most recent date. I cannot verify because I cannot see the timestamp to see which date is more recent if it is on the same day.
Let me know if this is not clear enough to understand.
Thanks.
The think the main problem I am having is that my logic is not working for picking data with the most recent date. I cannot verify because I cannot see the timestamp to see which date is more recent if it is on the same day.
Let me know if this is not clear enough to understand.
Thanks.