Informatica Data Quality Online Training

[cssadhar]

Repository Migration Guide

Informatica Resources

Introduction to Data Quality Repository Migration

Migrating Repository and Reference Data

Troubleshooting Migration of Data Quality Objects

Accelerator Guide

Introduction to Accelerators

Core Accelerator

Australia/New Zealand Accelerator

Brazil Accelerator

Financial Services Accelerator

France Accelerator

Germany Accelerator

Portugal Accelerator

United Kingdom Accelerator

U.S./Canada Accelerator

Address Validator Port Reference

Address Validator Port Reference

Introduction

Address Validation Status Ports

Building and Residence Data Ports

Business and Organization Data Ports

City and Locality Data Ports

Country Data Ports

Customer Segmentation Data Ports

Demographic Data Ports

Enrichment Data Ports

Formatted Data Ports

Postal Carrier Certification Data Ports

Postcode Data Ports

Province and State Data Ports

Residual Data Ports

Street Data Ports

User Guide

Informatica Resources

Introduction to Informatica Data Quality Analyst

Projects

Data Objects

Exception Record Management

Reference Tables

Content Installation Guide

Informatica Resources

Content Installation Overview

Installing Content

Post-Installation Steps for Address Reference Data

Installation

Installation

Known Limitations

Informatica Global Customer Support

User and Developer Guide

Informatica Resources

Overview

This chapter includes the following topics:

Data Quality for Microsoft Excel Overview

Data Quality Service Process

Installation

Prerequisites for Excel Users

Prerequisites for Data Quality Developers

Installing Data Quality for Microsoft Excel

Data Quality Services for Excel Users

Data Quality Services for Excel Users Overview

Add and Remove Services

Run a Service

Data Quality for Microsoft Excel Configuration

Service Review

Troubleshooting

Data Quality Service Example

Data Quality Service Example Overview

Input Data 15

Using the Data Quality Service

Output Data

Data Quality Services for Developers

Data Quality Services for Developers Overview

Deploying Data Quality for Excel in an Organization

Data Quality Service Requirements

Data Quality Services Optimization

Adding a Data Quality Service to a Data Integration Service

Adding a Data Quality Service to a Web Services Hub

Provide a Data Quality Service to Excel Users

Getting Started Guide

Informatica Resources

Getting Started Overview

Informatica Domain Overview

Introducing Informatica Analyst

Informatica Developer Overview

The Tutorial Story

The Tutorial Structure

Getting Started with Informatica Analyst

Setting up Informatica Analyst

Creating Data Objects

Creating Quick Profiles

Creating Custom Profiles

Creating Expression Rules

Creating and Running Scorecards

Creating Reference Tables from Profile Columns

Creating Reference Tables

Getting Started with Informatica Developer

Setting Up Informatica Developer

Importing Physical Data Objects

Profiling Data

Parsing Data

Standardizing Data

Validating Address Data

User Guide

Informatica Resources

Introduction to Informatica Data Director for Data Quality

Informatica Data Director for Data Quality Overview

Tasks and Workflows

Informatica Data Director for Data Quality User Interface

Tasks

Tasks Overview

Human Tasks and Task Instances

Task Types

Task Status

Task Data Export

Task Administration

Multiple Task Completion

Exporting Task Data

Assigning a Task to a User

Viewing Tasks Assigned to Other Users

Viewing a List of Tasks in a Human Task

Completing Multiple Tasks

Exception Records

Exception Records Overview

Data View for Exception Records

Exception Record Correction

Exception Record Review

Exception Record Actions and Status

Exception Record Example

Editing Exception Records

Filtering Exception Tasks in the Data View

Setting the Status of an Exception Record

Reviewing Exception Records

Duplicate Records

Duplicate Records Overview

Data View for Duplicate Records

Duplicate Record Correction

Duplicate Record Review

Duplicate Record Actions and Status

Duplicate Record Example

Filtering Duplicate Tasks in the Data View

