Lemuria's 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.
Course ObjectivesAfter the completion of the Informatica course at Lemuria, you will be able to :
- Understand and identify different Informatica Products
- Describe Informatica PowerCenter architecture & its different components
- Use PowerCenter 9.x components to build Mappings, Tasks, Workflows
- Describe the basic and advanced features functionalities of PowerCenter 9.X transformations
- Understand Workflow Task and job handling
- Describe Mapping Parameter and Variables
- Perform debugging, troubleshooting, error handling and recovery
- Learn to calculate cache requirement and implement session cache
- Execute performance tuning and Optimization
- Recognize and explain the functionalities of the Repository Manager tool
- Identify how to handle services in the Administration Console
- Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation
- Gain insight on ETL best practices using Informatica
The following professionals can go for this course :
1. Software Developers
2. Analytics Professionals
3. BI/ETL/DW Professionals
4. Mainframe developers and Architects
5. Individual Contributors in the field of Enterprise Business Intelligence
The pre-requisites for this course include knowledge of SQL and basic Unix.
Why learn Informatica?Informatica provides the market's leading data integration platform. Tested on nearly 500,000 combinations of platforms and applications, the data integration platform inter operates with the broadest possible range of disparate standards, systems, and applications. This unbiased and universal view makes Informatica unique in today's market as a leader in the data integration platform. It also makes Informatica the ideal strategic platform for companies looking to solve data integration issues of any size.
Learning Objectives - In this, you will understand overview of PowerCenter covering areas such as the Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor.
Topics - Identify different Informatica Products, Describe PowerCenter as a tool to perform Extract transform and load, Interpret PowerCenter Architecture, its different components and their functionalities, Explain the advantages of component based development techniques in PowerCenter.
Learning Objectives - In this module, you will learn about the ETL and the need behind it. You will also learn how to use Informatica PowerCenter tools to create simple ETL jobs.
Topics - ETL and ETL Architecture, 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.
Learning Objectives - In this module, you will learn about different development units of PowerCenter and how they can be used to create a simple mapping.
Topics - Describe & Visualize PowerCenter Designer, Explain how to create mapping in Designer, Explain different Transformations & their usage.
Learning Objectives - In this module, you will learn about two more development units of Informatica PowerCenter namely Workflow manager & monitor and how are they used to create different tasks and workflow.
Topics - Understand PowerCenter Workflow Manager, Describe Flow within a Workflow, Describe Re-usability & Scheduling in Workflow Manager, Understand components of Workflow Monitor, Understand Workflow Task and job handling.
Learning Objectives - In this module, you will understand Advanced Transformation techniques that will equip you to deal with advanced concepts of PowerCenter transformations like, Java, XML etc as well as the re-usability features of PowerCenter.
Topics - Understand the advanced features & functions of Transformations, Learn about Java Transformation, XML File handling, Learn to use Normalizer Transformation, Learn some advanced concepts of ETL, Learn about reusable objects in Informatica.
Learning Objectives - In this module,you will learn that parameters and variables are a way to achieve re-usability from PowerCenter. This module will deal with the scope and use of Parameters & Variables.
Topics - Understand different Parameters and Variables used in PowerCenter, Describe Mapping Parameter & Variables, Learn to use Session Parameters, Learn to use Workflow Variables.
You will work on a real time Project. You will receive a Problem Statement along with a data set to work.
Once you are successfully through with the project (reviewed by an expert), we will award you with a certificate with a performance based grading.
If your project does not get approval in the first attempt, you can take additional assistance to understand the concepts better and reattempt the Project free of cost.
You will work on a real time Project. You will receive a Problem Statement along with a data set to work.
Once you are successfully through with the project (reviewed by an expert), we will award you with a certificate with a performance based grading.
If your project does not get approval in the first attempt, you can take additional assistance to understand the concepts better and reattempt the Project free of cost.
