IDQ ONLINE TRAINING @APEX FROM HYDERABAD #INDIA

Thanks,

Raavi Raja

APEX | Office#403, PSR Prime Towers | Gachibowli | Hyderabad

India(M): +91-8500-122-107 ,(whats app)

| USA(L):+1 (214)-628-3894

Gtalk: raavi.sriraja@gmail.com

Email: raj@apex-online-it-training.com

WebSite:www.apex-online-it-training.com

Go Green Save Earth Save water 

                                                            CONTENT OF IDQ

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           

                                                                          ^THANQ