Informatica online training course

Page 1

Informatica Online Training: Attend a FREE DEMO Session! Career Opportunities for OPT/CPTs. BigClasses.com is providing an exclusive Informatica Online Training. A Job oriented Software Training by our Real Time Experts. You are welcome to attend our free demo classes for knowing more about the Informatica Training. BigClasses.com has more than 7 years of expertise in providing online IT training; we offer essential IT Fundamentals courses, through to more Advanced IT Programming Techniques, Graphics, Reporting and Statistics. All our courses are highly interactive and we actively encourage delegate participation. They are delivered by our own experts who are certified training team in small groups to ensure individual attention. We are dedicated to providing excellent quality and effective online Informatica 9.1 online training courses focused on improving IT business performance. Course Name: Informatica Online Training Course Duration: 30 Hours Informatica Online Training DATAWAREHOUSING CONCEPTS: INTRODUCTION TO DATAWAREHOUSING  Data Warehousing Concepts  Dataware housing (what/Why/How)  Data Modelling(Schemas, FACTS and DIMENSIONS)  Slowly Changing Dimensions  Metadata  PowerCenter Components and User Interface PowerCenter Architecture  PowerCenter Client Tools  Lab – Using the Designer and Workflow Manager  Source Qualifier Source Qualifier Transformation  Lab Project Overview  Lab A – Load Payment Staging Table  Source qualifier Joins  Lab B – Load Product Staging Table  Source Pipelines  Lab C – Load Dealership and Promotions Staging Table and Real time issues  Expression, Filter, File Lists and Workflow Scheduler Expression Editor  Filter Transformation  File Lists  Workflow Scheduler  Lab – Load the Customer Staging Table and Real time issues  Joins, Features and Techniques I


Joiner Transformation  Shortcuts  Lab A – Load Sales Transaction Staging Table  Lab B – Features and Techniques I and Real time issues  Lookups and Reusable Transformations Lookup Transformation  Reusable Transformations  Lab A – Load Employee Staging Table  Lab B – Load Date Staging Table and Real time issues  Debugger Debugging Mappings  Lab – Using the Debugger  Sequence Generator Sequence Generator Transformation  Lab – Load Date Dimension Table and Real time issues  Lookup Caching, More Features and Techniques Lookup Caching  Lab A – Load Promotions Dimension Table  Lab B – Features and Techniques II  Review and more Lab Activities and Real time issues  Router, update Strategy and Overrides Router Transformation  Update Strategy Transformation  Expression Default Values  Source Qualifier Override  Target Override  Session Task Mapping Overrides  Lab – Load Employee Dimension Table and Real time issues  Dynamic Lookup and Error Logging  Dynamic Lookup  Error Logging  Lab – Load Customer Dimension Table  Unconnected Lookup, Parameters and Variables Unconnected Lookup Transformation  System Variables  Mapping Parameters and Variables  Lab – Load Sales Fact Table  Sorter, Aggregator and Self-Join  Sorter Transformation  Aggregator Transformation  Active and Passive Transformations  Data Concatenation  Self-Join  Lab – Reload the Employee Staging Table and Real time issues


SCD type1 – LAB SCD type2 – LAB SCD type3 – LAB Mapplets  Mapplets  Lab – Load Product Daily Aggregate Table  Review and more Lab Activities and Real time issues  Workflow Variables and Tasks Link Conditions  Workflow Variables  Assignment Task  Decision Task  Email Task  Lab – Load Product Weekly Aggregate Table  More Tasks and Reusability  Event Raise Task  Event Wait Task  Command Task  Reusable Tasks  Reusable Session Task  Reusable Session Configuration Worklets and More Tasks Worklets  Timer Task  Control Task  Lab – Load Inventory Fact Table For more details about the course please visit: http://www.bigclasses.com/informatica-onlinetraining.html Informatica Demo

http://www.youtube.com/watch?v=uOo7LUySkt8

Informatica Demo

http://www.youtube.com/watch?v=dOwMZyLf9Ao

Informatica Demo

http://www.youtube.com/watch?v=1j1eXt2aJEE

Email ID: info@bigclasses.com BigClasses.com is an ISO certified online training company providing SAP BASIS Online Training by real time experts. A very good Job oriented SAP BASIS Training to you by the industry Expert. Smart way to learn on internet, Keywords:


Informatica online training, Informatica training, Informatica 9.1 Online training


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.