This 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.
Informatica PowerCenter is a collection of thick client workbench tools that Developers can use to create, execute, monitor and schedule ETL processes.TAKE THIS COURSE
- 28 hours of Instructor led learning
- 24 hours of High Quality e-Training
- 8 hours of industry projects
- Hands on projects execution with LVTLab
- Expert Assistant Premium Support
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, parameters /variables and overrides.
This course will cover many different types of lookups, such as cached, persistent, and dynamic and multiple row returns. Workflow tasks will be created to define a set of instructions for executing the ETL.
After successfully completing this course, students should be able to do following tasks
- Use Informatica Support to resolve questions and problems with PowerCenter 9.x
- Use PowerCenter 9.x 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.x 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
Introduction to the Informatica PowerCenter Developer Track 1 Course
- Overview of PowerCenter covering areas such as the Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor.
- 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
- View and look up error messages
- Correct mapping and workflow errors
- 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
- Define Joins
- Clarify Active vs. Passive Transformations
- 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.
- Outline Debugger Interface
- Show creation of a break point
- Show Evaluate the Expression™ functionality
- Re-Execute mapping with different values
- 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.
- 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.
- 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.
- 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
- 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.
- 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.
You should enrolled for the courses to get access to the lab documents
You can enroll for the Masters Program through our website. You can make an online payment using any of the following options:
1.Visa debit/credit card
2.American Express and Diners Club cards
Once the online payment is done, you will automatically receive a payment receipt and access information, via email.
1.Access to e-learning content for all the courses included in the learning path
2.Access to exclusive forums, moderated by faculty and industry experts
3.Hands-on Project Execution with LVTLab
4.Earn Masters Certification upon completing the Program requirements of the learning path
Yes, you can cancel your enrolment if necessary. We will refund the course price after deducting an administration fee. To learn more, you can view our Refund Policy.
Your course completion certificate will be auto generated in the LMS once you meet all of the criteria below:
Completion of at least 85% of the eLearning course
Submission of project per course requirements.
Successfully meeting the project evaluation criteria set by our experts
Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail sent by us, will guide you through the process.
Please raise a request through Help & Support. You can also chat with us to get an instant solution.
Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.
Contact us using the form on the LVTLABS website, or select the Live Chat link. Our customer service representatives will be able to give you more details.