Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Informatica Powercenter Number Datatype Default - It Overrides Declaration in Oracle
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 > DBAReceived on Mon Jun 23 2003 - 17:03:54 CDT