Toggle navigation
Log in
Sign Up
Log in
Sign Up
Appium
C
C#
C++
Docker
Go
Informatica
Java
JavaScript
Kafka
Numpy
Oracle
Pandas
PHP
Py Spark
Python
R
React Native
Scipy
SFTP
Tableau
Teradata
TGMC
UNIX
Introducing
Radical.sh
Forget Code launches a powerful code generator for building API's
Forget_Code.Models.CategoryViewModel
Add a new snippet
Conversion Functions
1
Date Functions
8
Encryption
1
Math Functions
2
Operators
1
String Functions
9
Choose Category
DECIMAL conversion problem in Informatica
Forget Code
Informatica
DECIMAL conversion problem
Informatica power center will act differently when it encounters the DECIMAL values which were derived from different sources like oracle, SQL SERVER.
The real problem occurs when the DECIMAL value exceeds the precision of 25 digits (vary upon the Informatica versions).
Problem:
Consider the SQL SERVER source which has the table employee with salary column defined as DECIMAL (38,0)
Consider the value from the column is 44365263573674236242657456457
If you process the above value, Informatica will round the value like 44365263573674236242000004400 which is undesirable.
Solution:
Enable high precision property in Session level
If the above solution is not working you can go with the below one:
It is better to use String type while reading the decimal values from sources, later we can change to decimal values in Informatica mappings.
Source (Decimal) --> Informatica source (Read as string) --> String to Decimal in Mapping level
Tags for DECIMAL conversion problem in Informatica
Decimal rounding in Informatica
Truncating Decimal values
Solving Decimal values mismatch
decimal level properties in session in informatica
decimal to number informatica
decimal to string conversion in informatica
how to convert decimal to date in informatica
informatica decimal conversion
informatica decimal issues
informatica decimal precision issue
informatica rounding of large decimal numbers
Contribute to Forget Code, help others.
Add snippet