THIS IS INFORMATICA 9.6.x DATA WAREHOUSING 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 WAREHOUSING.
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 WAREHOUSING BOOT CAMP SELF-STUDY CBT
How This Course Is Organised
The Informatica 9.6.x: Data Warehousing Boot Camp course provides step-by-step instructions on how to perform a variety of Data Warehousing and E-L-T (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.6.x as your primary ETL Tool for developing Extract, Transform and Load processes.
In addition, you learn about the Informatica 9.6.x architecture, installing the platform, configure and manage Informatica domain database and repositories.
Using the graphical interface, 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 Informatica has an advanced metadata system which can store many types of information about your data, including constraints and Slowly-Changing Dimension information. You will also learn about the types of metadata, and how to retrieve it automatically from your database.
You will learn how to create an integration process, using Informatica workflows. This course takes you through some of the more advanced features and uses of Informatica mappings. You will also learn how to track the execution of Informatica sessions.
Audience
Business Intelligence Developer
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Technical Administrator
Course Objectives:
Learn to Plan and Scope your Informatica and Oracle 11g Data Warehouse Projects
Understand BI and Warehouse Architecture Frameworks
Understand the BI and Warehouse Development Process
Understand the Data Warehouse and ETL Development Lifecycle
Understand Data Warehousing Concepts
Understand Dimension Modelling
Understand Data Warehouse Administration
Understand Data Quality Issues in ETL Process
Understand the architecture of the Informatica system
Define Data Sources
Load Heterogeneous Data in a ETL Process
Describe the Informatica 9.6.x Technical architecture
Describe the Informatica domain, nodes, and application services
Describe the Informatica clients
Install Informatica 9.6.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.6.x Designer to build mappings that extract data from a source to a target
Use PowerCenter 9.6.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.6.x Workflow Manager to build and run a workflow
Use PowerCenter 9.6.x Workflow Manager to execute sessions associated with a mapping
Perform basic troubleshooting using PowerCenter debugger
Describe how to Normalise and Denormalise data using PowerCenter.
Describe the Stored Procedure transformation and its two modes of use.
Describe the SQL Transformation
Course Topics
Overview
Course Scenario
Informatica Use-Case Scenarios
ELT for Data Warehouse and Business Intelligence
Service-Oriented Integration
Master Data Management
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
Informatica Velocity: Introduction and Overview
Informatica Velocity: Core Methodology
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
Structured 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
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.x Server
Install Informatica 9.x clients
Configuring PowerCenter 9.x Services
Describe the Administration Console
Create PowerCenter Repositories
Create and enable PowerCenter Integration Services
Create and configure domain folders
Approach to Informatica Warehouse and ETL development
Strategy and Planning Phase
Discover Phase
Analyse Phase
Define Phase
Develop Phase
Deploy Phase
Planning your Informatica BI and Warehouse Project
Approach to Enterprise BI and Warehouse Projects
Rapid Implementation Method - The Enterprise BI Approach
Advantages and Benefits of RIM
Tactical versus Strategic Solution
Understanding Rapid Implementation Method - RIM
Choosing a Business Area to Prototype
Approach to Choosing a Business Area to Prototype
Prototype must align to Business Strategy
Target users
Understanding JAD
JAD Techniques
Capture Domain of Data
Project Management for Data Warehouse
Process for a Successful BI and Data Warehouse
Data Warehouse Project Issues
Data Warehouse Project team Structure
Implementing an Data Warehouse Project
Guiding Requirements for the Project
Measuring BI and Data Warehouse Results
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
Identify the grain
Identify the dimensions
Identify the facts
Verify the model
Create Requirements Definition Document
Agree Requirements Definition document with the Users
Design and Build Warehouse and Reports
Physical Warehouse and Report design considerations
Acceptance Testing
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
PowerCenter Data Warehouse 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.
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
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