Preface
Informatica Resources
Informatica My Support Portal
Informatica Documentation
Informatica Web Site
Informatica How-To Library
Informatica Knowledge Base
Informatica Support YouTube Channel
Informatica Marketplace
Informatica Velocity
Informatica Global Customer Support
Getting Started Overview
Informatica Domain Overview
Feature Availability
Introducing Informatica Analyst
Informatica Developer Overview
Informatica Developer Welcome Page
Cheat Sheets
Data Quality and Profiling
The Tutorial Story
The Tutorial Structure
Informatica Analyst Tutorial
Informatica Developer Tool
Tutorial Prerequisites
Part I: Getting Started with Informatica Analyst
Lesson 1. Setting Up Informatica Analyst
Setting Up Informatica Analyst Overview
Task 1. Log In to Informatica Analyst
Task 2. Create a Project
Task 3. Create a Folder
Setting Up Informatica Analyst Summary
Lesson 2. Creating Data Objects
Creating Data Objects Overview
Task 1. Create the Flat File Data Objects
Task 2. View the Data Object Properties
Creating Data Objects Summary
Lesson 3. Creating Quick Profiles
Creating Quick Profiles Overview
Task 1. Create and Run a Quick Profile
Task 2. View the Profile Results
Creating Quick Profiles Summary
Lesson 4. Creating Custom Profiles
Creating Custom Profiles Overview
Task 1. Create a Custom Profile
Task 2. Run the Profile
Task 3. Drill Down on Profile Results
Creating Custom Profiles Summary
Lesson 5. Creating Expression Rules
Creating Expression Rules Overview
Task 1. Create Expression Rules and Run the Profile
Task 2. View the Expression Rule Output
Task 3. Edit the Expression Rules
Creating Expression Rules Summary
Lesson 6. Creating and Running Scorecards
Creating and Running Scorecards Overview
Task 1. Create a Scorecard from the Profile Results
Task 2. Run the Scorecard
Task 3. View the Scorecard
Task 4. Edit the Scorecard
Task 5. Configure Thresholds
Task 6. View Score Trend Charts
Creating and Running Scorecards Summary
Lesson 7. Creating Reference Tables from Profile Columns
Creating Reference Tables from Profile Columns Overview
Task 1. Create a Reference Table from Profile Columns
Task 2. Edit the Reference Table
Creating Reference Tables from Profile Columns Summary
Lesson 8. Creating Reference Tables
Creating Reference Tables Overview
Task 1. Create a Reference Table
Creating Reference Tables Summary
Part II: Getting Started with Informatica Developer
Lesson 1. Setting Up Informatica Developer
Setting Up Informatica Developer Overview
Task 1. Start Informatica Developer
Task 2. Add a Domain
Task 3. Add a Model Repository
Task 4. Create a Project
Task 5. Create a Folder
Task 6. Select a Default Data Integration Service
Setting Up Informatica Developer Summary
Lesson 2: Importing Physical Data Objects
Importing Physical Data Objects Overview
Task 1. Import the Boston_Customers Flat File Data Object
Task 2. Import the LA_Customers Flat File Data Object
Task 3. Importing the All_Customers Flat File Data Object
Importing Physical Data Objects Summary
Lesson 3. Profiling Data
Profiling Data Overview
Task 1. Perform a Join Analysis on Two Data Sources
Task 2. View Join Analysis Results
Task 3. Run a Profile on a Data Source
Task 4. View Column Profiling Results
Profiling Data Summary
Lesson 4. Parsing Data
Parsing Data Overview
Task 1. Create a Target Data Object
Step 1. Create an LA_Customers_tgt Data Object
Step 2. Configure Read and Write Options
Step 3. Add Columns to the Data Object
Task 2. Create a Mapping to Parse Data
Step 1. Create a Mapping
Step 2. Add Data Objects to the Mapping
Step 3. Add a Parser Transformation to the Mapping
Step 4. Configure the Parser Transformation
Task 3. Run a Profile on the Parser Transformation
Task 4. Run the Mapping
Task 5. View the Mapping Output
Parsing Data Summary
Lesson 5. Standardizing Data
Standardizing Data Overview
Task 1. Create a Target Data Object
Step 1. Create an All_Customers_Stdz_tgt Data Object
Step 2. Configure Read and Write Options
Task 2. Create a Mapping to Standardize Data
Step 1. Create a Mapping
Step 2. Add Data Objects to the Mapping
Step 3. Add a Standardizer Transformation to the Mapping
Step 4. Configure the Standardizer Transformation
Task 3. Run the Mapping
Task 4. View the Mapping Output
Standardizing Data Summary
Lesson 6. Validating Address Data
Validating Address Data Overview
Task 1. Create a Target Data Object
Step 1. Create the All_Customers_av_tgt Data Object
Step 2. Configure Read and Write Options
Step 3. Add Ports to the Data Object
Task 2. Create a Mapping to Validate Addresses
Step 1. Create a Mapping
Step 2. Add Data Objects to the Mapping
Step 3. Add an Address Validator Transformation to the Mapping
Task 3. Configure the Address Validator Transformation
Step 1. Set the Default Address Reference Dataset
Step 2. Configure the Address Validator Transformation Input Ports
Step 3. Configure the Address Validator Transformation Output Ports
Step 4. Connect Unused Data Source Ports to the Data Target
Task 4. Run the Mapping
Task 5. View the Mapping Output
Validating Address Data Summary
Frequently Asked Questions
Informatica Analyst FAQ
Informatica Developer Frequently Asked Questions
Preface
Informatica Developer Frequently Asked Questions
GettingStarted