Online Training |Training| Support- 3092003848

[Davidjhon]

We Provide Online Training |Training| on   Informatica Course Contents  with Real Time Experts

Course Outline:

Informatica Course Contents

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

 

 

You can reach us @   3092003878 or Email us: [email protected]