Editing a Cluster in a Duplicate Task

Creating a Cluster

Finding Duplicate Records in Multiple Clusters

Setting the Status of a Cluster

Reviewing Duplicate Records

Audit Trail Operations

Audit Trail Operations Overview

Audit Trail Data

Audit View Filters

Audit View

Filtering Records in the Audit View

Installation and Configuration Guide

Informatica Resources

Installation Overview

Informatica Installation

Informatica Services

Informatica Clients

Before You Begin

Before You Begin Overview

License Key

Incremental License Key

Uninstall Data Transformation

Informatica Services Pre-Installation Tasks

Informatica Services Pre-Installation Tasks Overview

Informatica Services Pre-Installation Tasks on UNIX

Informatica Services Pre-Installation Tasks on Windows

Before you create the Informatica Domain

Informatica Services Installation

Informatica Services Installation Overview

Installing the Informatica Services in Graphical Mode

Installing the Informatica Services in Console Mode

Installing the Informatica Services in Silent Mode

Informatica Services Post-Installation Tasks

Informatica Services Post-Installation Tasks Overview

Configure the Environment Variables

Verify the System Requirements for the Domain and Application Services

Verify the Setup for 32-bit and 64-bit Platforms

Install the Database Client Software

Verify Third Party Software Requirements

Verify the Host File Configuration

Starting Informatica Services

Starting Informatica Services Overview

Starting and Stopping Informatica

Logging in to Informatica Administrator

Configuring the Informatica Windows Service

Getting Started with the Data Quality Services

Configure the Data Quality Modules on the Data Integration Service

Configure Reference Data Properties

Set Privileges on Reference Table Data

Informatica Clients Pre-Installation Tasks

Informatica Clients Pre-Installation Tasks Overview

Verify System User Account

Informatica Clients Installation

Informatica Clients Installation Overview

Installing in Graphical Mode

Installing in Silent Mode

Informatica Clients Post-Installation Tasks

Informatica Clients Post-Installation Tasks Overview

Verify that a Graphics Display Server is Available

Configure the Web Browser

Install the Languages for the Client Tools

Configure the Workspace Directory

Starting Informatica Clients

Starting the Developer Tool

Logging In to the Analyst Tool

Troubleshooting the Informatica Installation

Installation Troubleshooting Overview

Installation Log Files

Troubleshooting Domains and Nodes

Troubleshooting Data Transformation Server

Repository Database Configuration

Model Repository Database Requirements

Profiling Warehouse Database Requirements

Reference Data Database

Staging Database Requirements

Human Task Database Requirements

Informatica Platform Connectivity

Connectivity Overview

Domain Connectivity

Data Quality Connectivity

Native Connectivity

ODBC Connectivity

JDBC Connectivity

JDBC and ODBC Driver Installation

JDBC and ODBC Driver Installation Overview

JDBC Driver Installation

ODBC Driver Installation on Windows

ODBC Driver Installation on UNIX

Informatica Utilities Installation

Informatica Utilities Installation Overview

Command Line Programs and Utilities

Configuring the Power Center Utilities

Configuring the Metadata Manager Utilities

Informatica Documentation Installation

Documentation Installation Overview

Installing the Informatica Documentation

Viewing the Informatica Product Documentation

Troubleshooting

Uninstallation

Uninstallation Overview

Informatica Server Uninstallation

Informatica Clients Uninstallation

Connecting to Databases from Windows

Connecting to Databases from Windows Overview

Connecting to an IBM DB2 Universal Database from Windows

Connecting to Microsoft Access and Microsoft Excel from Windows

Connecting to a Microsoft SQL Server Database from Windows

Connecting to an Oracle Database from Windows

Connecting to a Sybase ASE Database from Windows

Connecting to a Teradata Database from Windows

Connecting to Databases from UNIX

Connecting to Databases from UNIX Overview

Connecting to an IBM DB2 Universal Database from UNIX

Connecting to Microsoft SQL Server from UNIX

