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

informatica informatica-powercenter informatica-powerexchange
Annant Jain picture Annant Jain · Dec 30, 2015 · Viewed 10.4k times · Source

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

Answer

Samik picture Samik · Dec 30, 2015

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

Related questions

Case Statements/Decode Function in Informatica

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based on my limited experience I feel case statements aren't supported. There is a decode function with similar functionality, but I …

Read More
How to dynamically give flat file source file name in session properties of informatica?

i have an issue where i get flat file with date and time extension to flat file name like test_28-10-2012.txt I can get the flat file name in mapping through checking the AddCurrentlyProcessedFileNameproperty in Source Analyzer,from …

Read More
Difference between Joiner and Union Transformation

I'm new to Informatica....What is the difference between Joiner and Union Transformation? Also, Should we use Router instead of Joiner, to increase performance when there are multiple sources?

Read More