Tag Archives: data validation

Let’s Confirm You Are Integrated

Each and every day, we strive to create the very best product possible – not just for our clients and those who judge our work but, more importantly, for ourselves. We are all perfectionists in our own right; after all, each project we undertake is a testament to our own ability.

One source of creative inspiration that I find myself drawn to time and time again is Top Chef on Bravo. For those that have not watched; the series features aspiring chefs who compete for their shot at culinary stardom and the chance to earn the title of “Top Chef.”  Each episode holds two challenges for the chefs. The first is a Quickfire test of their basic abilities and the second is a more involved elimination challenge designed to test the versatility and inventiveness of the chefs as they take on unique culinary trials such as working with unusual and exotic foods or catering for a range of demanding clients. The challenges not only test their skills in the kitchen, but also uncover if they have the customer service, management and teamwork abilities required to be the Top Chef. The competing chefs live and breathe the high-pressure lifestyle that comes with being a master chef and each week someone is asked to “pack up their knives” and go home. (more…)

Posted in Informatica University | Tagged , , , , , | Leave a comment

Even ‘The Most Interesting Man In The World’ Won’t Do This…


“I have taken risks in my life……but I always validate my data before  updating my production systems. Stay employed my friends!”

I am hearing an increasing number of customers tell me that they either do not have time to do data validation or reconciliation testing on their nightly updates to production systems, or that they can only test a part of the data. In the latter case, they have to “guess” which parts of the data have the most business risk and therefore deserve their testing time and resources. It doesn’t have to be this way.  Informatica Data Validation can be used in production environments. The really good news is that data validation testing can be run at night from a command line script or in a workflow. The load of data into production systems can be made to be conditional on successfully passing all the tests. Customers can also build in automatic notification of the test results so that they know the status of their production systems.


Posted in Data Integration | Tagged , , , , , , | Leave a comment

Validating Data for Production Environments

The BBC published a news story where a teacher in India looked at his bank account expecting to see a balance of $200 only to find that the balance shown was $9.8 billion (480 billion rupees).  Imagine that surprise!

These types of stories appear in the news on a regular basis, and the question they raise is this: How could an error of this magnitude have happened and what could have been done to prevent it? (more…)

Posted in Data Integration | Tagged , , , , , , | Leave a comment

How IT can Kill Great Brands with Modernization, and How to Prevent It

Recently, one Sunday afternoon, my wife told me her purchased airline reservation for Monday had disappeared.  A few days ago it was there, then suddenly it was gone.  Apparently she was not alone.  Complaints were coming in online. Support was overwhelmed. In fact, Twitter seemed to be the only way to get a quick response, so people were sending their messages and details that way!

Now, this is a great brand that I’m talking about, what I would call the chic brand in the airline industry.  They had just experienced a brand-killing event.  No one wants to fly an airline where reservations disappear.  But the next part stunned me.  When my wife finally talked to a manager at the airline, it turned out they expected this would happen!  They had just migrated to a new reservation system and another airline that had done this same migration had experienced issues for a few weeks.  So the airline not only expected to have similar issues, they scheduled fewer planes to fly in the upcoming weeks! (more…)

Posted in Data Migration, Governance, Risk and Compliance | Tagged , , , , , | Leave a comment

The Secret To Retiring Applications – Flawless Data Validation

Applications are retired (sunset or decommissioned) when they become dormant or read-only. This occurs as a result of mergers and acquisitions or through modernization efforts and is a natural part of Application Information Lifecycle Management. While the applications may be no longer needed, the data they contain cannot be discarded. As a result, many organizations have hundreds, even thousands, of defunct applications that are consuming budget dollars, taking up data center space, complicating IT management, and generally just getting in the way. The challenge is getting rid of applications without getting rid of the data which is tightly coupled to them. (more…)

Posted in Application ILM, Application Retirement, Integration Competency Centers, Uncategorized | Tagged , , , , , , , | 1 Comment