Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
sangi1981
Participant
Posts: 99 Joined: Fri Jun 13, 2008 8:10 am
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Apr 19, 2013 6:45 am
An Oracle DATE is a timestamp.
-craig
"You can never have too many knives" -- Logan Nine Fingers
sangi1981
Participant
Posts: 99 Joined: Fri Jun 13, 2008 8:10 am
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sangi1981
Participant
Posts: 99 Joined: Fri Jun 13, 2008 8:10 am
Post
by sangi1981 » Sat Apr 20, 2013 4:55 am
Thanks,
Cheers