Category: INFORMATICA

Informatica Training

Informatica Training
About Proerp Academy
Proerp Academy is a leading E-Learning Platform both Online and Instructor-led training(Offline).We have trained the students and professionals across the globe in different technologies like Business Intelligence and Analytics,Big Data Analytics, Data Science Analytics.
We have efficient and affordable learning solutions that is accessible to the millions of interested students and professionals across the globe.
About the Course:
Proerp Academy’s Informatica Online and Offline training will train the Students and Professionals how to use and administer the tools effectively and efficiently.
This Informatica training also helps the Students and Professionals to upgrade the skills to the latest version.
This Course provides the skills and knowledge of experienced PowerCenter developers and administrators.
This Course will provide you the necessary skills to implement the services on this Platform.
The Course provides you the overview of Informatical PowerCenter Product and its installation,the data warehousing concepts and data integration concepts.
Training Objectives:
 Explain Data Integration Concepts
 Informatica PowerCenter architecture Concepts
 Different Transformations and usage
 Repository manager tool Explanation
 Reusability and Scheduling in Workflow Manager Concepts
 PowerCenter Environment Monitoring
 Design Principles and best practices Concepts
 Advanced Transformations
 Informatica Administrator tool Configuration
 Error handling strategies
 Performance of mapping design and effect
 Creating users and groups
 PowerCenter application services
 Implementation techniques for dimensional table loading
 Connection errors and Network errors –Recognize and Repair
 Configuration of Workflow and recovery of sessions
 Performance Tuning Methodology
 PowerCenter repository maintainance
 Integration and repository services
Module 1
Basics and Overview -Informatica PowerCenter 10
Goal:
In this module,we will discuss about various Informatica Products that are available in the market along with clear understanding of the overview of InformaticaPowerCenter Product,Terminology,Mappings,Transformations,Architecture,Workflows and Workflow Monitor,Sessions.
Objective:
After completing this module 1,you should be able to:
 Understand and Explain the purpose of PowerCenter as ETL Tool
 Understand and Explain Informatica and Informatica Product Suite
 Understand and Describe PowerCenter Architecture
 Explain PowerCenter development techniques
 Explain advanced features of Informatica 10.X over 9.X
Topics:
 Informatica and Informatica Product Suite
 PowerCenter Architecture
 PowerCenter as ETL Tool
 Development techniques based on component
Hands on:
 Creation of the services and connecting the client and the server
 Installation of the Product in Windows and using Oracle as Database

Module 2
Data Warehousing Fundamentals and Data Integration Concepts
Goal:
In this module,we will discuss about various Data Integration Concepts.You will be learning the concepts such as Data Profiling,Data Warehousing,ETL and ETL architecture,Data Quality Management.
Objective:
After completing this module 2,you should be able to:
 Understand Data Profile and Data Qualtiy
 Understand and Explain Data Integration Concepts
 Understand and Describe ETL Architecture and Process flow
 Describe different ETL methods and Tools
 Describe Data Warehouse Concepts and Architecture
Topics:
 ETL and ETL Architecture
 Data Warehousing Concepts
 Data Integration concepts
 Data Profile
 Data Quality Management
Hands on:
 Administration Console shutdown services
 Administration Console start-up services
 Creation and Execution of a simple pass using mapping
 Informatica services properties
Module 3
Informatica PowerCenter -Important Transformations
Goal:
In this module,you will learn about different PowerCenter development units and how development units can be used for creating a simple mapping
Objective:
After completing this module 3,you should be able to:
 Understand and Describe the basics of Data Flow
 Explain how to create and Execute mapping
 Explain and Understand different Transformations and usage
 Describe PowerCenter client tools
Topics:
 Data Flow
 PowerCenter client Tools
 Transformations and usage
 Create and execute mapping
Hands on:
 Use multiple transformations inside the mapping
 Resolve different use cases
 Properties of Transformations
