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!