cancel
Showing results for 
Search instead for 
Did you mean: 

Loading date Information from Oracle to BI 7.0 via UDConnect.

Former Member
0 Kudos

Hi all,

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Create an object in the data source with field length 21, and load the data into PSA as it is. i mean in the original format.

from PSA load the data into DSO and create two different I/O with date and time type.

Use transformation to split the record into date and time.

You can cleanse the data accordingly once u have it in BW.

Hope this Helps

Israr Haider