Module 4
Informatica PowerCenter -Workflows and Tasks
Goal:
In this module,you will learn about Informatica PowerCenter development units(workflow manager and monitor) and also how they are utilized to create different tasks and workflow
Objective:
After completing this module 4,you should be able to:
 Describe and Understand Flow within a workflow
 Describe and Understand components of Workflow Monitor
 Explain PowerCenter Workflow Manager
 Understand and Explain Workflow Task and job handling
 Explain and Understand Reusability and Scheduling in Workflow Manager
Topics:
 PowerCenter Workflow Manager Concepts
 Reusability and Scheduling in Workflow Manager
 Flow within a Workflow
 Components of Workflow Monitor
 Workflow Task and job handling
Hands on:
 Creating tasks
 Creating workflow
 Configuring workflow properties
 Scheduling a workflow
Module 5
Informatica PowerCenter-Advanced Transformations,Techniques and Reusability Features
Goal:
In this module,you will learn about Advanced Transformation techniques that will make you to deal with advanced concepts of PowerCenter transformations such as Java,XML of PowerCenter
Objective:
After completing this module 5,you should be able to:
 Understand and Explain the XML File Processing and Transaction Processing
 Understand and Describe the uses of advanced transformations such as Java,SQL and Normalizer
 Understand and Explain the use of different error handling features
 Understand and Explain the use of Advanced Functions,Regular Expressions to cleanse the data
 Understand about the reusability features
Topics:
 XML File Processing
 Transaction Processing
 Advanced transformations(Java,SQL,Normalizer)
 Error handling features
 Cleaning the data using Advanced functions
 Cleaning the data using Regular Expressions
 Reusability features
Hands on:
 Reusable transformations,Sessions and Mapplets
 Use of Advanced transformations such as XML Processing,Union
 Connect to Power BI Data in Excel
 Use of In-built functions
 Use of Custom functions
 Pin a range to a Dashboard
Module 6
Informatica PowerCenter and ETL Scenarios
Goal:
In this module,we will discuss about advanced ETL scenarios using informatica.you will learn about Error Handling,PushDown Optimization,Partitioning,Constraint Based Loading,Target Load Order Group,CDC(Change Data Capture),Incremental Aggregation
Objective:
After completing this module 6,you should be able to:
 Understand and Implement advanced techniques using Flat File and XML File
 Understand and Implement other advanced concepts using Informatica PowerCenter
 Understand and Implement advanced concepts like Changed Data Capture,Incremental Aggregation,Constraint Based Loading
 Understand and Implement techniques for loading Dimensional Tables(SCD_1,SCD_2,SCD_3)
Topics:
 Advanced techniques-Flat File and XML File
 Loading of Dimensional Tables(SCD_1,SCD_2,SCD_3)
 Changed Data Capture
 Constraint Based Loading
 Incremental Aggregation
Hands on:
 Advanced techniques-Flat File and XML File
 Changed Data Capture
 Incremental Aggregation
 Constraint Based Loading
 Loading of Dimensional Tables(SCD_1,SCD_2,SCD_3)

Module 7
Informatica PowerCenter Environment-Service and Support
Goal:
In this module,we will discuss about Debugging,Troubleshooting and handling errors.You will learn about Different PowerCenter recovery options for tasks and workflows
Objective:
After completing this module 7,you should be able to:
 Understand and Use Workflow and Session logs to diagnose errors
 Understand and Use the Debugger
 Describe PowerCenter Errors
 Use of Troubleshooting Methodology
 Understand the recovery scenarios and mechanisms
 Monitor the PowerCenter Environment effectively
 Recognize and Repair Connection Errors
 Recognize and Repair Network Errors
 Configure Workflow and Sessions for recovery
Topics:
 Debugger
 Connection Errors and Network Errors
 Basic Troubleshooting Methodology
 Recovery Scenarios and Mechanisms
 PowerCenter Environment
 High Availability
 PowerCenter Error
 Workflow and Session logs to diagnose errors
 Configure workflow and sessions for recovery
Hands on:
 Use of Debugger to debug a mapping
 Perform Workflow and Session recovery
 Perform Troubleshooting of Informatica errors

