Informatica Data Quality is a suite of applications and components that you can integrate with Informatica PowerCenter to deliver enterprise-strength data quality capability in a wide range of scenarios.
Preview
By the end of this training you will learn to:
Describe the Informatica technical architecture
Enumerate the primary Data Quality application services
Plan and install an Informatica domain
Describe best practices in object naming, security, and installation
Describe users, groups, privileges, roles, and permissions
Describe native and LDAP security domains
Describe command line utilities and their use
Plan and create a model repository service
Plan and create a data integration service
Describe the Developer client, projects, folders, and permissions
Describe object permissions issues
Plan and create an Analyst Service
Plan, create, install and configure content including out-of-the-box and address validation files
Describe the Analyst client
Plan and install the Data Director service
Describe the Data Directory client for Data Quality
Describe domain management tasks including the backup and restore of the domain database
Plan, create, and configure the Reporting and Dashboards service
Monitor and troubleshoot the Informatica domain
Query and manage Informatica domain logs
Course Contents
Day 1
Informatica Platform Architecture
Overview of the Informatica platform
Domain, nodes, gateway types
Application and system services
Metadata repository databases
Overview of the data quality application services
Overview of the data quality client applications
Platform Installation and Administration
Plan an Informatica installation
Describe an Informatica platform installation
Observe and locate installation log files
Users and Groups
Describe Informatica users and groups
Overview of Informatica user and password encryption, authentication, and authorization Native and LDAP security domains
User account types
Command Line for Users and Groups
Privileges and Roles
Describe privileges and roles
Domain privileges
Service privileges
System defined roles
Custom roles
Command line for privileges and roles
Day 2
Permissions
Domain permissions
Direct and effective permission types
Client permissions
Object permissions
Command line for permissions
Model Repository Service
Describe the model repository service architecture
Plan, create, and configure a model repository service
Describe MRS log files
Assign privileges and roles
Assign permissions
Model repository log files
Command line for model repository service
Data Integration Service
Describe the data integration service architecture
Plan and create database connections
Plan and create a data integration service
Associated model repository service
Assign profile warehouse database connection and create content
Assign human task database connection and create content
Assign privileges and roles
Assign permissions
Data integration service log files
Command line for data integration service
Developer Client
Describe the Developer client
Describe projects and folders
Import mapping
Edit a mapping
Object permissions and potential issues
Developer client log files
Command line for developer client
Day 3
Analyst Service
Describe the analyst service architecture
Plan and create an analyst service
Identify associated model repository service and data integration service
Assign permissions
Analyst service log files
Describe the command line for Analyst service
Content Management Service
Describe content management service architecture
Plan and create a content management service
Associated model repository service and data integration service
Profile warehouse database connection
Describe and install Address validation content
Describe and install classification model
Describe and install Out-Of-The-Box content
Assign permissions
Describe content management service log files
Describe the command line for content management service
Analyst Client
Describe the analyst client
Manage reference tables
Describe reference table audit trail
Describe the analyst client log files
Describe the command line for Analyst client
Data Director Service
Describe the data director architecture
Plan and create a data director service
Describe the associated data integration service
Assign permissions
Describe the data director service log files
Describe the command line for data director service
Day 4
Data Director for Data Quality Client
Describe the data director for data quality client
Describe the data director for data quality client log files
Describe the command line for data director for data quality client
Domain Administration and Management
Describe Informatica domain operations
Describe domain database backup and restore
Describe node monitoring and management
Describe license management
Describe domain log files
Describe the command line for domain
Reporting and Dashboards Service
Describe reporting and dashboards service
Plan and create a reporting and dashboards service
Import content and configure a report
View a report
Describe reporting and dashboards service log files
Describe the Command line for reporting and dashboards service
Monitoring and Troubleshooting
Describe monitoring in the Administrator and Analyst services
Monitor domain operations
Monitor developer operations
Monitor jobs
Describe the common log files
Describe the command line for monitoring and troubleshooting
Day 5
Informatica Data Services - Development
Define Data Services
Discuss SQL Data Services
Discuss virtual database
Creating an SQL Data Service
Create Virtual Tables
Test Virtual Tables
Navigate SQL Data Services
Developing Physical Data Objects
Define the types of physical data objects
Define the relational data object
Define customized physical data object
Define the flat file data object
Day 6
Deployments
List the deployment objects
Discuss the deployment procedure
Create an Application
Deploy the SQL Data Service onto an Application
View the Application within the Administrator
Client Connections
Discuss client connections
List some important connection requirements
Create JDBC client connections
Create ODBC client connections
Mappings
Discuss mappings
Discuss mapping elements
Discuss mapplets
Create a Logical Data Object Model
Configure a Logical Data Object
Build a Logical Mapping
Create an Data Service
Show the Query Plan
Deploy to an Application
PowerCenter Integration
List the advantages of exporting Developer mappings to PowerCenter
Discuss how to test for compatibility with PowerCenter
Export Mappings from the Developer tool to PowerCenter as either mappings or mapplets
Export the Developer Logical Mapping to XML
Verify the XML was generated correctly
Import the XML into PowerCenter
Validate the Mapping
Save the Mapping
Apps2Fusion Articles 