Skip to Content
Former Member
Apr 19, 2007 at 02:55 PM

Data format


Hi all,

I got problem when I am loading data from Oracle view into an ODS.

Data are loaded into BW successfully, but the formats are wrong.

In the oracle view:

Sales Date (Char) : 04/11/2007

Sales Dollars (num,dec 2): 3.78

In the PSA I can see these data.

But in the ods the data is like:

Sales Data (DAT): 1//20/04/1

Sales Dollars (FLTP): 4.00

Can anyone kindly give me a guide? thanks a lot!