Loading date Information from Oracle to BI 7.0 via UDConnect.
Can you please help me in understaning an issue that I am facing.
1) We have a table in Oracle in which we have a field called 'Reading Date'.
This field is of type DATE(7). But, it contains value in the format : '12/31/2006 7:01:00 PM'.
Now, is there any way by which we can load this information into BI 7.0?
I tried to load this using an infoObject of type DATS(8).
But, then time information does not get loaded.
Then, I tried an infoObject of type CHAR(20).
But, that also yields the same result.
2) Is it possible to do a delta load using UDConnect even if we do not have a time-based or date-based field in the table of the source system?
Can you please suggest?