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.

ade/ 0an>

• 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.

Contact Us:309-200-3848