Tag Archives: data discovery

Beyond Data Profiling – Part 1

This blog discusses going beyond basic data profiling. But for those of you who don’t know what basic data profiling is, let me summarize quickly. Basic data profiling is what I call three-dimensional analysis. I discuss this in some depth in my book, “Three Dimensional Analysis Data Profiling Techniques.”

Basic profiling includes column profiling, table profiling, and cross table profiling. Column profiling is automated discovery of the true metadata of your data. This is the process of identifying the accurate data type and precision, minimum value, maximum value, the number of nulls, percent null and more on a column by column basis. Table profiling attempts to infer a primary key based upon the data. You can also infer functional dependencies within each table. Cross table profiling is about finding primary key / foreign key relationships between the tables, as well as overlap analysis.  This technology has been around since the late 90s. It boggles my mind that many data related projects still do not perform basic profiling before they embark on the project. But that, as they say, is another story. (more…)

Posted in Data Integration | Tagged , | Leave a comment

Big Data, Big Problems: Leveraging Informatica 9.5 to Build an Effective Data Governance Strategy to Meet the Big Data Challenge

By: Chris Cingrani, Informatica DQ & MDM Practice Lead, Data Management Practice at SSG Ltd., www.ssglimited.com

Big data is something that I am continually asked about by clients, as the subject continues to gain significant press.  While discussing this topic, I often address it from the angle that bigger data volumes will result in bigger data problems.   Although this seems like a logical premise, the reality of what it really means to an organization and how to plan accordingly is what is often overlooked.  Rather than solve the problem in this blog post, I want to focus on two key considerations from a data governance standpoint, as well as discuss why SSG sees Informatica 9.5 as a core component of a sound data governance strategy that can ensure an organizations’ business decision-making success. (more…)

Posted in Big Data, Data Governance | Tagged , , , , | Leave a comment

Reflections On Gartner’s 2011 Magic Quadrant For Data Quality Tools

Gartner recently released their 2011 Magic Quadrant for Data Quality Tools and I’m happy to announce that Informatica is positioned in the Leaders’ quadrant.  We believe our position is a testament to the fact that customers like Station Casinos and U.S. Xpress continue to turn to Informatica to solve their most critical data quality challenges.

The publishing of the Magic Quadrant is often a great opportunity to reflect on the state of the data quality market.  It should come as no surprise that data quality as a business imperative isn’t going away any time soon.  We are continuing to see customers looking for help and expertise in solving a wide range of data quality problems, largely associated with data governance initiatives, master data management (MDM), business intelligence and application modernization.  And the association of data quality in these areas is only getting stronger. (more…)

Posted in Big Data, CIO, Data Governance, Data Quality, Informatica 9.1, Pervasive Data Quality, Profiling, Scorecarding | Tagged , , , , , , , , , | Leave a comment

Informatica Data Quality 9.1: Discover, Profile And Cleanse – Oh My!

Today is an exciting day for Informatica as we go live with the launch of Informatica 9.1.  With this new release we are further extending our platform vision to bring to market industry leading data integration, MDM and data quality capabilities.

With the launch of Informatica 9.1, we’ll be introducing new capabilities aimed at making the process of managing data quality that much easier.  Here’s a sneak peak at what’s in store: (more…)

Posted in Big Data, Data Governance, Data Quality, Informatica 9.1, Pervasive Data Quality, Profiling, Scorecarding | Tagged , , , , , , , , , | Leave a comment