eBay

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 SELF-TEACH TRAINING COURSE . IDEAL FOR THOSE DESIGNING AND DEVELOPING ETL AND DATA 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/10g) 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.x: DATA INTEGRATION & ETL DEVELOPMENT SELF-STUDY TRAINING GUIDE

How This Course Is Organised

The Informatica 9.x: Integration & ETL Development Fundamentals course provides step-by-step instructions on how to perform a variety of Data Integration and E-T- L (Extract, Transform and Load) tasks using Informatica 9.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.

This course will introduce you to working with the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools, performing tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data. You will develop cleansing, formatting, sorting and aggregating procedures. You can learn how to use routers, update strategies, parameters /variables and overrides. This course will cover many different types of lookups, such as cached, persistent, dynamic and multiple row returns. Workflow tasks will be created to define a set of instructions for executing the ETL..

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 artefacts. You also learn how to create the Informatica Topology, organise Informatica models and design Informatica mappings, procedures, workflows and other objects..
.

Audience
Developer in the Informatica Developer environment
ETL project managers
Team Leads
Business Intelligence Developer
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Technical Administrator

Prerequisites
General knowledge of client/server computing environment technologies
Understanding of server operating systems
Basic problem solving skills
Exposure to SQL and Database Technologies
Some familiarity with database connectivity requirements
Administrator experience

Course Objectives:
Understand the ETL Development Lifecycle
Understand basic Data warehousing Concepts
Understand basic Dimension Modelling
Understand Data Quality Issues in ETL Process
Understand the architecture of the complete Informatica system
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

Course Topics

Overview
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

Informatica Value Proposition
Traditional ETL to Integration and Data Warehousing
Conventional ETL Design

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

Approach to Informatica ETL development
Strategy and Planning Phase
Discover Phase
Analyse Phase
Define Phase
Develop Phase
Deploy Phase

Understanding 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

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

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

What is a Training Guide?

In a nutshell, Self-Study Training Guide products are similar to Microsoft’s step-by-step books except Self-Study Training Guide products come with far more theory and practice; updated regularly ( every 3 months) and are delivered on CD-ROM in e-Book format with FULL LICENCE KEY.

Today's competitive business environment and frequent software updates by software vendor’s demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Training Guides which are updated regularly - every QUARTER (3 months) - with FREE UPDATES to the LATEST EDITION: A NEW effective and proven way of Publishing and Learning.

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

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

NOTE: WebLearning Publishing Training Guide products are no longer available in Hard-copy Printformat. They are now delivered in eBook Format with FULL LICENCE KEY.

About eBook formats

eBooks are available in the following formats:

EPUB - The open industry format known for its reflowable content and usability on supported mobile devices.
MOBI - The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.
PDF - The popular standard, which reproduces the look and layout of the printed page.

This eBook is delivered in the PDF format and is delivered on CD-ROM with Full Licence Key.

FACT:

Material retention with Self-study Training Guide is 35% better than with conventional training methods
Your learning curve with Self-study Training Guide is 20%-40% less than conventional methods
The cost of Self-study Training Guide training is over 95% less than Classroom training
Self-study Training Guide are self pacing, hands-on and offer step-by- step guide to actual software being studied.

The WebLearning unique Methodology

All WebLearning® 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: A NEW, very effective and proven way of learning.

NOTE: WebLearning Publishing Training Guide products are no longer available in Hard-copy Printformat. They are now delivered in eBook Format with FULL LICENCE KEY