Friday, March 22, 2013

Processing high precision numbers in Informatica PowerCenter

We process very large numbers in our mapping, like Credit Card Numbers, Bank Account Number or even some scientific numbers which needs high precision. Informatica PowerCenter can process numbers up to 15 digit precision without having high precision configuration. We can't treat bigger numbers more than 15 digits as normal numbers, treating so will lead to truncation or rounding of the numbers. In this tutorial we will see how we can process high precision numbers in Informatica PowerCenter and general guidelines for using high precision configuration.

High precision Configuration.

As the first step, during the mapping development process, set the Transformation Ports as DECIMAL with the required Precision and Scale based on the Source, Target Definition. 

Now after the mapping building, in the Session Configuration, we need to enable the High Precision as shown in the below image.
Informatica High Precision Enable

With that we are all done with the configuration required to process large numbers in an Informatica PowerCenter mapping.

Processing Decimal Values without high precision.

When an Informatica PowerCenter Session runs without high precision, the Integration Service converts decimal values to doubles. The following table lists how the Integration Service handles decimal values based on high precision configuration:

Port Datatype
   High Precision Off
  High Precision On
Over 28


  1. Best Informatica Training by TOP Industry Experts in Delhi/NCR with 100% Job Oriented & Placement Record.

    Free 1st Demo Class, Fresh Batch Start from Nov-2014 Call to Book Your Seat Now : 08447037614/09910840204,

  2. i have learnt now what is informatica is all about, thanks for sharing this here. I have been following your blog for a long time. This would be useful for my Informatica training institutes in Chennai

  3. I have follow your blog that's nice please follow us:-The data warehouse interview questions are providing to be quite helpful and here with the help of expert written pages and links you can learn more facts about it at ease. The informatica interview questions and answers for experienced has earned the value and many students or individual looking for his profession is seen following this particular book or questionnaire for reference purpose.

  4. This comment has been removed by the author.

  5. This comment has been removed by the author.

  6. This comment has been removed by the author.

  7. Thanks for sharing this infomation. It is very usefull to us......For any details Informatica online training

  8. good article post..

  9. Nice Information

    Best Informatica Online Training By 9+Years Of Realtime Expert
    Below is the link for Course Content and Demo Class

  10. This comment has been removed by the author.

  11. Interesting blog which attracted me more.Spend a worthful time.keep updating more.
    Digital marketing company in Chennai

  12. very nice post informatica is powerful tool for live project this is very easy to learn and understanding and more readability.superb job thanks for informatica.
    Informatica Training in Chennai

  13. Thank you for sharing: the blog with us.
    very nice blog keep blogging more on
    Processing high precision numbers in Informatica PowerCenter
    myTectra: Devops Training in Bangalore
    itEanz: Devops Training

    If you are Looking for Interview Questions for Popular IT Courses Refer the link Below
    Devops Interview Questions
    Informatica Interview Questions
    Docker Interview Questions
    Hive Interview Questions
    Talend Interview Questions
    As400 Interview Questions

  14. Really helpful information,clarified some concepts of data entry for me.
    Thank you.
    Hope to read more from you.
    For quality courses on anything IT related give myTectra a try.
    myTectra is the Marketing Leader In Banglore Which won Awards on 2015, 2016, 2017 for best training in Bangalore:
    python interview questions

    python online training

  15. Very useful blog for beginners. Thank you for sharing with us and keep sharing more information.

    ETL testing with Informatica