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