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

[former_member630261]

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

[Former Member]

You have to change it to a varchar2 field. YYYYMMDD. I do not know of any other option.