HONE
YOUR SKILLS AND UPGRADE YOUR STATUS AND INCOME. EARN MINIMUM £60K WITH
YOUR INFORMATICA DATA INTEGRATION AND ETL DEVELOPMENT SKILLS.
VERY GOOD HANDS-ON INTERACTIVE TRAINING MATERIAL (COMPUTER BASED TRAINING - CBT) WITH EXCELLENT SOFTWARE SIMULATIONS USING REAL-LIFE BASED SCENARIOS. PACKED WITH TASKS, ACTIVITIES AND EXERCISES.
PERFECT INTERACTIVE SELF-TEACH TRAINING COURSE FOR THOSE PREPARING FOR INFORMATICA POWERCENTER CERTIFICATION, ORACLE ANALYTIC APPLICATIONS DEVELOPERS AND CONSULTANTS, DATA WAREHOUSING, BI AND PERFORMANCE MANAGEMENT CERTIFICATION EXAMS AS WELL
AS THOSE WHO WORK WITH OTHER ETL AND WAREHOUSE TOOLS OR WISH TO UPSKILL TO AN INFORMATICA 9.x
ENVIRONMENT.
ALSO GOOD FOR INFORMATICA VERSIONS 8.6.x, AND 9.5x ENVIRONMENTS
INFORMATICA 9.6.x: DATA INTEGRATION & ETL DEVELOPMENT BOOT CAMP SELF-STUDY CBT
How This Course Is Organised
The Informatica 9.6.x: ETL Development Boot Camp course provides step-by-step instructions on how to perform a variety of Advanced Data Integration and E- T- L (Extract, Load and Transform) 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 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
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
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
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, TRAINING GUIDE OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, E-LEARNING OR TRAINING GUIDE LEARNING FORMATS
What is Computer Based Training - CBT?
Computer Based Training -CBT's
are 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 CBT Titles do NOT have voice..
Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Courseware Learning formats are deliveredwith FULL LICENCE KEY.
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 CBT format. These factors give CBT's a clear advantage over
conventional, inconvenient and expensive Classroom and Hard-copy print
training methods.
CBT's
not only offers the advantage in terms of convenience and lower cost,
but it also facilitates improved subject-matter comprehension.
NOTE:WebLearning Publishing CBT and Courseware products are now delivered with FULL LICENCE KEY.
FACT:
·Material retention with CBT’S are 45% better than with conventional training methods
·Your learning curve with CBT is 25%-55% less than conventional methods
·The cost of CBT training is over 65% less than Classroom training
·CBT’S are self pacing, interactive and simulate the actual software being studied
The WebLearning unique Methodology
All
WebLearning® CBT and Courseware 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.