Connecting to an Oracle Database from UNIX

Connecting to a Sybase ASE Database from UNIX

Connecting to a Teradata Database from UNIX

Connecting to an ODBC Data Source

Sample odbc.ini File

Updating the Dynamic Sections Parameter of a DB2 Database

Dynamic Sections Parameter Overview

Updating the Dynamic Sections Parameter

Installation and Configuration Checklist

Installation Checklist Overview

Before You Install

Informatica Services Installation

Informatica Client Installation

User Guide

Informatica Resources

Informatica Data Quality Integration

Data Quality Integration Overview

Data Quality Features and Functionality

Integration Installers

Object Import to Power Center

Reference Data Installation

Data Quality Transformations in Power Center

Concurrent Installations and Product Upgrades

Integration Matrix

After You Install

Installation

Installation Overview

System Requirements

Before You Install

Installing the Server Plug-in

Installing the Client Plug-in

Registering the Plug-In with Power Center

Reference Data Requirements

Reference Data Overview

Reference Data File Requirements

Address Reference Data Requirements

Identity Population Data Requirements

Probabilistic Model and Classifier Model Requirements

Upgrade Guide for Version 9.0.1

Informatica Resources

Upgrade Overview

Informatica Upgrade

Upgrade Process

Upgrade Tasks

Before You Upgrade the Domain and Server Files

Pre-Upgrade Tasks

Review the Windows Requirements

Review the UNIX Requirements

Uninstall Data Transformation

Prepare the Domain

Prepare the Model Repository

Prepare the Profiling Warehouse

Prepare the Staging Database

Shut Down the Domain

Domain and Server Files Upgrade

Domain and Server Files Upgrade Overview

Upgrading in Graphical Mode

Upgrading in Console Mode

Upgrading in Silent Mode

Upgrading with Changes to the Node Configuration

Troubleshooting the Domain Upgrade

Prepare to Change the Node Configuration

Before You Upgrade the Application Services

Pre-Upgrade Tasks

Configure Informatica Environment Variables

Configure Locale Environment Variables

Clear Browser Cache

Change the Node Configuration

Application Service Upgrade

Application Service Upgrade Overview

Service Upgrade Wizard

Informatica Client Upgrade

Informatica Client Upgrade Overview

Informatica Client Upgrade Options

Upgrading in Graphical Mode

Upgrading in Silent Mode

After You Upgrade

Informatica Domain

Data Integration Service

Analyst Service

Upgrade the Informatica Drivers for SQL Data Services

Merge the Address Doctor Configuration Files

Upgrade Checklist

Upgrade Checklist Overview

Before You Upgrade the Domain and Server Files

Domain and Server Files Upgrade

Before You Upgrade the Application Services

Application Service Upgrade

Informatica Client Upgrade

After You Upgrade

Upgrade Guide for Version 9.1.0

Informatica Resources

Upgrade Overview

Informatica Upgrade

Upgrade Process

Upgrade Tasks

Before You Upgrade the Domain and Server Files

Pre-Upgrade Tasks

Review the Windows Requirements

Review the UNIX Requirements

Uninstall Data Transformation

Prepare the Domain

Prepare the Model Repository

Prepare the Profiling Warehouse

Prepare the Staging Database

Shut Down the Domain

Prepare to Change the Node Configuration

Domain and Server Files Upgrade

Domain and Server Files Upgrade Overview

Upgrading in Graphical Mode

Upgrading in Console Mode

Upgrading in Silent Mode

Upgrading with Changes to the Node Configuration

Troubleshooting the Domain Upgrade

Before You Upgrade the Application Services

Pre-Upgrade Tasks

Configure Informatica Environment Variables

Configure Locale Environment Variables

Clear Browser Cache

Change the Node Configuration

Application Service Upgrade

Application Service Upgrade Overview

Service Upgrade Wizard

Informatica Client Upgrade

Informatica Client Upgrade Overview

Informatica Client Upgrade Options

