Course Duration in Hours
200
Course Category
Request Call Back
Course Details
INFORMATICA SYLLABUS
DATA WAREHOUSING CONCEPTS:
Introduction, Definition.
Sources, Transformations and Targets (Architecture).
Data Extraction, Data Transformation and Data Loading(Data Acquisition Process)
Data Warehousing Approaches.
Staging Area, Metadata, Repository and Data Mart.
Differences between OLTP and OLAP (DSS) Systems.
Operational Data Source (ODS).
Business Intelligence.
Star Schema Design and Snowflake Schema Design.
Dimension Table, Confirmed Dimension, Fact Table, Fact less Fact Table, Types Facts.
Slowly Changing Dimensions (SCD).
Active Transformation and Passive Transformation.
Connected Transformations And Unconnected Transformations.
INFORMATICA:
Introduction, Definition.
Informatica Products (Power Center & Power Mart).
Power Center Components:
*Designer
*Repository Manager
*Workflow Manager
*Workflow Monitor
*Power Center Admin Console
Informatica Client Components.
Informatica Server Components.
Transformations - Active and Passive Transformations
Slowly Changing Dimensions
Workflow Manger
Monitoring workflows and debugging errors
Informatica Architecture.
Informatica Server Architecture.
Load Manager & DTM.
Importing Source Metadatas (Database Objects & Flat files and XML files).
Creating Target Metadatas (Importing or Creating a New Target Metadata Structures).
All Transformations (Source Qualifier, Filter, Joiner, Expression, Aggregator, Rank, Sequence Generator, Sorter, Router, Stored Procedure, Union, Transaction Control, Update Strategy, Lookup and XML).
Extraction Data from Flat files (Fixed-width and Defined).
Extraction Data from XML Files.
Creating Mappings with Transformation Rule.
Types of Sessions (Re-usable & Non Re-usable).
Creating Sessions and Workflows and Executing Mappings.
ADVANCED TOPICS:
Constraint Based Loading.
Unconnected Stored Procedure.
Unconnected Lookup.
Target Load Plan.
Creating Mapplet and Implementation.
Creating Reusable Transformation and Implementation.
Mapping Parameters.
Mapping Variables.
Session Parameters.
File Repository (Data Extraction from Indirect Files).
Slowly Changing Dimensions (Type 1, Type2 and Type 3).
Creating Worklet and Implementation.
