THIS IS INFORMATICA 9.6.x: DATA INTEGRATION & ETL DEVELOPMENT BOOT CAMP SELF-STUDY CBT WITH FULL LICENCE KEY. LEARN AND PUT THE £££'S BACK IN YOUR POCKET. SKILL UP - MOVE ON - EARN MORE £££s....
FACT: EARN MINIMUM £55K A YEAR WITH ORACLE YOUR INFORMATICA POWERCENTER SKILLS!!
FACT: ALL ORACLE VERTICAL APPLICATIONS AND ANALYTIC APPLICATIONS USE POWERCENTER AS THE STANDARD ETL/ELT AND INTEGRATION TOOL!!
EXCEPTIONALLY
GOOD TRAINING MATERIAL. INTERACTIVE SELF-STUDY TRAINING MATERIAL (CBT) WITH SOFTWARE SIMULATIONS, HANDS-ON REAL-LIFE BASED
STEP-BY-STEP SCENARIOS. PACKED WITH TASKS, ACTIVITIES AND EXCERCISES WITH THE
LATEST MATERIALS AVAILABLE ON INFORMATICA & DATA INTEGRATION.
PERFECT SELF-STUDY TRAINING COMPANION FOR INFORMATICA DATA INTEGRATION AND ETL DEVELOPERS, ETL CONSULTANTS, BI & OLAP DEVELOPERS, HYPERION EPM 11.1.x INTEGRATION AND ETL DEVELOPERS, ORACLE ANALYTICS APPLICATIONS CONSULTANTS, ORACLE RETAIL, ORACLE INSURANCE AND ORACLE FINANCIAL ANALYTICS APPLICATIONS CONSULTANTS, ALSO GOOD FOR ANALYSTS AND PROJECT MANAGERS WORKING IN A DATA WAREHOUSING AND OR BIG DATA INTEGRATION ENVIRONMENT. ALSO FITS IN WELL FOR THOSE WHO WORK WITH OR WISH TO CROSS/UPSKILL FROM SAP BUSINESS OBJECTS BODI, MICROSOFT SSIS, IBM DATA STAGE TO AN INFORMATICA ENVIRONMENT.
GOOD FOR POWERCENTER VERSIONS 8.x, 9.x & 10.x 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
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.
ENHANCE YOUR CAREER > GAIN A COMPETITIVE EDGE
GET HANDS-ON TRAINING TO TAKE YOUR SKILLS AND CAREER TO THE NEXT LEVEL
GAIN CREDIBILITY, IMPROVE YOUR CV, BUILD CONFIDENCE, INCREASE YOUR PROMOTION POTENTIAL
What is a CBT?
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 delivered with 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 Training Guides products are now delivered
with FULL LICENCE KEY.
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: ANEW, very effective and proven way of learning. You need to register your product to qualify for FREE UPGRADES.
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