CODEWITHSUNDEEP
informaticainformatica-powercenterinformatica-powerexchange
Annant Jain
Annant Jain

Reputation: 13

What are the types of datatypes in informatica and range of values they can take

I was trying to load data into db using informatica, where i used function to_integer() but it threw error that interger overlow. I need to load data into a column of precision 18,0 in SQL Can someone please tell different data types available in which i can convert string into number and load in db for values of high range

Upvotes: 1

Views: 11115

Answers (1)

Samik
Samik

Reputation: 3455

Look at the Transformation Datatypes in Informatica Help pages. For your case, TO_BIGINT should solve the problem. BIGINT supports 19 digits.

enter image description here

Upvotes: 2

Related Questions