Module 8
Informatica PowerCenter-Performance Tuning
Goal:
In this module,we will discuss about the performance aspects of Informatica PowerCenter components
Objective:
After completing this module 8,you should be able to:
 Understand and Learn Mapping design techniques
 Understand the Performance Tuning Methodology
 Understand and Explain Design principles and Best practices
 Understand about Partition and pushdown optimization
 Understand about Caching and Memory Optimization
Topics:
 Mapping Design Techniques
 Design Principles and Best Practices
 Performance Tuning Methodology
 Partition and Pushdown Optimization
 Caching and Memory Optimization
Hands on:
 Learn tips and tricks to code Informatica Mappings
 Identify the Issues
 Cache and DTM buffer memory Configuration
 Various Configurations required to resolve the Issues
Module 9
Informatica PowerCenter -Repository Management
Goal:
In this module,we will discuss about the usage and components of PowerCenter repository manager
Objective:
After completing this module 9,you should be able to:
 Understand ,Recognize and Explain the functionalities of the Repository Manager Tool
 Understand and Learn PowerCenter Repository Maintainance
 Understand and Describe how to create and delete folders using the Repository Management Tool
 Understand and Explain how to migrate components using Repostory Maintainance
Topics:
 PowerCenter Repository Maintainance
 Repository Management Tool-Functionalities
 Create,Delete,Migrate Components using Repository Management Tool
Hands on:
 Copy Informatica Objects
 Creation and Editing of a Folder using Repository Management Tool
 Knowledge about Repository Manager Tool and its functionalities
 Historical View of Sessions
 Workflow statistics
Module 10
Informatica PowerCenter-Administration and Security
Goal:
In this module,we will discuss about the PowerCenter administration console,integration and repository service properties.You will also learn about the command line utilities.
Objective:
After completing this module 10,you should be able to:
 Understand and Recognize the integration and repository service properties
 Understand and Explain the new features of PowerCenter 10
 Understand and Explain how to handle locks through the Administration Console
 Understand and Explain how to handle services in the Administration Console
 Illustrate how to create users and groups
 Explain about the PowerCenter Administration Console
Topics:
 Integration and Repository Service properties
 Users and groups
 PowerCenter Administration Console-Overview
 Feautures and Advantages of Informatica PowerCenter 10
 Services in the Informatica PowerCenter Administration Console such as Services and handle locks
Hands on:
 Service maintenance from Administration Console
 Learn and Understand the details of Various components of Informatica Administration Tool
 Create Users
 Create Groups
 Assign Privileges to the users
 Assign Privileges to Groups
 Create Roles
 Looking at the service logs
Module 11
Informatica PowerCenter-Command Line Utilities
Goal:
In this module,we will discuss about the command line utilities of the Informatica PowerCenter.
Objective:
After completing this module 11,you should be able to:
 Understand and Apply pmcmd to execute and control workflows
 Understand and Apply infacmd to domain objects and security
 Understand and Apply infasetup to domain objects
 Understand and Apply pmrep to manage the PowerCenter Repository
 Explain Automate tasks via Command line Programs
Topics:
 Automate tasks using command-line programs
 Infacmd,Infasetup,pmcmd,pmrep
Hands on:
 Usage of Infacmd,Infasetup,pmcmd,pmrep to automate tasks using command-line programs

Module 12
Informatica PowerCenter 10- Technical Architecture
Goal:
In this module,we will discuss about the Technical Architecture of Informatica PowerCenter 10.
Objective:
After completing this module 12,you should be able to:
 Understand and Explain Buffer memory
 Understand and Describe Connectivity
 Describe about connection pooling used in Informatica PowerCenter
 Describe about Informatica PowerCenter 10 technical Architecture
 Understand and Explain about the Informatica PowerCenter Application Services and processes
Topics:
 Buffer Memory
 Connection Pooling
 Application Services
 Informatica 10 Technical Architecture
 Application Services
Hands on:
 Learn about the Technical Architecture of Informatica PowerCenter 10 and its Application Services