How This Course Is Organised
The Informatica 9.6.x: Data Warehousing Essentials course provides step-by-step instructions on how to perform a variety of Data Warehousing, Integration and E-T-L (Extract, Transform and Load) tasks using Informatica 9.6.x for activities based on real-life work scenarios. The WebLearning hands-on series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment.
You will learn how to plan, build and deploy a Data warehouse using Informatica 9.x as your primary ETL Tool for developing Extract, Transform and Load processes.
Using the graphical mappings, you create and manage Informatica repositories, which stores configuration information about the IT infrastructure, the metadata for all applications, projects, models and other Informatica artifacts. You also learn how to create the Informatica Topology, organize Informatica models and design Informatica mappings, procedures, workflows and other objects.
You will learn how to use Informatica PowerCenter to define logical schema objects according to current best practices. You will learn how to use manage projects in Informatica to develop mappings and other objects.
You will learn how to create an integration process, using Informatica workflows. This course takes you through some of the more basic to intermediate features and uses of Informatica mappings. You will also learn how to stop, start and track the execution of Informatica sessions.
Audience
Business Intelligence Developer
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Technical Administrator
Course Objectives
Understand the Informatica Data Warehouse and ETL Development Lifecycle
Understand the BI and Warehouse Development Process
Learn to Manage Informatica Warehouse Projects
Understand Data warehousing Concepts
Understand Dimension Modelling
Understand Data Quality Issues in ETL Process
Understand the architecture of the Informatica system
Manage your Informatica environment using the Informatica Console
Use PowerCenter 9.x Designer to build mappings
Use PowerCenter 9.x Designer to 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
Course TopicsOverview
Course Scenario
Informatica Value Proposition
Informatica Use-Case Scenarios
ELT for Data Warehouse and Business Intelligence
Service-Oriented Integration
Master Data Management
Understanding ETL and Data Warehousing
Introduction to Data Integration
Data Integration Overview
Data Integration Patterns
Roles and Responsibilities
Data Integration Concepts
Consolidation, Normalisation, and Standardisation
Data Integration Paradigms (ETL and ELT)
ETL Processing Categories
Incremental Loads
Detecting Net Changes
Data Integration Management Concepts
Batch Processing and the Enterprise ETL Schedule
ETL Patterns
Data Quality
Introduction to Information and Data Quality
Total Information Quality Management
Establishing the Information Quality Environment
Assessing Data Definition and Information Architecture Quality
Introduction to Enterprise Data Quality Integration Platforms
Informatica Architecture and Overview
Introduction to PowerCenter Platform and Tools
Informatica Editions
Supported Data Sources
Informatica Cloud Overview
PowerCenter Concepts and Architecture
Informatica Terminology and Concepts
Understanding Data Integration Terminology
Introduction to Cloud Integration
PowerCenter Components and User Interface
Transformation Naming Conventions
BI and Warehouse Architecture Framework
Data Sources
Data Access, Transformation, Cleansing
Staged Data
Business Subject Data
Multidimensional Data
Backup, Archive Data
Structured Query Language and OLAP Engine
Business Intelligence Applications
Administration, Automation, Operation, Control
Metadata Repository
Visualisation and Publishing
Data Warehousing and Modelling Concepts
Data Warehousing Concepts
Modelling for Analytics and Data Warehouses
Normalisation
3rd normal Form
Dimensional Modelling
Fact tables
Types of Fact Tables
Dimension Tables
Star Schema
Snowflake Models
Constellation Models
Conformed Dimensions
Alternate Dimensions
Degenerate Dimensions
Junk Dimensions
Slowly Changing Dimensions
Surrogate keys
Data Warehousing Deployment Approaches
Warehouse Bus Architecture
Centralised Data Warehouse Approach
Hub and Spoke Approach
Administrating the Informatica Environment
Understanding Informatica Platform Connectivity
PowerCenter Connectivity
Working in the Administrative Console
Accessing and Exploring the Administration Console
Creating PowerCenter Repository Service
Administering PowerCenter Security
Creating Groups
Creating Users
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
Approach to Informatica Warehouse and ETL development
Strategy and Planning Phase
Discover Phase
Analyse Phase
Define Phase
Develop Phase
Deploy Phase
The BI and Warehouse Development Process
Identify People Involved
Identify business process requirements
The Data Warehouse and the Dimensional Model
Create and Study the enterprise business process list
Identify and Prioritise Business Processes
Identify high level entities and measures for conformance
Select requirements gathering approach
Requirements Gathering
Requirements Analysis
Create Requirements Definition Document
Agree Requirements Definition document with the Users
Design and Build Warehouse and Reports
Acceptance Testing
The Extract, Transform and Integration Process
Data Extraction
The Logical Data Map
Building the Logical Data Map
Approach to Analysing ER Diagrams
Data Content Analysis
Collecting Business Rules in the ETL Process
Integrating Heterogeneous Data Sources
Challenge of Extracting from Disparate Platforms
Processing Fixed Length Flat Files
Processing Delimited Flat Files
Data Transformation
Data Capture
Cleansing and Conforming
Data Cleansing Techniques
Data Conditioning
Data Integration
Data Refining
Data Quality Assessment
Anomalies in Data Fields
Lack of Data Standards
Lack of Data Consolidation
PowerCenter Transformations, Tasks and Reusability Concepts
Source Qualifier Transformation and SQL Statement Generation
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
Creating Mappings for Fact and Dimension Tables
Creating Fact Targets
Creating Dimension Targets
Creating Target Fact and Dimension Tables
Creating the Mapping
Creating a Filter Transformation
Creating a Sequence Generator Transformation
Creating a Stored Procedure Transformation
Completing Mapping
Creating and Running Workflows
Creating the Workflow
Creating a Non-Reusable Session
Defining a Link Condition
Running the Workflow
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.