Informatica Power Center Solutions

Promote automation, reuse and agility with the industry's only full integrated end-to-end enterprise data integration platform.

Informatica's modern data integration infrastructure combines advanced hybrid data integration capabilities and centralized governance with flexible self-service business access for analytics. By providing a robust integrated codeless environment, teams can collaboratively connect systems and transform and integrate data at any scale and any speed.

Read full article at http://www.infotrellis.com/informatica-data-integration/

What You May Be Missing by Not Monitoring Your MDM Hub

Organizations spend millions of dollars to implement their MDM solution. They may have different approaches (batch vs. real time; integrated customer view vs. integrated supplier view etc.) – but in general they all expect to get a “one version of the truth” view by integrating different data sources and then providing that integrated view to a variety of different users.

After the completion and successful testing of the MDM implementation project, companies sit back and enjoy the benefits of their MDM hub – and more often than not don’t even think about looking under the hood. It never occurs to them that they could be trying to gain insights into what’s happening inside that MDM hub by asking questions like

–          How is the data quality changing?

–          What are the primary activities (in processing time) inside the MDM hub?

–          How are service levels changing?

However, organizations change, people change, requirements change – impacting what is happening inside the MDM Hub. Such changes can open up significant opportunities for an organization – but without doing any sort of investigation that opportunity is typically not recognized.

Here are two examples – diagnosed through the use of an MDM audit tool:

–          The company’s MDM Hub had approximately 100,000 incorrect customer addresses. These addresses were used for regular mailings; the mailings generated (in case of correct address) incremental revenues. Impact on the business related to just one mailing:

$400K wasted on the mailing cost ($4 is the conservative mailing cost per person – for postage, printing of the mailer etc.)
$100K of immediately lost revenues (as past data shows that one in 50 customers spends about $50 immediately following the mailing)
The longer term revenue lost was not assessed, but was estimated to be well over $400K
The opportunity: Cost saving of $400k and revenue increase of $500K or more
–          At a different company, by analyzing data processed by week the resulting report was able to determine that the number of new customers processed was declining by 1-2% every week – starting about 6 weeks before the audit was conducted. A deeper review of the audit report suggested that

The original service levels related to customer file changes had been getting worse and worse over that same time period

As customer file changes (as per the audit report) took over 85% of the total processing time, the slower processing lead to less time available for new customer processing

This initial diagnostic was confirmed by the client – they had a slowly growing backlog of new customer files

Ultimately the audit was able to highlight which input data source had been causing the slowdown, allowing the company to resolve the problem at its source

Business impact: a major risk (very significant slowdown in new customer set up) was eliminated before it became a real problem

Read full story at https://bit.ly/2PTp0Ix

How to integrate Informatica Data Quality (IDQ) with Informatica MDM?

Overview

Data cleansing and standardization is an important aspect of any Master Data Management (MDM) project. Informatica MDM Multi-Domain Edition (MDE) provides reasonable number of cleanse functions out-of-the-box. However, there are requirements when the OOTB cleanse functions are not enough and there is a need for comprehensive functions to achieve data cleansing and standardization, for e.g. address validation, sequence generation. Informatica Data Quality (IDQ) provides an extensive array of cleansing and standardization options. IDQ can easily be used along with Informatica MDM.

This blog post describes the various options to integrate Informatica MDM and IDQ, explains the advantages and disadvantages of each approach to aid in deciding the optimal approach based on the requirements.

Informatica MDM-IDQ Integration Options
There are three options through which IDQ can be integrated with Informatica MDM.

• Informatica Platform staging
• IDQ Cleanse Library
• Informatica MDM as target
• Option 1: Informatica Platform Staging

Starting with Informatica MDM’s Multi-Domain Edition (MDE) version 10.x, Informatica has introduced a new feature called “Informatica Platform Staging” within MDM to integrate with IDQ (Developer Tool). This feature enables to directly stage/cleanse data using IDQ mappings to MDM’s Stage tables bypassing Landing tables.

Advantages

• Stage tables are immediately available to use in the Developer tool after synchronization eliminating the need to manually create physical data objects.
• Changes to the synchronized structures are reflected into the Developer tool automatically.
• Enables loading data into Informatica MDM’s staging tables bypassing the landing tables.

Read more at, http://www.infotrellis.com/integrate-informatica-data-quality-idq-informatica-mdm/

Intelligent Master Data Management by Informatica

Master Data Management is used to ensure that the master data is maintained and created for the enterprise as system of records. It also makes sure that master data is validated as consistent, correct and complete.

Intelligent Master Data Management by Informatica

Drivers for Master Data Management
The key adoption drivers for organizations to implement MDM are regulatory compliance, cost savings, productivity improvements, increased revenues and strategic goals.

Mostly MDM is deployed as part of broader Data Governance program which involves combination of technology, process, policy and people.

Informatica’s approach to MDM
The Informatica MDM software uniquely identifies all master data and the relationships within it, stored in different multiple systems and different formats. It reconciles duplicate, conflicting and inconsistent data into a golden record for enterprise- Best version of truth.

Informatica MDM is remarkably flexible & scalable unlike other MDM applications where the data models are fixed and you are forced to start with single domain such as product or customer. You can start the MDM project with any domain and as the need grow/change over time, domains can be added to same data model and relationships between different data domains can be defined.

Informatica MDM’s data model, security, business rules and Data stewardship functions can be configured easily to support client’s environment. It can be quickly deployed and maintenance is easy for organization, thus can accelerate time to value.

Generally MDM starts with UI then moves to business logic and in the end data model. Informatica’s platform approach is the other way round and starts with data model, moves to business logic and in the end UI.

Informatica MDM delivers value straight to the organization bottom line by providing accurate and complete view of business critical master data. It creates a data about products, customers, suppliers and help customers optimize critical business process, ensure regulatory compliance and make smarter decisions.

Mastech InfoTrellis competency in Informatica MDM
Mastech InfoTrellis an essential resource if you are looking for right MDM partner for an extremely successful MDM implementation and can help you in delivering a quicker return on investment.

Our Smart MDM™ methodology is a result of our many years of experience working with clients on complex MDM programs. This methodology offers a common sense, multi-phased approach based on parts of Rational Unified Process (RUP) and Agile development methodologies. It blends deliverables with accountability and requires customer-focused teams to collaborate to deliver a high-quality MDM solution. It provides tested methods to ensure success for MDM projects.

For more insights regarding Smart MDM™ methodology of Mastech InfoTrellis please visit our page, http://www.infotrellis.com/smart-methodology/

Advantages of Smart MDM™:

• Value is delivered early and often
• Greater ability to respond to change
• Collaboration encouraged between business and IT
• Tried and tested approach on multiple projects
• Client satisfaction managed more closely