Informatica Level I Developer Overview

This four-day, instructor-led course exposes the core features of Informatica PowerCenter 8 through lecture and more than twenty hands-on exercises and 2 workshops. In addition to gaining tremendous insight into the data integration platform, students will be exposed to Informatica Velocity Best Practices.

If you would like to book a course, please click here and one of our team will contact you. Alternatively, please call us directly on 0141 582 1380.

Course Details

• 4 day course
• Instructor led
• £2000 per student

Agenda

• Data Integration Concepts
• Data Integration
• Mapping and Transformations
• Tasks and Workflows
• Metadata
• PowerCenter Components and User Interface
• PowerCenter Architecture
• PowerCenter Client Tools
• Lab – Using the Designer and Workflow Manager
• Source Qualifier
• Source Qualifier Transformation
• Velocity Methodology
• Lab Project Overview
• Lab A - Load Payment Staging Table
• Source qualifier Joins
• Lab B - Load Product Staging Table
• Source Pipelines
• Lab C - Load Dealership and Promotions Staging Table
• Expression, Filter, File Lists and Workflow Scheduler
• Expression Editor
• Filter Transformation
• File Lists
• Workflow Scheduler
• Lab - Load the Customer Staging Table
• Joins, Features and Techniques I
• Joiner Transformation
• Shortcuts
• Lab A - Load Sales Transaction Staging Table
• Lab B - Features and Techniques I
• Lookups and Reusable Transformations
• Lookup Transformation
• Reusable Transformations
• Lab A - Load Employee Staging Table
• Lab B - Load Date Staging Table
• Debugger
• Debugging Mappings
• Lab - Using the Debugger
• Sequence Generator
• Sequence Generator Transformation
• Lab - Load Date Dimension Table
• Lookup Caching, More Features and Techniques
• Lookup Caching
• Lab A - Load Promotions Dimension Table
• Lab B - Features and Techniques II
• Sorter, Aggregator and Self-Join
• Sorter Transformation
• Aggregator Transformation
• Active and Passive Transformations
• Data Concatenation
• Self-Join
• Lab - Reload the Employee Staging Table
• Router, update Strategy and Overrides
• Router Transformation
• Update Strategy Transformation
• Expression Default Values
• Source Qualifier Override
• Target Override
• Session Task Mapping Overrides
• Lab - Load Employee Dimension Table
• Dynamic Lookup and Error Logging
• Dynamic Lookup
• Error Logging
• Lab - Load Customer Dimension Table
• Unconnected Lookup, Parameters and Variables
• Unconnected Lookup Transformation
• System Variables
• Mapping Parameters and Variables
• Lab - Load Sales Fact Table
• Mapplets
• Mapplets
• Lab - Load Product Daily Aggregate Table
• Mapping Design
• Designing Mappings
• Workshop
• Workflow Variables and Tasks
• Link Conditions
• Workflow Variables
• Assignment Task
• Decision Task
• Email Task
• Lab - Load Product Weekly Aggregate Table

  If you would like to book a course, please click here and one of our team will contact you. Alternatively, please call us directly on 0141 582 1380.