Informatica Power Center 7.x/8.x/9.x

  • Introduction to ETL Logic
  • Overview of Staging Area
  • Need of ETL Logic
  • Difference between OLTP systems and OLAP systems
  • Overview on Data Warehousing concepts
  • Introduction to Data Modeling
  • Overview on Database
  • Construction of DWH/Data marts using ETL logic
  • Introduction to Informatica Power Center
  • Difference between various versions of Power center
  • Overview of sub tools of the Informatica Power Center:
  • Informatica Client
  • Informatica Server
  • Informatica Repository
  • Informatica Repository server
  • Overview on integration service
  • Internal Architecture of the server
  • Informatica client:
  • Informatica designer
  • Workflow manager
  • Workflow monitor
  • Repository manager
  • Repository server administrative console
  • Working with Power center administrative console
  • Create folder
  • Create repository service
  • Create users and users groups and assign privilegesExplanation on data movement mode
  • ASCII and Unicode
  • 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
  1. Connected
  2. Unconnected
    • Stored Procedure and function
  3. Connected
  4. Unconnected
    • Update Strategy
    • Transaction control
    • Normalizer
    • 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
  • Data Masking
  • Data Unstructured

Mapping designer:

  • Best practices when building mappings
  • Construction of complex 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
  • Design type-1, type-2, and type-3 dimensions for various requirements within a single mapping.
  • Construction of the complex mappings for Data warehousing
  • Creation of the cubes
  • Analysis of Business user requirements
  • Combined type-1,type-2 and type-3 in a single mapping
  • Working with SCD wizards
  • Working with Rapidly Changing dimensions (RCD).
  • Development of the target tables based on business user requirements
    • Source analyzer:
  • Import source tables from different data bases or flat files
  • Working with XML files
  • Working with COBOL files
  • Create new source tables in the sources analyzer
  • Define the relationships
  • 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
  • Customized 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
  • Design sequential and concurrent batch workflow
  • Explanation of the different types of the memories
  • Buffer, Cache
  • 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
  • Mapping parameters and variables creation
  • Parameter file creation
  • Internal working function of the Informatica Power center
  • Parallel Pipeline partitioning
  • Creation and deletion of partitioning points
  • Execution of the mappings:
  • Normal execution
  • Debugging mode execution
  • Loading:
  • Normal loading
  • Bulk loading
  • Constraint based loading
  • Lookup cache:
  • Static
  • Dynamic
  • Re-cache from source
  • Persistent cache
  • Shared cache
  • Introduction to Load Manager (LM)
  • Overview on DTM (Data Transformation Manger)
  • Working with Parallel pipeline partitioning mechanism
  • Introduction Threads
  • Types of threads:
  • Reader thread
  • Transformation thread
  • Writer thread
  • Pre-session thread
  • Post-session thread
  • Analysis of BRS
  • Development of RRS
  • Sample project development

 

 

Leave a reply

required