Upgrading in Graphical Mode

Upgrading in Silent Mode

After You Upgrade

Informatica Domain

Data Integration Service

Analyst Service

Content Management Service

Data Director Service

Informatica Analyst

Upgrade the Informatica Drivers for SQL Data Services

Merge the Address Doctor Configuration Files

Upgrade Checklist

Upgrade Checklist Overview

Before You Upgrade the Domain and Server Files

Domain and Server Files Upgrade

Before You Upgrade the Application Services

Application Service Upgrade

Informatica Client Upgrade

After You Upgrade

Upgrade Guide for Version 9.5.0

Informatica Resources

Upgrade Overview

Informatica Upgrade

Upgrade Process

Upgrade Tasks

Before You Upgrade the Domain and Server Files

Pre-Upgrade Tasks

Review the Windows Requirements

Review the UNIX Requirements

Uninstall Data Transformation

Prepare the Domain

Prepare the Model Repository

Prepare the Profiling Warehouse

Prepare the Staging Database

Shut Down the Domain

Prepare to Change the Node Configuration

Domain and Server Files Upgrade

Domain and Server Files Upgrade Overview

Upgrading in Graphical Mode

Upgrading in Console Mode

Upgrading in Silent Mode

Upgrading with Changes to the Node Configuration

Troubleshooting the Domain Upgrade

Before You Upgrade the Application Services

Pre-Upgrade Tasks

Configure Informatica Environment Variables

Configure Locale Environment Variables

Clear Browser Cache

Change the Node Configuration

Application Service Upgrade

Application Service Upgrade Overview

Service Upgrade Wizard

Informatica Client Upgrade

Informatica Client Upgrade Overview

Informatica Client Upgrade Options

Upgrading in Graphical Mode

Upgrading in Silent Mode

After You Upgrade

Informatica Domain

Data Integration Service

Analyst Service

Content Management Service

Data Director Service

Informatica Analyst

Upgrade the Informatica Drivers for SQL Data Services

Merge the Address Doctor Configuration Files

Upgrade Checklist

Upgrade Checklist Overview

Before You Upgrade the Domain and Server Files

Domain and Server Files Upgrade

Before You Upgrade the Application Services

Application Service Upgrade

Informatica Client Upgrade

After You Upgrade

User Guide

Informatica Resources

Informatica Data Quality Concepts

Introduction to Data Quality

Reference Data

Data Quality Features in Informatica Developer

Column Profiles in Informatica Developer

Column Profile Results in Informatica Developer

Rules in Informatica Developer

Scorecards in Informatica Developer

Mapplet and Mapping Profiling

Reference Data

Data Quality Features in Informatica Analyst

Column Profiles in Informatica Analyst

Column Profile Results in Informatica Analyst

Rules in Informatica Analyst

Scorecards in Informatica Analyst

Exception Record Management

Reference Tables

System Performance Guidelines

Informatica Resources

Profiling Service Module Performance Tuning

Profiling Service Module Performance Tuning Overview

Profiling Service Module Overview

Data Integration Service Resources

Profiling Service Module Resources

Column Profiling Resource Guidelines

Key and Functional Dependency Resource Guidelines

Foreign Key and Overlap Discovery Resource Guidelines

Profile Warehouse Guidelines

System Performance Guidelines for Data Quality Mapping Operations

Overview

Basic On-Disk Installation Size

General Runtime Memory Size

Mapping Memory and Disk Size Guidelines

Data Quality Table Guidelines

Summary

Disk and Memory Guidelines for United States Customers

The variable elements of disk and memory usage increase when multiple users concurrently run mappings with Disk- and memory-intensive transformations.

Base server disk requirement: 12 GB

Base memory requirement: 2 GB

This example assumes that a mapping without disk- or memory-sensitive transformations has no significant impaction calculations. This will not be true for very complex mappings.

Address Validation Reference Data

Identity Population Data

Identity Population Data with On-Disk Size.

Contact us :309-200-3848