Importing Oracle Table Source with Number Data ... Skip navigation

Importing Oracle Table Source with Number Data Type

score 5
You have not voted. Active

Hi Infa Team,

 

While importing Oracle Source table structure I have come across one scenario for the data type NUMBER which I want to bring to your notice.

Even if Informatica has Source data type as NUMBER separately (that corresponds to DOUBLE), still while importing the table, if the table datatype has NUMBER explicitly (and does not have any precision mentioned), in that case Informatica automatically puts the data type defaulted to NUMBER(15,0).

 

Hence in this case. I feel it is really confusing when it gets defaulted and there by rounding of the Decimal Portion Source data. Also in order to correct this, we will have to correct the Source data type after importing the Source.

 

Please let me know , whether I am missing anything here.

 

Thanks,

Amitesh!

Comments

Vote history