Informatica Online Training @ Lowest Fee With High Course Curriculum

[Roshani2012]

[color=#000000]
Dear Students[/color]
[color=#000000]
I am providing Informatica Online Training @ lowest fee. Contact at [email protected] for further details.[/color]
[color=#000000]
Here is the course curriculum :[/color]
[color=#000000]
INFORMATICA POWER CENTER 9 Course Content:[/color]
[color=#000000]
The Course teaches the fundamentals of Informatica Power center 9 platforms, through online training and numerous hands-on lab exercises. Students will gain a clear understanding of the product and acquire the solid foundation needed to make them successful Power center developers. Providing Training Material Support PPT s & Pdf Docs and Softwares.[/color]
[color=#000000]
Data Warehouse Concepts:[/color]
[color=#000000]
Introduction to Data warehouse[/color][color=#000000]
What is Data warehouse and why we need Data warehouse[/color][color=#000000]
OLTP vs ODS vs Data warehouse[/color][color=#000000]
Dimensional modeling[/color][color=#000000]
Star schema/Snowflake schema/Galaxy schema[/color][color=#000000]
Dimensions / Facts tables.[/color][color=#000000]
Slowly Changing Dimensions and its types.[/color][color=#000000]
Data Staging Area[/color][color=#000000]
Different types of Dimensions and Facts.[/color][color=#000000]
Data Mart vs Data warehouse[/color][color=#000000]
DWH Approaches: Ralph Kimball’s vs Bill Inmon’s[/color]
[color=#000000]
Informatica Power Center 9:[/color][color=#000000]
Software Installation:[/color][color=#000000]
Informatica 9 Server/Client Installation on Windows/Unix.[/color][color=#000000]
Power Center Architecture and Components:[/color]
[color=#000000]
Introduction to informatica Power Center[/color][color=#000000]
Difference Between Power Center and Power Mart[/color][color=#000000]
PowerCenter 9 architecture[/color][color=#000000]
PowerCenter 7 architecture vs PowerCenter 8 and 9 architecture[/color][color=#000000]
Extraction, Transformation and loading process[/color][color=#000000]
Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager, Informatica Adminstration Console.[/color][color=#000000]
Repository Server and agent[/color][color=#000000]
Repository maintenance[/color][color=#000000]
Repository Server Administration Console[/color][color=#000000]
Security, Repository, privileges and folder permissions[/color][color=#000000]
Metadata extensions[/color]
[color=#000000]
Power Center Developer Topics:[/color][color=#000000]
Lab 1- Create a Folder.[/color][color=#000000]
How to provide Previllages[/color][color=#000000]
Source Object Definitions[/color]
[color=#000000]
Source types[/color]
[color=#000000]
Relational Tables (Oracle, Teradata)[/color][color=#000000]
Flat Files (fixe width, Delimiter Files)[/color][color=#000000]
Xml Files[/color]
[color=#000000]
Source properties[/color]
[color=#000000]
Lab 2- Analyze Source Data, Import Source.[/color][color=#000000]
Target Object Definitions[/color]
[color=#000000]
Target types[/color][color=#000000]
Target properties[/color]
[color=#000000]
Lab 3- Import Targets[/color][color=#000000]
Transformation Concepts[/color]
[color=#000000]
Transformation types and views[/color][color=#000000]
Transformation features and ports[/color][color=#000000]
Informatica functions and data types[/color]
[color=#000000]
Mappings[/color]
[color=#000000]
Mapping components[/color][color=#000000]
Source Qualifier transformation[/color][color=#000000]
Pre SQL and Post SQL[/color][color=#000000]
Mapping validation[/color][color=#000000]
Data flow rules[/color]
[color=#000000]
Lab 4 –Create a Mapping, session, and workflow[/color][color=#000000]
Workflows[/color]
[color=#000000]
Workflow Tools[/color][color=#000000]
Workflow Structure and configuration[/color][color=#000000]
Workflow Tasks[/color][color=#000000]
Workflow Design and properties[/color]
[color=#000000]
Session Tasks[/color]
[color=#000000]
Session Task properties[/color][color=#000000]
Session components[/color][color=#000000]
Transformation overrides[/color][color=#000000]
Session partitions[/color]
[color=#000000]
Workflow Monitoring[/color]
[color=#000000]
Workflow Monitor views[/color][color=#000000]
Monitoring a Server[/color][color=#000000]
Actions initiated from the workflow Monitor[/color][color=#000000]
Gantt chart View and Task view.[/color]
[color=#000000]
Lab 6 – Start and Monitor a Workflow[/color][color=#000000]
Debugger[/color]
[color=#000000]
Debugger features[/color][color=#000000]
Debugger windows[/color][color=#000000]
Tips for using the Debugger[/color]
[color=#000000]
Lab 7 –The Debugger[/color][color=#000000]
Expression transformation[/color]
[color=#000000]
Expression, variable ports, storing previous record values.[/color]
[color=#000000]
Different type of Ports[/color][color=#000000]
Input/ output / Variable ports and Port Evaluation[/color][color=#000000]
Filter transformation[/color]
[color=#000000]
Filter properties[/color]
[color=#000000]
Lab 8- Expression and Filter[/color][color=#000000]
Aggregator transformation[/color]
[color=#000000]
Aggregation function and expressions[/color][color=#000000]
Aggregator properties[/color][color=#000000]
Using sorted data[/color][color=#000000]
Incremental Aggregation[/color]
[color=#000000]
Joiner transformation[/color]
[color=#000000]
Joiner types[/color][color=#000000]
Joiner conditions and properties[/color][color=#000000]
Joiner usage and Nested joins[/color]
[color=#000000]
Lab 9 – Aggregator, Heterogeneous join[/color][color=#000000]
Working with Flat files[/color][color=#000000]
Importing and editing flat file sources & Targets[/color][color=#000000]
Lab Session – Use Flat file as source.[/color][color=#000000]
Sorter transformation[/color]
[color=#000000]
Sorter properties[/color][color=#000000]
Sorter limitations[/color]
[color=#000000]
Lab 10 – Sorter[/color]
[color=#000000]
Propagate Attributes.[/color][color=#000000]
Shared Folder and Working with shortcuts.[/color][color=#000000]
Informatica built in functions.[/color]
[color=#000000]
Lookup transformation[/color]
[color=#000000]
Lookup principles[/color][color=#000000]
Lookup properties[/color][color=#000000]
Lookup techniques[/color][color=#000000]
Connected and unconnected lookups.[/color][color=#000000]
Lookup Caches[/color]
[color=#000000]
Lab 11 – Basic and Advance Lookup[/color][color=#000000]
Target options[/color]
[color=#000000]
Row type indicators[/color][color=#000000]
Row loading operations[/color][color=#000000]
Constraint- based loading[/color][color=#000000]
Rejected row handling options[/color]
[color=#000000]
Lab 12 – Deleting Rows[/color][color=#000000]
Update Strategy transformation[/color][color=#000000]
Update strategy expressions[/color][color=#000000]
Lab 13 – Data Driven Inserts and Rejects[/color][color=#000000]
Router transformation[/color]
[color=#000000]
Using a router[/color][color=#000000]
Router groups[/color]
[color=#000000]
Lab 14 – Router[/color][color=#000000]
Conditional Lookups[/color]
[color=#000000]
Usage and techniques[/color][color=#000000]
Advantage[/color][color=#000000]
Functionality[/color]
[color=#000000]
Lab 15 – Straight Load[/color][color=#000000]
Lab 16 – Conditional Lookups[/color][color=#000000]
Heterogeneous Targets[/color]
[color=#000000]
Heterogeneous target types[/color][color=#000000]
Target type conversions and limitations[/color]
[color=#000000]
Lab 17 – Heterogeneous Targets[/color][color=#000000]
Mapplets[/color]
[color=#000000]
Functionality and Advantages[/color][color=#000000]
Mapplet types and structure[/color][color=#000000]
Mapplet limitations[/color]
[color=#000000]
Lab 18 – Mapplets[/color][color=#000000]
Reusable transformations[/color]
[color=#000000]
Advantages[/color][color=#000000]
Limitations[/color][color=#000000]
Promoting and copying transformations[/color]
[color=#000000]
Lab 19 – Reusable transformations[/color][color=#000000]
Sequence Generator transformation[/color]
[color=#000000]
Using a sequence Generator[/color][color=#000000]
Sequence Generator properties[/color]
[color=#000000]
Dynamic Lookup[/color]
[color=#000000]
Dynamic lookup theory[/color][color=#000000]
Usage and functionality[/color][color=#000000]
Advantages[/color]
[color=#000000]
Lab 20 – Dynamic Lookup[/color][color=#000000]
Concurrent and sequential Workflows[/color]
[color=#000000]
Concurrent Workflows[/color][color=#000000]
Sequential Workflows[/color][color=#000000]
Stopping, Starting and suspending tasks and workflows[/color]
[color=#000000]
Lab 21 – Sequential Workflow[/color][color=#000000]
Additional Transformations[/color]
[color=#000000]
Union Transformation[/color][color=#000000]
Rank transformation[/color][color=#000000]
Normalizer transformation[/color][color=#000000]
Custom Transformation[/color][color=#000000]
Transformation Control transformation[/color][color=#000000]
XML Transformation[/color][color=#000000]
SQL Trasnformation[/color][color=#000000]
Stored Procedure Transformation[/color][color=#000000]
External procedure Transformation[/color][color=#000000]
SQL Transformation[/color]
[color=#000000]
Lab Sessions- For above transformations[/color][color=#000000]
Error Handling[/color][color=#000000]
• Overview of Error Handling Topics[/color][color=#000000]
Lab 22 – Error handling fatal and non Fatal[/color][color=#000000]
Workflow Tasks:[/color]
[color=#000000]
Command[/color][color=#000000]
Email[/color][color=#000000]
Decision[/color][color=#000000]
Timer[/color][color=#000000]
Control[/color][color=#000000]
Even Raise and Wait[/color][color=#000000]
Sequential Batch Processing[/color][color=#000000]
Parllel Batch Processing[/color]
[color=#000000]
Lab Sessions – With Workflow tasks[/color][color=#000000]
Link Conditions[/color][color=#000000]
Team Based Development[/color]
[color=#000000]
Version Control[/color][color=#000000]
Checking out and checking in objects.[/color]
[color=#000000]
Performance Tuning[/color]
[color=#000000]
Overview of System Environment[/color][color=#000000]
Identifying Bottlenecks.[/color][color=#000000]
Optimizing Source, Target, mapping, Transformation, session.[/color]
[color=#000000]
Mapping Parameters and Variables[/color]
[color=#000000]
Introduction to Mappng Variables and Parameters[/color][color=#000000]
Creating Mapping Variables and Updating Variables[/color][color=#000000]
Creating Parameter File and associating file to a Session[/color][color=#000000]
System Variables[/color][color=#000000]
Variables functions[/color]
[color=#000000]
Lab 26 - Override Mapping Variable with Parameter Files[/color][color=#000000]
Lab 27 – Dynamically Updating a Source Qualifier with Mapping Variable[/color][color=#000000]
Slowly Changing Dimensions Type 1, Type 2, Type 3[/color][color=#000000]
Incremental Loading[/color][color=#000000]
Lab 28– SCD 1, 2, 3[/color][color=#000000]
Reusable Workflow Tasks[/color]
[color=#000000]
WorkLets[/color][color=#000000]
Worklets Limitation[/color][color=#000000]
Sessions[/color][color=#000000]
Reusable Sessions[/color]
[color=#000000]
Lab 29 – Create Worklets using Tasks[/color][color=#000000]
Command Line Interface ( PMCMD)[/color]
[color=#000000]
Overview of PMCMD and functions.[/color][color=#000000]
Overview of PMREP and functions.[/color]
[color=#000000]
Lab 30 : PMCMD[/color][color=#000000]
PMREP[/color][color=#000000]
Informatica Migrations:[/color]
[color=#000000]
Copying Objects[/color][color=#000000]
Objects export and import (XML)[/color][color=#000000]
Deployment groups[/color]
[color=#000000]
Workflows Scheduling:[/color]
[color=#000000]
Using Informatica[/color][color=#000000]
Unix crontab, third party tools.[/color]
[color=#000000]
Lab 30: Informatica Project- Case Study[/color]
[color=#000000]
Sales Data mart.[/color][color=#000000]
Loading Dimensions and Facts.[/color]
[color=#000000]
ETL Best Practices and methodologies[/color]
[color=#000000]
Review the Industry best practices in ETL Development[/color][color=#000000]
Review Real time project experiences of trainer[/color][color=#000000]
Discuss what is learned techniques are useful in real world[/color][color=#000000]
How to design effective ETL process[/color][color=#000000]
Important considerations in designing ETL process[/color][color=#000000]
Discuss real world prouction issues and support[/color][color=#000000]
Discuss various roles in ETL world[/color][color=#000000]
Busines Analyst, System Analyst[/color][color=#000000]
System Architect[/color][color=#000000]
Technical Architect, ETL Lead[/color][color=#000000]
Stakeholders, Busines users[/color][color=#000000]
Effective ways of using Data warehouse[/color][color=#000000]
Review various BI Reporting methods[/color]
[color=#000000]
Q/A-Inteview perparation/Placements[/color]
[color=#000000]
Answer students questions[/color][color=#000000]
Tips for interview preparation[/color][color=#000000]
How we can assist in placement and future growth[/color][color=#000000]
Discuss other realted technologies like Business Intelligence(BI)[/color][color=#000000]
Advacing career options[/color]
[color=#000000]
Kind Regards[/color][color=#000000]
Ph : +91-9660567626(M)[/color][color=#000000]
Email : [email protected] [/color]