This course is intended for Informatica PowerCenter developers and administrators. You learn about the Informatica 9.x architecture, installing the platform, configure and manage Informatica domain database, learn about platform best practices for users, groups, privileges, roles, and permissions. In addition, you will learn to create an Informatica domain database and implement repository metadata reporting.
Using the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools and graphical mappings, you create and manage transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data. You will develop cleansing, formatting, sorting and aggregating procedures.
Additional topics include: Dynamic Look-up Expressions, SQL Transformation & Transaction Control Transformations, Extended Use of Parameter Files.
Audience
Business Intelligence Developer
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Technical Administrator
Course Objectives
Learn to Plan and Scope your ETL/ELT Projects
Understand the ETL Development Lifecycle
Understand the Oracle Data Integration Reference Architecture
Understand basic Data warehousing Concepts
Understand basic Dimension Modelling
Understand Data Quality Issues in ETL Process
Describe the Informatica 9.x Technical architecture
Describe the Informatica domain, nodes, and application services
Describe the Informatica clients
Install Informatica 9.x domain
Describe the Administration Console
Create Privileges and Roles
Describe PowerCenter repositories
Deploy PowerCenter metadata from development to test environment
Describe Domain Management
Describe the Informatica PowerCenter architecture
Design and build simple mappings and workflows
Use PowerCenter 9.x Designer to build mappings that extract data from a source to a target
Use PowerCenter 9.x Designer to build transformations
Use PowerCenter transformations to cleanse, format and join data
Use PowerCenter transformations to aggregate and route data to targets.
Perform error handling/trapping using PowerCenter mappings
Describe the use of Mapping Variables and Parameter Files
Use PowerCenter 9.x Workflow Manager to build and run a workflow
Use PowerCenter 9.x Workflow Manager to execute sessions associated with a mapping
Perform basic troubleshooting using PowerCenter logs and debugger
Describe user defined and advanced functions.
Describe how to Normalize and Denormalize data using PowerCenter.
Describe the Stored Procedure transformation and its two modes of use.
Describe the SQL Transformation
Course TopicsOverview
Course Scenario
Understanding ETL and Data Integration Platforms
ETL Framework and Components
The Evolution of ETL
Code Generators versus Engines
Database-Centric ETL
Data Integration Platforms
ETL versus EAI
Understanding the Data Integration Tool Market
Functional Capabilities of Data Integration Tools
Business Intelligence and Data Warehousing Concepts
Warehouse and Data Mart Concepts
OLAP and Business Intelligence Techniques
Introduction to ETL Development
The Planning and Design Thread
The Data Flow Thread
Data Delivery Thread
ETL Data Structures
ETL and Data Staging
Designing the Staging Area
Data Structures in the ETL System
Flat Files
XML Data Sets
DTDs, XML Schemas, and XSLT
Relational Tables
Independent DBMS Working Tables
Third Normal Form Entity /Relation Models
Non-relational Data Sources
Dimensional Data Models
Fact Tables
Dimension Tables
Atomic and Aggregate Fact Tables
Surrogate Key Mapping Tables
Impact Analysis
Metadata Capture
Naming Conventions
Auditing Data Transformation Steps
Summary
Oracle ETL-ELT Reference Architecture
Information Architecture Capabilities
Information Provisioning
Data Processing
Data Governance
Data Virtualisation
Information Delivery
Information Access
Information Modelling
Approach to Oracle ETL development
Strategy and Planning Phase
Discover Phase
Analyse Phase
Define Phase
Develop Phase
Deploy Phase
Understanding the Oracle Data Integration Reference Architecture
Introduction to the Informatica Domain Architecture
Describe the Informatica 9.x technical architecture
Describe the Informatica Domain, Nodes, and application services
Describe the Informatica clients
Installing Informatica 9.6.x
Install Informatica 9.6.x Server
Configuring Domains
Install Informatica 9.x clients
Configuring PowerCenter 9.6.x Services
Describe the Administration Console
Create PowerCenter Repositories
Create and enable PowerCenter Integration Services
Create and configure domain folders
Security: Users and Groups
Describe the Administration Console
Create Users and Groups
Assign Users to Groups
PowerCenter Repository and Client Applications Management
Describe the PowerCenter repositories
Describe PowerCenter Clients and objects
Informatica Architecture and Overview
Introduction to PowerCenter Platform and Tools
Informatica Editions
Supported Data Sources
Informatica Cloud Overview
PowerCenter Concepts and Architecture
Informatica Velocity: Introduction and Overview
Informatica Velocity: Core Methodology
Informatica Terminology and Concepts
Understanding Data Integration Terminology
Introduction to Cloud Integratrion
PowerCenter Components and User Interface
Transformation Naming Conventions
Working with PowerCenter Client Tools
Accessing and Exploring Designer UI
Accessing and Exploring Repository Manager UI
Creating Folders in PowerCenter Repository
Connecting to the PowerCenter Repository
PowerCenter Transformations, Tasks and Reusability
Understand Designer Transformations and Workflow Tasks
Clarify Active vs. Passive Transformations
Understanding Source Qualifiers
Expression Transformations
Expression, Filter Transformations, Worklists and Workflow Scheduler
Heterogeneous Joins
Heterogeneous Joins and Joiner Transformations
Aggregator Transformations
Sorter, Aggregator and Self-Join Transformations
Lookup Transformations
Lookups and Reusable Transformations
Sequence Generator Transforms
Filter Transformations
Joiner Transformations
Union Transformations
Update Strategy Transformations
Router Transformation, Update Strategy and Overrides
Parameters and Variables
Unconnected Lookup, Mapping Parameters and Variables
Understanding PowerCenter ETL Development
Best Practice: Designing Mappings
Creating Source and Target Definitions
Building a Mapping
Building Transformations
Workflows and Worklets
Using the Workflow Manager and Monitor
Best Practice: Designing Workflows
Workflow Variables, Link Conditions and Tasks
Worklets
Timer Task
Control Task
Working with the Debugger
Understanding the Debugger
Using the Debugger
Working with Source and Target Definitions
Creating Source Tables
Creating Source Definitions
Viewing Source Definitions
Creating Target Definitions
Creating Target Tables
Creating Mappings
Creating a Pass-Through Mapping
Creating a Mapping
Connecting Transformations
Creating Sessions and workflows
Configuring Database Connections in Workflow Manager
Creating a Reusable Session
Creating a workflow
Running and Monitoring workflows
Opening Monitor and Running the workflow
Previewing Data
Working with Transformations
Exploring Transformations in PowerCenter
Exploring Designer Features
Using the Overview Window
Arranging Transformations
Creating a Target Definition and Target
Creating a Target Definition
Creating a Target Table
Creating a Mapping with Aggregate Values
Creating a Mapping
Creating Aggregator Transformations
Creating Aggregate Calculations
Creating Expression Transformations
Creating Lookup Transformations
Connecting the Target
Creating Sessions and workflows
Creating a Session
Creating a workflow
Running the workflow
Viewing Logs
Stored Procedure & SQL Transformations
Describe the use of the Stored Procedure transformation in a mapping or mapplet
Describe the uses of the SQL Transform
NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY E-LEARNING, CBT OR TRAINING-KIT FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, E-LEARNING OR CBT LEARNING FORMATS. PRICES DIFFER.