Oracle Connector Stage And Data Type Date/Timestamp

sangi1981 · Post by **sangi1981** » Fri Apr 19, 2013 1:59 am

Hi all,
I ask for a clarification about data type when use Oracle Connector Stage both for selecting and inserting data.
What is best practice about mapping Oracle data type DATE?
Is it better to map DATE Oracle to Timestamp or Date Datastage?
What is the difference?

The same question applies for decimal(38,0) and decimal(n,p).

Thank you all,
Cheers

ray.wurlod · Post by **ray.wurlod** » Fri Apr 19, 2013 5:01 am

Use whatever you get when importing the table definition using the Connector Access Wizard.

chulett · Post by **chulett** » Fri Apr 19, 2013 6:45 am

An Oracle DATE is a timestamp.

sangi1981 · Post by **sangi1981** » Fri Apr 19, 2013 9:34 am

Thank you for your response.
So, the use of one or the other doesn't change the result loaded in target oracle table?

But, exists some best practices?

Thanks,
Cheers

ray.wurlod · Post by **ray.wurlod** » Fri Apr 19, 2013 4:35 pm

Yes. Use whatever you get when importing the table definition using the Connector Access Wizard.

sangi1981 · Post by **sangi1981** » Sat Apr 20, 2013 4:55 am

Thanks,
Cheers