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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 23 Jun 2003 23:18:38 +0200
Message-ID: <vferulp4o44c37@corp.supernews.com>

"Gort Klaatu Barada Nickto" <hulkhogandude_at_yahoo.com> wrote in message news:d21dbbc6.0306231133.3629d0f0_at_posting.google.com...
> 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

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon Jun 23 2003 - 16:18:38 CDT