Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Informatica Powercenter Number Datatype Default - It Overrides Declaration in Oracle

Re: Informatica Powercenter Number Datatype Default - It Overrides Declaration in Oracle

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Mon, 23 Jun 2003 22:03:54 GMT
Message-ID: <MPG.1961192039424d729897d0@news.la.sbcglobal.net>


hulkhogandude_at_yahoo.com said...
> We are using Powercenter as our ETL tool and ran into a problem. Our
> Oracle 8.1.7.4 Database has around 500 columns defined as NUMBER with
> no precision specified. The Informatica Server sees converts this to
> NUMBER(15,0) thus eliminating any decimal precision in the columns.
> Is there any way around this problem other than redefining all 500 of
> our columns with a specific decimal preceision?
> TIA,
> Hulkster
>

You might get better results by going to informatica.com and filing an SR with Support. If your company has money to burn, there are a lot of 3rd party companies that provide data conversion/transformation apps that might help.

-- 
/Karsten
DBA > retired > DBA
Received on Mon Jun 23 2003 - 17:03:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US