Informatica power center 8.x
Hello, We are from O2education, Online software Education and training team.
We are one of the best rated software training team, who are offering online software training from India.
We offer you efficient yet affordable online software training with quality as the main objective.
Our online education experts' team assists you in every phase of your online education.
We are the pioneers in offering practical industry-oriented online software training that makes you capable of handling real time situations by applying the concepts which you learn through our programming languages.
Initially, we make you understand about the software course contents and we will counsel you how the software course will be will be able to apply your practical skills in a real time environment.
for all major Software Technologies.
.
About our Faculty:
- We have Certified Instructors who have real time experience plus good orientation in Online Training.
We offer you:
- Interactive Learning at Learners convenience - Industry savvy Trainers - learn right from your place - 24/7 Technical Support - Highly affordable fee Satish@o2education.
com INFORMATICA POWER CENTER 8.
X Course Content:
Description:
Course Duration:
30 hours Prerequisites:
SQL Basics.
Software:
Informatica, Oracle, Toad Data Warehouse Concepts:
Introduction to Data warehouse What is Data warehouse and why we need Data warehouse OLTP vs ODS vs Data warehouse Dimensional modeling Star schema/Snowflake schema/Galaxy schema Dimensions / Facts tables.
Slowly Changing Dimensions and its types.
Data Staging Area Different types of Dimensions and Facts.
Data Mart vs Data warehouse DWH Approaches:
Ralph Kimball's vs Bill Inmon's Informatica Power Center 8.
x:
Software Installation:
Informatica 8.
x Server/Client Installation on Windows/Unix.
Power Center Architecture and Components:
Introduction to informatica Power Center PowerCenter 8.
x architecture PowerCenter 7 architecture vs PowerCenter 8 architecture Extraction, Transformation and loading process Power Center tools:
Designer, Workflow manager, Workflow Monitor, Repository Manager.
Repository Server and agent Repository maintenance Repository Server Administration Console Security, Repository, privileges and folder permissions Metadata extensions Power Center Developer Topics:
Lab 1- Create a Folder.
Source Object Definitions o Source types o Source properties Lab 2- Analyze Source Data, Import Source.
Target Object Definitions Target types Target properties Lab 3- Import Targets Transformation Concepts Transformation types and views Transformation features and ports Informatica functions and data types Source Qualifier transformation Pre SQL and Post SQL Data flow rules Workflows Workflow Tools Workflow Structure and configuration Workflow Tasks Workflow Design and properties Session Tasks Session Task properties Session components Session partitions Workflow Monitoring Workflow Monitor views Monitoring a Server Actions initiated from the workflow Monitor Gantt chart View and Task view.
Lab 6 Start and Monitor a Workflow Debugger Debugger features Debugger windows Tips for using the Debugger Lab 7 The Debugger Expression transformation Expression, variable ports, storing previous record values.
Different type of Ports Input/ output / Variable ports and Port Evaluation Filter transformation Filter properties Lab 8- Expression and Filter Aggregator transformation Aggregation function and expressions Aggregator properties Using sorted data Incremental Aggregation Joiner transformation Joiner types Joiner conditions and properties Joiner usage and Nested joins Lab 9 Aggregator, Heterogeneous join Working with Flat files Importing and editing flat file sources & Targets Lab Session - Use Flat file as source.
Sorter transformation Sorter properties Sorter limitations Lab 10 Sorter Propagate Attributes.
Shared Folder and Working with shortcuts.
Informatica built in functions.
Lookup transformation Lookup principles Lookup properties Lookup techniques Connected and unconnected lookups.
Lab 11 Basic Lookup Target options Row type indicators Row loading operations Constraint- based loading Rejected row handling options Lab 12 Deleting Rows Update Strategy transformation Update strategy expressions Lab 13 Data Driven Inserts and Rejects Router transformation Using a router Router groups Lab 14 Router Conditional Lookups Usage and techniques Advantage Functionality Lab 15 Straight Load Lab 16 Conditional Lookups Heterogeneous Targets Heterogeneous target types Target type conversions and limitations Lab 17 Heterogeneous Targets Functionality and Advantages Reusable transformations Advantages Limitations Promoting and copying transformations Lab 19 Reusable transformations Sequence Generator transformation Using a sequence Generator Sequence Generator properties Dynamic Lookup Dynamic lookup theory Usage and functionality Advantages Lab 20 Dynamic Lookup Concurrent and sequential Workflows Concurrent Workflows Sequential Workflows Stopping, Starting and suspending tasks and workflows Lab 21 Sequential Workflow Additional Transformations Union Transformation Rank transformation Normalizer transformation Custom Transformation Transformation Control transformation XML Transformation SQL Trasnformation Stored Procedure Transformation External procedure Transformation Lab Sessions- For above transformations Error Handling Overview of Error Handling Topics Lab 22 Error handling fatal and non Fatal Workflow Tasks:
Command Decision Timer Control Even Raise and Wait Lab Sessions With Workflow tasks Link Conditions Team Based Development Version Control Checking out and checking in objects.
Performance Tuning Overview of System Environment Creating Parameter File and associating file to a Session System Variables Variables functions Slowly Changing Dimensions Type 1, Type 2, Type 3 Lab 28 SCD 1, 2, 3 Reusable Workflow Tasks WorkLets Worklets Limitation Lab 29 Create Worklets using Tasks Command Line Interface ( PMCMD) Overview of PMCMD and functions.
Lab 30 :
PMCMD Informatica Migrations:
Copying Objects Objects export and import (XML) Deployment groups Workflows Scheduling:
Using Informatica Unix crontab, third party tools.
Lab 30:
Informatica Project- Case Study Sales Data mart.
Loading Dimensions and Facts.
.
Estimated Salary: $20 to $28 per hour based on qualifications.
We are one of the best rated software training team, who are offering online software training from India.
We offer you efficient yet affordable online software training with quality as the main objective.
Our online education experts' team assists you in every phase of your online education.
We are the pioneers in offering practical industry-oriented online software training that makes you capable of handling real time situations by applying the concepts which you learn through our programming languages.
Initially, we make you understand about the software course contents and we will counsel you how the software course will be will be able to apply your practical skills in a real time environment.
for all major Software Technologies.
.
About our Faculty:
- We have Certified Instructors who have real time experience plus good orientation in Online Training.
We offer you:
- Interactive Learning at Learners convenience - Industry savvy Trainers - learn right from your place - 24/7 Technical Support - Highly affordable fee Satish@o2education.
com INFORMATICA POWER CENTER 8.
X Course Content:
Description:
Course Duration:
30 hours Prerequisites:
SQL Basics.
Software:
Informatica, Oracle, Toad Data Warehouse Concepts:
Introduction to Data warehouse What is Data warehouse and why we need Data warehouse OLTP vs ODS vs Data warehouse Dimensional modeling Star schema/Snowflake schema/Galaxy schema Dimensions / Facts tables.
Slowly Changing Dimensions and its types.
Data Staging Area Different types of Dimensions and Facts.
Data Mart vs Data warehouse DWH Approaches:
Ralph Kimball's vs Bill Inmon's Informatica Power Center 8.
x:
Software Installation:
Informatica 8.
x Server/Client Installation on Windows/Unix.
Power Center Architecture and Components:
Introduction to informatica Power Center PowerCenter 8.
x architecture PowerCenter 7 architecture vs PowerCenter 8 architecture Extraction, Transformation and loading process Power Center tools:
Designer, Workflow manager, Workflow Monitor, Repository Manager.
Repository Server and agent Repository maintenance Repository Server Administration Console Security, Repository, privileges and folder permissions Metadata extensions Power Center Developer Topics:
Lab 1- Create a Folder.
Source Object Definitions o Source types o Source properties Lab 2- Analyze Source Data, Import Source.
Target Object Definitions Target types Target properties Lab 3- Import Targets Transformation Concepts Transformation types and views Transformation features and ports Informatica functions and data types Source Qualifier transformation Pre SQL and Post SQL Data flow rules Workflows Workflow Tools Workflow Structure and configuration Workflow Tasks Workflow Design and properties Session Tasks Session Task properties Session components Session partitions Workflow Monitoring Workflow Monitor views Monitoring a Server Actions initiated from the workflow Monitor Gantt chart View and Task view.
Lab 6 Start and Monitor a Workflow Debugger Debugger features Debugger windows Tips for using the Debugger Lab 7 The Debugger Expression transformation Expression, variable ports, storing previous record values.
Different type of Ports Input/ output / Variable ports and Port Evaluation Filter transformation Filter properties Lab 8- Expression and Filter Aggregator transformation Aggregation function and expressions Aggregator properties Using sorted data Incremental Aggregation Joiner transformation Joiner types Joiner conditions and properties Joiner usage and Nested joins Lab 9 Aggregator, Heterogeneous join Working with Flat files Importing and editing flat file sources & Targets Lab Session - Use Flat file as source.
Sorter transformation Sorter properties Sorter limitations Lab 10 Sorter Propagate Attributes.
Shared Folder and Working with shortcuts.
Informatica built in functions.
Lookup transformation Lookup principles Lookup properties Lookup techniques Connected and unconnected lookups.
Lab 11 Basic Lookup Target options Row type indicators Row loading operations Constraint- based loading Rejected row handling options Lab 12 Deleting Rows Update Strategy transformation Update strategy expressions Lab 13 Data Driven Inserts and Rejects Router transformation Using a router Router groups Lab 14 Router Conditional Lookups Usage and techniques Advantage Functionality Lab 15 Straight Load Lab 16 Conditional Lookups Heterogeneous Targets Heterogeneous target types Target type conversions and limitations Lab 17 Heterogeneous Targets Functionality and Advantages Reusable transformations Advantages Limitations Promoting and copying transformations Lab 19 Reusable transformations Sequence Generator transformation Using a sequence Generator Sequence Generator properties Dynamic Lookup Dynamic lookup theory Usage and functionality Advantages Lab 20 Dynamic Lookup Concurrent and sequential Workflows Concurrent Workflows Sequential Workflows Stopping, Starting and suspending tasks and workflows Lab 21 Sequential Workflow Additional Transformations Union Transformation Rank transformation Normalizer transformation Custom Transformation Transformation Control transformation XML Transformation SQL Trasnformation Stored Procedure Transformation External procedure Transformation Lab Sessions- For above transformations Error Handling Overview of Error Handling Topics Lab 22 Error handling fatal and non Fatal Workflow Tasks:
Command Decision Timer Control Even Raise and Wait Lab Sessions With Workflow tasks Link Conditions Team Based Development Version Control Checking out and checking in objects.
Performance Tuning Overview of System Environment Creating Parameter File and associating file to a Session System Variables Variables functions Slowly Changing Dimensions Type 1, Type 2, Type 3 Lab 28 SCD 1, 2, 3 Reusable Workflow Tasks WorkLets Worklets Limitation Lab 29 Create Worklets using Tasks Command Line Interface ( PMCMD) Overview of PMCMD and functions.
Lab 30 :
PMCMD Informatica Migrations:
Copying Objects Objects export and import (XML) Deployment groups Workflows Scheduling:
Using Informatica Unix crontab, third party tools.
Lab 30:
Informatica Project- Case Study Sales Data mart.
Loading Dimensions and Facts.
.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
