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

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

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 24 Jun 2003 20:13:06 +0100
Message-ID: <3ef8a304$1_2@mk-nntp-1.news.uk.worldonline.com>

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:MPG.1961192039424d729897d0_at_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
> >
>
> If your company has money to burn, there are a lot of
> 3rd party companies that provide data conversion/transformation apps
> that might help.

LOL! These are the tools which are supposedly doing the ETL in the first place.

Regards,
Paul Received on Tue Jun 24 2003 - 14:13:06 CDT