Lekki, Lagos, Nigeria
- Classroom Courses
Sorry there are no videos yet
This 5 day course will give delegates a thorough study on using the Informatica ETL tool.
The course will be begin with an introduction to Informatica PowerCenter 9.6. 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 can 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 the Informatica.
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
All delegates will be taken through the following topics:
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
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
Understand PowerCenter Log files
Use PC log files to:
View and look up error messages
Correct mapping and workflow errors
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
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.
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 and
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
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.
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.
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.
- October 8, 2017 @ 9:00PM - 4:00PM
Habanero Data are a UK based training, development and consultancy operating within Nigeria. We deliver high quality and effective Business Intelligence training courses. Passionate about what we do, we are here to help you succeed. Our main aim is to make help you learn and develop of new Business Intelligence skills.. Our Locations: Our training centers are located in Lagos, Abuja and Port Harcourt. We also have specialist mobile trainers who can come out to customer sites to deliver courses to delegates. Our courses can be delivered at your site, at your pace, and tailored to your needs. Our Courses: Let our courses inspire you! A new interest, a new job, a new perspective. Change your career progression by taking a Business Intelligence course. Our courses are designed to increase your skills to meet the needs of real world. We train our students on some of the most comprehensive business intelligence (BI) platforms on the market; including: including: Qlikview, Pentaho, Microstrategy, Hadoop, Tableau, Cognos, Microsoft BI, SAS BI, Microstrategy, Spotfire and Informatica.