informatica power center 9 online training
TRANSCRIPT
1. INFORMATICA POWER CENTER 9.X -
AN OVERVIEW
Learning Objectives -
In this, you will understand overview of
Power Center covering areas such as the
Architecture, Terminology, Tools GUI,
Mappings, Transformations, Sessions,
Workflows and Workflow Monitor.
1. INFORMATICA POWER CENTER 9.X -
AN OVERVIEW
Topics -
Identify different Informatica Products,
Describe Power Center as a tool to perform
Extract transform and load, Interpret Power
Center Architecture, its different components
and their functionalities, Explain the
advantages of component based
development techniques in Power Center.
2. ETL FUNDAMENTALS
Learning Objectives -
In this module, you will learn about the ETL
and the need behind it.
You will also learn how to use Informatica
Power Center tools to create simple ETL
jobs.
2. ETL FUNDAMENTALS
Topics -
ETL and ETL Architecture, Flat file andrelational Sources using the SourceAnalyzer, Flat file and relational Targets usingthe Target Developer, Mappings using theMapping Designer, Workflows using theWorkflow Designer, Monitor the workflowusing the Workflow Monitor, Preview TargetData using the Power Center Designer.
3. INFORMATICA POWER CENTER DESIGNER
Learning Objectives -
In this module, you will learn about different development units of Power Center and how they can be used to create a simple mapping.
Topics -
Describe & Visualize Power CenterDesigner, Explain how to create mappingin Designer, Explain differentTransformations & their usage.
4. INFORMATICA POWER CENTER WORKFLOW
MANAGER & MONITOR
Learning Objectives -
In this module, you will learn about two more
development units of Informatica Power
Center namely Workflow manager & monitor
and how are they used to create different
tasks and workflow.
4. INFORMATICA POWER CENTER WORKFLOW
MANAGER & MONITOR
Topics -
Understand Power Center 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.
5. ADVANCED TRANSFORMATION TECHNIQUES
Learning Objectives -
In this module, you will understand Advanced
Transformation techniques that will equip you
to deal with advanced concepts of Power
Center transformations like, Java, XML etc
as well as the re-usability features of Power
Center.
5. ADVANCED TRANSFORMATION TECHNIQUES
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.
6. PARAMETERS & VARIABLES
Learning Objectives -
In this module, you will learn that parameters and variables are a way to achieve re-usability from Power Center.
This module will deal with the scope and use of Parameters & Variables.
Topics -
Understand different Parameters andVariables used in Power Center, DescribeMapping Parameter & Variables, Learn to useSession Parameters, Learn to use WorkflowVariables.
7. DEBUGGING TROUBLESHOOTING ERROR
HANDLING & RECOVERY
Learning Objectives -
In this module, you will understand the
operational part of the Power Center.
This module will help you understand the
features provided by Informatica to debug,
troubleshoot & handle errors.
The concepts of recovery will also be
discussed.
7. DEBUGGING TROUBLESHOOTING ERROR
HANDLING & RECOVERY
Topics - Describe basic Power Center Error, Follow a basic
troubleshooting methodology, Using the debugger,Use Workflow and Session logs to diagnose errors,Recognize & repair, Connection Errors & Networkerrors.
Design Error Handling Strategies for intendedpurpose, Understand the recovery scenarios &mechanisms, Properly Configure Workflow &sessions for recovery, Understand the purpose ofHigh Availability, Monitoring the Power CenterEnvironment.
8. CACHES
Learning Objectives -o Caches play important part of any
application.
o This module will help you understand theimplementation of Cache by Informatica andhow can they be used to accomplishperformance efficient ETL jobs.
o The pros & cons will be covered.
Topics - Understand the session cache, Describe
when and why cache is created, Implementsession cache, Learn to calculate cacherequirement.
9. PERFORMANCE TUNING & OPTIMIZATION
Learning Objectives -
The most important concept for any
application.
Superior performance wins the race
everywhere.
This module will enlighten the performance
aspects of Informatica Power Center
components and the efficient usage of them.
9. PERFORMANCE TUNING & OPTIMIZATION
Topics -
Control how Power Center uses memory,
Control how Power Center uses CPUs,
Understand the performance counters,
Isolate source, target and engine
bottlenecks, Tune different types of
bottlenecks, Configure Workflow and Session
on Grid.
10. POWER CENTER REPOSITORY MANAGER
Learning Objectives -o More of a Administrators job.
o This module will tell you about the usage andcomponents of Power Center RepositoryManager.
Topics - Recognize and explain the functionalities of
the Repository Manager tool, Describe howto create and delete folders using theRepository Manager tool, Illustrate how tomigrate components using RepositoryManager tool.
11. INFORMATICA ADMINISTRATION CONSOLE &
SECURITY
Learning Objectives - At the completion of this module, you should be
able to Put in your own words.
An overview of the Power Center AdministrationConsole, Recognize and explain integration andrepository service properties.
Identify how to handle services In theAdministration Console, Explain how to handlelocks through the Administration Console, andIllustrate how to create users and groups.
11. INFORMATICA ADMINISTRATION CONSOLE &
SECURITY
Topics -
Put in your own words an overview of thePower Center Administration Console,Recognize.
Explain the integration and repository serviceproperties, Identify how to handle services inthe Administration Console, Explain how tohandle locks through the AdministrationConsole, Illustrate how to create users andgroups.
12. INFORMATICA 9.X - TECHNICAL
ARCHITECTURE
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 Power Center in
particular.
12. INFORMATICA 9.X - TECHNICAL
ARCHITECTURE
Topics -
Understand Informatica 9.X Architecture,
Describe the Application services related to
Power Center and their related processes,
Understand buffer memory, Describe
Connectivity among the tolls, Describe
Connection pooling used in Power Center.
13. INFORMATICA INSTALLATION &
CONFIGURATION
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.
13. INFORMATICA INSTALLATION &
CONFIGURATION
Topics -
Step by step installation process,
Configuration of different Informatica PC
components and their set up, Backup and
recovery, Operational procedures.
14. COMMAND LINE UTILITIES
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
Topics -
Informatica frequently used commands, pmrep, pmcmd, infacmd, infasetup.
15. ETL SCENARIOS USING INFORMATICA
Learning Objectives - This module will deal with different day to day
ETL scenarios and their implementation inInformatica PC.
Topics - SCD, XML Processing, Flat file handling,
Different Transformations, For loopimplementations in PC, Partitioning, Pushdownoptimization, Constraint based loading,Incremental Aggregation.
16. BEST PRACTICES & METHODOLOGIES
Learning Objectives - The excerpt from best practices, developed
from the real-world experience of several datamanagement projects, will help you understandthe efficient way of using different InformaticaPC components effectively and efficiently.
Topics -o ETL best practices using Informatica,
Development Techniques, Error Handling, DataMigration, Performance Tuning.
CONTACT US FOR FREE DEMO
We stay with you until you get the results you want.
If you really interested, please let me know .
We will arrange the Demo Session.
Feel Free to call us any time
Thanks & RegardsSrinivasGloryITTechnologiesEmail:[email protected]:+91-9032813456/+91-9160177789Skype ID : gloryittechnologies