Pages

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
  Precision
   High Precision Off
  High Precision On
Decimal
0-28
Double
Decimal
Decimal
Over 28
Double
Double

10 comments:

  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, info@ambrot.com

    ReplyDelete
  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

    ReplyDelete
  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.

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. This comment has been removed by the author.

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

    ReplyDelete
  8. good article post..
    http://www.informaticaonlinetraining.co/

    ReplyDelete
  9. Nice Information

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

    https://informaticaonlinetraing.blogspot.com

    ReplyDelete
  10. want to learn more about Informatica Join Informatica Course. Informatica Training .learn Informatica ETL By QEdge Technolgoeis IT Industry Expert Trainer

    ReplyDelete