About us

Developed by Informatica Corporation Informatica Data Quality is a unique kind of Data Quality Management System featuring a suite of applications and components that can integrate well with Informatica PowerCenter. The objective of this platform is to deliver enterprise-strength Data Quality ability across a large number of scenarios. One of the principal advantages of this system is the possibility to solve quality problems in a way achieving real as well as sustainable data quality enhancements. A quality training in Informatica Data Quality can enable candidates proactively monitor and cleanse the data and assist the business in Data Quality and Governance.

Informatica has a service oriented architecture where multiple machines can be controlled and monitored using an single console. It is also called as web oriented architecture as everything runs on a web based service.

Course Duration - Around 20 Hours

Pre-Requisites - Informatica ETL fundamental knowledge is recommended to have

Salient Services Offered:

  • Fully licensed software (Installation & Configuration)
  • Assistance in Resume Building
  • job Oriented Training

An Overview of Informatica Developer 9

Overview of Data Quality and Informatica Developer covering areas such as the GUI, Mappings, Mapplets, Transformations, Content Sets, Data Objects and Tips for working with Developer


Analyst Collaboration

  • Review Information from the Analyst
  • Profiles/Comments/Tags
  • Create/Add to Reference Tables
  • Shared projects and team collaboration means no loss of information or duplication of work across projects

Developer Profiling

  • Perform Join Analysis Profiling
  • Perform Column Profiling
  • Multi Object Profiling
  • Build and execute a Mapping using core transformations
  • Configure Transformation Properties

Data Standardization

  • Develop data standardization mapplets and mappings
  • Cleanse, transform and parse data
  • Data Quality cleansing and parsing transformations

Address Validation

  • Configuring a Reusable AV Transformation
  • AV Transformation Properties
  • AV Inputs and Outputs
  • Define a Reusable AV Mapplet
  • Build and address validation mapping to incorporate your mapplet Matching
  • Grouping Data
  • Key Generator Transformation
  • Key Gen Methods and Properties
  • Analyze Detail Report
  • DQ Matching
  • Perform matching using the Match Transformation
  • Match Properties
  • Matching Algorithms
  • Cluster Analysis Report
  • Create and update matching Mapplets
  • Additional Matching Transformations

Identity Matching

  • Build matching mappings using Identity Matching
  • Identity Populations and Strategies

Automatic Consolidation

  • Automatically associate and consolidate your match data using a variety of association and consolidation
  • Transformations and techniques

Manual Consolidation Using the Data Quality Assistant

  • Build mappings to create and populate the DQA tables using the new Exception Transformation
  • Perform Manual consolidation and bad record management using the DQA

PowerCenter Integration

  • Execute Data Quality mappings/mapplets in PowerCenter

Object Import/Export

  • Learn how to export and import projects using both basic and advanced methods

DQ for Excel

Parameters

  • How to use parameters in Data Quality mappings, transformations and reference tables

Content

  • Content availability with IDQ9
  • Content Management Service
  • How to configure AV information
  • Accelerators
  • Core Accelerators