Online Training|Support Informatica

[training21]

Selfpacedtech is the best Online Training provider worldwide with real time experts :

Informatica Course Content :

Data Warehousing Concepts

• Dataware housing (what is Dataware housing /Why Dataware housing/How Dataware housing)
• Slowly Changing Dimensions (SCD1, SCD2, SCD3)
• Metadata
• Dimentinal Table
• Types Of Dim Tables
•  Fact Table
•  Types of Fact Tables
•  OLTP (OnLine Transaction Processing)
•  OLAP (Online Analysis And Processing)
•  OLTP Vs OLAP
•  Advantages of OLAP
•  Different Methodologies of DWH

PowerCenter Components and User Interface

• InformaticaPowerCenter Architecture
•  InformaticaPowerCenter Client Tools
•   Start Using of the Designer, Workflow Manager and Workflow Monitor

Source Qualifier

•  Source Qualifier Transformation
• SQL override in source qualifier transformation
• Source qualifier transformation joins concept
• Source qualifier transformation on Relational Databases
• Source qualifier transformation on File systems
• Source qualifier transformation filter concepts
• Difference Between SQL Override, Other Options
• Source Qualifier Transformation Performance Tunning
• Pre SQL and Post in Source Qualifier Transformation

 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 – Hands-On LAB

SCD type2 – Hands-On LAB

SCD type3 – Hands-On 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 Re-usability

•  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

Contact US : 309 - 200 - 3848 / 2019051656 / +91 9030990003