iBase Training

Official Website

Informatica IDQ realtime online training course content

 

An Overview of Informatica Developer Tool

Overview of Data Quality and Informatica Developer covering areas such as the GUI, Mappings, Mapplets,Transformations, Content Sets, Data Objects and Tips forworking 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

Scorecard

Business trend analysis by using chart

Data quality Transformations

General Transformations

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 Ouputs

– 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

Exceptions Handling mechanism
Match and Merge mechanism
Data Consolidation Mechanism
Tasks

PowerCenter Integration

– Execute Data Quality mappings/mapplets in PowerCenter

Deployment Process

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

DQ for Excel

– Run Data Quality mappings on Excel spreadsheets

Parameters

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

Content

– What content is available with IDQ9?

– Content Management Service

– How to configure AV information

– What are Accelerators? – What comes with the Core Accelerator?

LAB Exercises

Use Cases

 

Student Registration

Name

Email Id

Country Code

Mobile No

Course Name

City