Informatica Online Training
4. Describe the basic and advanced features functionalities of PowerCenter 9.X transformations
12. Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation
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.
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.
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.
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.
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.
Learning Objectives - In this module, you will understand the operational part of the PowerCenter. This module will help you understand the features provided by Informatica to debug, troubleshoot & handle errors. The concepts of recovery will also be discussed.
Topics - Describe basic PowerCenter Error, Follow a basic troubleshooting methodology, Using the debugger, Use Workflow and Session logs to diagnose errors, Recognize & repair, Connection Errors & Network errors, Design Error Handling Strategies for intended purpose, Understand the recovery scenarios & mechanisms, Properly Configure Workflow & sessions for recovery, Understand the purpose of High Availability, Monitoring the PowerCenter Environment.
Learning Objectives - Caches play important part of any application. This module will help you understand the implementation of Cache by Informatica and how can they be used to accomplish performance efficient ETL jobs. The pros & cons will be covered.
Learning Objectives - The most important concept for any application. Superior performance wins the race everywhere.This module will enlighten the performance aspects of Informatica PowerCenter components and the efficient usage of them.
Learning Objectives - More of a Administrators job. This module will tell you about the usage and components of PowerCenter Repository Manager.
Learning Objectives - At the completion of this module, you should be able to: Put in your own words an overview of the PowerCenter Administration Console, Recognize and explain integration and repository service properties. Identify how to handle services In the Administration Console, Explain how to handle locks through the Administration Console, and Illustrate how to create users and groups.
Topics - Put in your own words an overview of the PowerCenter Administration Console, Recognize and explain the integration and repository service properties, Identify how to handle services in the Administration Console, Explain how to handle locks through the Administration Console, Illustrate how to create users and groups.
Learning Objectives - The technical architecture module has been carefully knitted to give you the detailed coverage of the architectural aspects of Informatica as a whole and PowerCenter in particular.
Learning Objectives - The installation and configuration process along with regular Administration and Operational jobs. The module is most suited for the persons interested into the architectural components of Informatica.
Learning Objectives - This module will deal with Command line part of Informatica PC. The usage of most frequently used command line tools and their benefits will be discussed
Learning Objectives - This module will deal with different day to day ETL scenarios and their implementation in Informatica PC.