Habanero Data Solutions

Informatica Fundamentals

Approved by Habanero Data
next available COURSE:
Duration :
5 Day/s
5 Day/s
₦ 350,000
$ 750

Course Information

Everything you need to know

About the course:
This 5 day course will give delegates an indepth introduction to Informatica ETL tool. The course will be begin with an introduction to Informatica PowerCenter 10.4.1. The course will introduce attendees 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 will 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. The course will include hands-on exercises.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Informatica Power Center.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to PowerCenter

  • An Overview of Informatica PowerCenter
  • Overview of PowerCenter covering areas such as the Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor

ETL Fundamentals

  • Create flat file and relational Sources using the Source Analyzer
  • Create flat file and relational Targets using the Target Developer
  • Mappings using the Mapping Designer
  • Workflows using the Workflow Designer
  • Monitor the workflow using the Workflow Monitor
  • Preview Target Data using the PowerCenter Designer

Trouble Shooting

  • Understand PowerCenter Log files
  • Use PC log files to:
  • View and look up error messages
  • Correct mapping and workflow errors

Day 2

PowerCenter Transformations, Tasks and Reusability

  • Define list of PC Designer Transformations and Workflow Tasks
  • Clarify Active vs. Passive Transformations
  • Use the Expression Transformation and Editor in a mapping which applies a file list to load multiple flat files into a stage table utilizing expression and filter transformations to format and screen erroneous customer data
  • Use Reusable Designer Transformations to apply same formatting logic to Employee records

Features & Techniques

  • Outline use of Arrange All and Arrange All Iconic
  • Show ‘Autolink’ feature
  • Show ‘Select Link Path’ feature
  • Define Propagation of Port Properties
  • Joins and Link Conditions
  • Define Joins
  • Clarify Heterogeneous vs. Homogeneous Joins
  • Use a Joiner Transformation to join relational and flat file sources
  • Use the Source Qualify to join two relational sources
  • Make use of Link Conditions to execute one session when the first finishes successfully

Day 3

Using the Debugger

  • Outline Debugger Interface
  • Show creation of a break point
  • Show ‘Evaluate the Expression’ functionality
  • Re-Execute mapping with different values
  • Sequence Generators, Lookups and Caching
  • Define the Sequence Generator
  • Define the Lookup Transformation
  • Understand the different types of Lookups
  • Clarify Lookup Caching
  • Use a Flat File Lookup to add data to a relational target
  • Create a Multiple Row Return Lookup, use Aggregators
  • Expressions to count the number of orders a Customer has as
    well as total the sales for that customer. Add those values to a target
  • Build a Dates Lookup Cache for use in determining start and end dates of target
  • Utilize Event Wait, Event Timer and Email
  • Tasks to wait for flat files and email users upon successful/failed load
  • Use a decision task to set criteria by which the workflow will decide which execution branch to follow

Day 4

Update Strategies, Routers and Overrides

  • Build a mapping that uses Update
  • Strategies and Routers to determine insert/update logic for a target
  • Overrides will be used for incremental (daily) loading of the target
  • Sorter, Aggregator, Unconnected Lookups, Mapping Parameter/Variables and Mapplets/Worklets
  • Define Sorter Transformation
  • Detail Aggregator Transformation and Aggregate Functions
  • Explain Unconnected Lookups and how they are called
  • Describe Mapping
  • Parameters/Variables and initialization priority
  • Outline Mappets and Worklets
  • Use these Transformations to create a mapping which loads records from warehouse Dimension tables to a Fact table
  • Parameter File Instruction

Day 5

Mapping Design Workshop

  • Business requirement details will be provided so that the
    student can design and build their own mapping necessary
    to load a Promotions Aggregate table. The workshop will
    provide Velocity Best Practices documents that can be used
    to determine the correct logic for the mapping Workflow
  • Design Workshop
    Business requirement details will be provided so that the
    student can design and build their own workflow necessary to
    load all staging tables in a single workflow. The workshop will
    provide Velocity Best Practices documents that can be used to
    determine the correct logic for the workflow.

Our international certified trainers have highly experienced Informatica Power Center practitioners who have real-world expertise.

I – Laptops will be provided for all candidates with pre-installed Informatica PowerCenter 10.4.1.

II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).

For more information on our training, please enquire using the form above or call +2348103382376

Informatica Fundamentals

Contact Our Team Today!

    What's Included

    Find out what’s included in the training programme.

    Delivery Options

    Everything you need to know


    Course Schedule

    Find out the next available dates

    Informatica Fundamentals

    Available Dates

    Available Places

    Book or Enquire

    September 19, 2022

    Abuja, Accra, Kigali, Lagos

    We are happy to help

    Call our team today on +234 8103382376 or email [email protected]

    We’re here to discuss your needs with a free consultation and to offer guidance on the best route forward for you or your team. We’re proud of our expert data courses and consultancy services, and we’re always happy to talk about them.