Metadata import from Oracle 11g to Datastage

mandyli · Post by **mandyli** » Sun Dec 23, 2012 1:44 pm

Hi

I am trying to import metadata from ORACLE 11g to Datastage via Connector import Wizard .

In oracle column defined as NUMBER (10) that means it equal to Datastage Integer. But when I import it is showing Decimal 10 instead of Integer.
NUMBER(10) .
Is this anything I have to change in setting ?

Thanks
Man

ray.wurlod · Post by **ray.wurlod** » Sun Dec 23, 2012 3:15 pm

You need to adjust only your understanding. NUMBER(10) cannot be the same as Integer, because not every 10 digit number can be an Integer.

mandyli · Post by **mandyli** » Sun Dec 23, 2012 5:02 pm

Thanks Ray.

but why it is convert into Decimal. I hope as per ORACLE NUMBER (10) stored 10 digit number.

Thanks
Man

chulett · Post by **chulett** » Sun Dec 23, 2012 7:37 pm

And so will a Decimal 10.

lstsaur · Post by **lstsaur** » Sun Dec 23, 2012 7:39 pm

Well, if you use Orchetrate Schema to import the data NUMBER (10), then you get the "Integer" SQL type in your table definition. If you use Plug-in Meta Data to import the data, then you get the "Decimal" SQL type. So Oracle Connector is using the same thing as Plug-in.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 24, 2012 2:01 pm

ANSI standard SQL does not have a data type called NUMBER. Indeed, as far as I am aware, nor does any database apart from Oracle.

Oracle is... different.

In DataStage, the data types DECIMAL and NUMERIC are considered to be the same. There are only a couple of databases in which the nuances make these different; DataStage stores them in the same way. You can learn about DataStage data types in Chapter 2 of Parallel Job Developer's Guide.

mandyli · Post by **mandyli** » Wed Dec 26, 2012 7:27 am

Thanks Ray.

Why I am getting data-type conversation?

Thanks
Man

ray.wurlod · Post by **ray.wurlod** » Wed Dec 26, 2012 4:04 pm

Probably because Decimal precedes Numeric in an alphabetical list of data types.

mandyli · Post by **mandyli** » Fri Dec 28, 2012 10:53 am

Thanks Ray

So you are saying in oracle if defined as NUMBER and then if import into Datastage it will automatically convert into DECIMAL.

Is this correct ?

Thanks
Man

ray.wurlod · Post by **ray.wurlod** » Fri Dec 28, 2012 3:13 pm

Not something I've done recently, but it certainly appears that way.

There's nothing to prevent you from adjusting the imported metadata, but you risk getting metadata mismatch warnings if you do.