Saturday, 18 August 2012

Data Masking in Informatica

Data Masking is one of the latest features introduced  by Informatica and is big advantage considering the security of sensitive data stored in Datawarehouse.For eg
  • SSN number of a customer
  • Credit Card number
  • Phone number etc…
This is done by masking the original data using various masking techniques   i.e. converting the original data into some other readable format. This is done without affecting the granularity of the table ,all the integrity constraints are kept the same.The objective behind using data masking transformation is to restrict the outside world from accessing the Customer Information.
Since data ,masking is an integrated option available in @Informatica Power centre it greatly reduces the Development effort.

Why we need data masking?
Normally in projects we have non production environments like development, testing and training . Often the IT companies are careless about the security  in the developments phase. While moving the code into actual production environment they rarely notice that the information can be leaked out.So we need to be careful here.In order to avoid this situation we can do masking at the development phase itself and then outsource the data.That we will be more safer.
Another advantage is that we can avoid the use of Dummy values in the testing and development.Instead of using Dummy values we can use the actual and then mask it and the successfully promote to the Live Environment.
Now we will go through the different algorithms used for data masking
  • Nondeterministic randomization:Replace a sensitive field with a randomly generated .This can be some either any number or date field.
  • Blurring: Add a random variance to the original value .Variance can be small or larger. For example adding 10 percent increase in the salary of employee.
  • Repeatable masking: Maintain referential integrity by using values that are unique and different.Eg Replace the SSN number 1/45/89 with 12/22/44
  • Substitution:  Randomly substitute original values with entirely different but real valuesE.g., substitute “Wayne Smith” with “Don Kelly”)
 Will keep updating……


  1. Wonderful post!!Thank you for sharing this info with us.
    Keep updating I would like to know more updates on this topic
    Very useful content, I would like to suggest this blog to my friends.

    Informatica Training in Chennai

    Best Informatica Training Institute In Chennai

  2. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.

    rpa training in bangalore | best rpa training in bangalore | rpa course in bangalore | rpa training institute in bangalore | rpa training in bangalore | rpa online training | rpa training in Chennai

  3. When I initially commented, I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Thanks.
    AWS Training in Bangalore | Amazon Web Services Training in Bangalore
    Advanced Amazon Web Services Training in Pune | Best AWS Training in Pune
    AWS Online Training | Best Online AWS Certification Course - Gangboard
    Best Top 110 plus AWS Interview Question and Answers 2019

  4. Very nice post here and thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.

    Java interview questions and answers

    Core Java interview questions and answers| Java interview questions and answers

    Java training in Chennai | Java training in Tambaram

    Java training in Chennai | Java training in Velachery

  5. Thanks you for sharing this unique useful information content with us. Really awesome work. keep on blogging

    python training in chennai
    python course in chennai
    python training in bangalore

  6. This is a nice article here with some useful tips for those who are not used-to comment that frequently. Thanks for this helpful information I agree with all points you have given to us. I will follow all of them.
    Best Devops Training in pune
    Data science training in pune | Data Science training institute in Pune

  7. Interesting information and attractive.This blog is really rocking... Yes, the post is very interesting and I really like it.I never seen articles like this. I meant it's so knowledgeable, informative, and good looking site. I appreciate your hard work. Good job.
    Kindly visit us @
    Sathya Online Shopping
    Online AC Price | Air Conditioner Online | AC Offers Online | AC Online Shopping
    Inverter AC | Best Inverter AC | Inverter Split AC
    Buy Split AC Online | Best Split AC | Split AC Online
    LED TV Sale | Buy LED TV Online | Smart LED TV | LED TV Price
    Laptop Price | Laptops for Sale | Buy Laptop | Buy Laptop Online
    Full HD TV Price | LED HD TV Price
    Buy Ultra HD TV | Buy Ultra HD TV Online
    Buy Mobile Online | Buy Smartphone Online in India

  8. The article is very interesting and very understood to be read, may be useful for the people. I wanted to thank you for this great read!! I definitely enjoyed every little bit of it. I have to bookmarked to check out new stuff on your post. Thanks for sharing the information keep updating, looking forward for more posts..
    Kindly visit us @
    Madurai Travels
    Best Travels in Madurai
    Cabs in Madurai
    Tours and Travels in Madurai

  9. Excellent Blog. I really want to admire the quality of this post. I like the way of your presentation of ideas, views and valuable content. No doubt you are doing great work. I’ll be waiting for your next post. Thanks .Keep it up! Kindly visit us @
    Christmas Gift Boxes | Wallet Box
    Perfume Box Manufacturer | Candle Packaging Boxes | Luxury Leather Box | Luxury Clothes Box | Luxury Cosmetics Box
    Shoe Box Manufacturer | Luxury Watch Box

  10. Wow, what an awesome spot to spend hours and hours! It's beautiful and I'm also surprised that you had it all to yourselves!
    Kindly visit us @ Best HIV Treatment in India | Top HIV Hospital in India | HIV AIDS Treatment in Mumbai | HIV Specialist in Bangalore
    HIV Positive Treatment in India | Medicine for AIDS in India

  11. Thank you so sharing sms masking. I really appreciate it


Related Posts Plugin for WordPress, Blogger...