DATAWAREHOUSING - INFORMATICA

  • Introduction to ETL Logic
  • Overview of Staging Area
  • Need of ETL Logic
  • Difference between OLTP systems and OLAP systems
  • Construction of DWH/Datamarts using ETL logic
  • Introduction to Informatica Power Center
  • Overview of sub tools of the Informatica Power Center:
  • Informatica Client
  • Informatica Server
  • Informatica Repository
  • Informatica Repository server
  • Internal Architecture of the server
  • Informatica client:
  • Informatica designer
  • Workflow manager
  • Workflow monitor
  • Repository manager
  • Repository server administrative console
  • Informatica Designer:
  • Source analyzer
  • Ware house designer/ target designer
  • Transformation developer
  • Mapplet designer
  • Mapping designer
  • Workflow manager:
  • Workflow designer
  • Worklett designer
  • Task developer
  • Transformations:
  • Reusable transformations
  • Non-reusable transformations
  • Active and Passive transformations
  • Source qualifier
  • Expression
  • Aggregator
  • Rank
  • Filter
  • Router
  • Lookup
  • Connected
  • Unconnected
  • Stored Procedure and function
  • Connected
  • Unconnected
    •  Update Strategy
    • Transaction control
    • Normalizor
    • Sequence generator
    • Union
    • Joiner ( Normal, Mate router, detail Outer, Full Outer)

XML Source qualifier
Sorter
Mapplet input
Mapplet Output

  • Advanced Transformations:

Java Transformation
Sql  Transformation
HTTP transformation
SAP R/3 Transformation
Mapping designer:

  • Best practices when building mappings
  • Construction of simple mappings for dimension tables and fact tables
  • Dimension mappings:
  • SCD type-1
  • SCD type-2
    • Flag current data
    • Effective data range
    • Version number mapping
  • SCD type-3
  • Construction of the complex mappings for Data warehousing
  • Creation of the cubes
  • Analysis of Business user requirements

Development of the target tables from business user requirements

    • Source analyzer:
  • Import source tables from different data bases or flat files
  • Create source tables in source analyzer itself.
  • Target designer:
  • Import target tables from different data bases or flat files
  • Create target tables in target designer itself.
  • Reusable transformations in Transformation developer
  • Transformation logic development in Mapplet designer
  • Properties explanation of the transformations
  • Customised query generation in source qualifier
  • Pre and post sql
  • Differences between source qualifier and joiner transformation with practical explanation
  • Difference between filter and router transformations with practical explanation
  • Difference between expression and aggregator transformation with practical explanation
  • Overview of the workflow manager
  • Reusable tasks development in task developer
  • Tasks logic development in worklett designer
  • Workflow development in workflow designer
  • Explanation of the different types of the memories
  • Overview of the load manager
  • Overview of the Data transformation manager
  • Overview of different types of tasks:
  • Start task
  • Session task
  • Event wait
  • Event raise
  • Timer
  • Decision task
  • Control task
  • E-mail task
  • Command task
  • Scheduling a task
  • Mapping parameters and variables creation
  • Parameter file creation
  • Internal working function of the Informatica Power center
  • Parallel Pipeline partitioning
  • Creation and deletion of portioning points
  • Execution of the mappings:
  • Normal execution
  • Debugging mode execution
  • Loading:
  • Normal loading
  • Bulk loading
  • Constraint based loading
  • Lookup cache:
  • Static
  • Dynamic
  • Recache from source
  • Persistent cache
  • Shared cache
  • Analysis of BRS
  • Development of RRS

Sample project development