ADVANCE YOUR CAREER. TRANSFORM YOUR LIFE WITH IN-DEMAND SKILLS FOR AN ON.DEMAND WORLD. EARN MINIMUM £50K WITH YOUR INFORMATICA 9.x SKILLS.

 


EXCELLENT INTERACTIVE SELF-TEACH TRAINING COURSE . IDEAL FOR THOSE DESIGNING AND DEVELOPING DATA WAREHOUSING AND ETL/INTEGRATION SOLUTIONS IN ANY DATABASE, WAREHOUSE OR ANALYTICS DEPLOYMENT ENVIRONMENT.

 

ALSO GOOD FOR FOR THOSE PREPARING FOR ORACLE BI/ANALYTIC APPLICATIONS CERTIFICATION EXAMS; AS WELL AS THOSE WHO WORK WITH OTHER ETL TOOLS (IBM DATASTAGE, MICROSOFT SSIS, ORACLE DI SERVER 11/12C) OR WISH TO CROSS TRAIN / UPSKILL TO AN INFORMATICA 8/9.x ENVIRONMENT.

PERFECT TRAINING MATERIAL WITH VERY GOOD REAL-LIFE BASED SCENARIOS. PACKED WITH TASKS, ACTIVITIES AND EXERCISES. ALSO GOOD FOR INFORMATICA VERSION 8.x ENVIRONMENTS.


INFORMATICA 9.6.x: DATA WAREHOUSING ESSENTIALS SELF-STUDY E-LEARNING

How This Course Is Organised

The Informatica 9.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.x for activities based on real-life work scenarios.
 
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 Topics

Overview
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, TRAINING GUIDE OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, E-LEARNING OR TRAINING GUIDE LEARNING  FORMATS. PRICES DIFFER

 Duration: 1 Year Access


NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY CBT, TRAINING GUIDES OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, CBT OR TRAINING GUIDES E-BOOK LEARNING FORMATS. PRICES DIFFER.


What is eLearning?
eLearning is like CBT (Computer Based Training) training but eLearning is conducted over the internet with tutor support and is usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's eLearning Titles do NOT have voice.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in eLearning format. 

These factors give eLearning a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

eLearning not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

 

The WebLearning unique Methodology

All WebLearning®  CBT,  eLearning and Training Guide courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: ANEW, very effective and proven way of learning. 


FACT:

  • Material retention with eLearning are 45% better than with conventional training methods
  • Your learning curve with eLearning is 25%-55% less than conventional methods
  • The cost of eLearning training is over 65% less than Classroom training
  • eLearning are self-pacing, interactive and simulate the actual software being studied