on 11-15-2007 7:17 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.