Skip to Content
0
Oct 05, 2005 at 07:39 PM

How to load date field from a remote Oracle DB with DB Connect

29 Views

Hi,

Does any one have experience extracting Date field from a remote Oracle database through DB Connect to BW? I am experiencing data format issue. The extracted data shows '04-Oct-0' for '10/4/05'. It works fine if I create a view in Oracle database to preformat the data to '20051004'. But, I am not allowed to create view in Remote DB.

Any suggestion is very appreciated.

Regards,

Frank