Informatica PowerCenter 9.x Level 1

Informatica PowerCenter 9.X Developer & Admin Course, will introduce the participants to work with the PowerCenter. Developers can use Informatica to create, execute, as well as administer, monitor and schedule ETL processes and understand how these are used in data mining operations. The course will also cover Installation & Configuration of Informatica PowerCenter 9.X and basic Administration Activities. Participants will also get to implement one project towards the end of the course.

  • 24 hours of Direct to Device, Instructor-Led Sessions
  • Program Helps in Empowering business users with the right information at the right time.
  • Program Helps in Seamlessly integration of data from disparate systems for a cohesive data foundation.
  • Guided Assignments for hands-on learning
  • The course will prepare you for handling Installation & Configuration of Informatica PowerCenter 9.X and basic Administration Activities.

Call Me

Online Instructor-Led

batch loading...

Course Features

Related Courses

About Course

This 24 Hours, instructor-led course introduces students to Informatica PowerCenter 9.5 through lecture and hands-on exercises. The course is designed for Database Developers who are new to Informatica PowerCenter.

Informatica PowerCenter is a collection of thick client workbench tools that Developers can use to create, execute, monitor and schedule ETL processes.

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. They will develop cleansing, formatting, sorting and aggregating procedures. They can learn how to use routers, update strategies, mapping parameters /variables and overrides. This course will cover many different types of lookups, such as cached, persistent, and multiple row returns. Workflow tasks will be created to define a set of instructions for executing the ETL.

Course Objectives

After successfully completing this course, students should be able to:

  • Use Informatica Support to resolve questions and problems with PC9.5.
  • Use PowerCenter 9.5 Designer to build mappings that extract data from a source to a target, transforming it as necessary.
  • Use PowerCenter transformations to cleanse, format, join, aggregate and route data to the appropriate targets.
  • Perform error handling/trapping using PowerCenter mappings.
  • Use PowerCenter 9.5 Workflow Manager to build and run a workflow which executes a sessions associated with a mapping.
  • Design and build simple mappings and workflows based on essential business needs.
  • Perform basic troubleshooting using PowerCenter logs and debugger.
Curriculum
Module 1:

An Overview of Informatica PowerCenter 9.

  • Oerview of PowerCenter covering areas such as the Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor.
Module 2:

ETL Fundamentals.

  • Flat file and relational Sources using the Source Analyzer. 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.
Module 3:

Trouble Shooting.

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

PowerCenter Transformatiopns, Tasks and Reusability.

  • Define list of PC Designer Transformations and Workflow Task. 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.
Module 5:

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.
Module 6:

Using the Debugger.

  • Outline Debugger Interface. Show creation of a break point. Show Evaluate the Expression™ functionality. Re-Execute mapping withdifferent values.
Module 7:

Sequence Generators, Lookups and Caching.

  • Define the Sequence Generator. Define the Lookup Transformation. What are the different types of Lookups? Clarify Lookup Caching. Use a Flat File Lookup to add data to a relational target. Build a Dates Lookup Cache for use in determining start and end dates of target records. Utilize Event Wait, Event Timer and Email Tasks to wait for flat files and email users upon successful/failed load.
Module 8:

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.
Module 9:

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 Mapplets and Worklets. Use these Transformations to create a mapping which loads records from warehouse Dimension tables to a Fact table.
Module 10:

Workflow Variables and Tasks.

  • Use PC workflow variables to pass information from one point in a workflow to another. Use an Assignment task to establish the value of a workflow variable within a workflow. Use a decision task to set criteria by which the workflow will decide which execution branch to follow.
Module 11:

Parameter Files and Command Tasks.

  • Use a Parameter file to make mappings and workflows more flexible by defining values for mapping variables, source files, database connections for sessions and workflow log files. Command Tasks will be used to run scripts to rename and move files.
Module 12:

Dynamic Lookups, More Lookup Functionality and Error Logging/Handling with Workshop on Workflow and mapping.

  • Use Dynamic Lookup, Router and Update Strategy in a mapping do a lookup on the target table and determine if the record should be an insert, update or logged to a file as an error. Use PowerCenter Best Practices to create a mapping to trap fatal and non-fatal errors. 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. Business requirements 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. Business requirements 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.
Instructor

All our instructor have at least ten years of industry experience and extensive functional expertise in the fields that they teach. Instructor are handpicked from a selected group of industry experts and mentors, and trained to deliver a great online learning experience.

Certification

Course Participation Certificate from NIIT

Course Participation Soft Certificate from OEM

Pre-Requisites

Windows GUI - At least two years’ work experience and some Knowledge of SQL

FAQs

Who should join this course?

Data Integration developers with little or no experience of PowerCenter.

Why should I join this course?

The course is designed for Database Developers who are new to Informatica PowerCenter. Developers can create, execute, monitor and schedule ETL processes.

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. They will develop cleansing, formatting, sorting and aggregating procedures. They can learn how to use routers, update strategies, mapping parameters /variables and overrides. This course will cover many different types of lookups, such as cached, persistent, and multiple row returns. Workflow tasks will be created to define a set of instructions for executing the ETL.

What are the class/session timings?

Mon-Thur - 10:00 AM to 4:00 PM

Do you provide any study materials?

The faculty will share relevant reference material and links through our discussion forum and through the batch email list.

What happens if I miss a session?

In additions to the study material, we provide you with recordings of each session that you can view anytime you want. So if you miss any live class, you may refer to the recordings of that session.

What is your refund policy?

After registering for the program if for some reason you are unable or unwilling to participate in the program then you can apply for a refund. You can initiate refund any time before the 2nd session of the course After registering for the program if for some reason you are unable or unwilling to participate in the program then you can apply for a refund. You can initiate refund anytime before the second session of the course by sending a mail to support@training.com with your enrolment details and bank account details (where you want the amount to be transferred). Once you initiate a refund request you will receive the amount within 21 days after confirmation of refund request.This is provided you have not downloaded any courseware for the course.

What are the minimum system requirements to attend the program?

Course Features

batch loading...

Related Courses