• support@conveytechlabs.com

Informatica Power Center

Duration
30hrs
Type
online

Informatica PowerCenter is a widely used extraction, transformation and loading (ETL) tool used in building enterprise data warehouses. The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse.

    • Duration: 30 hrs
    • Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day
    • Method: Online/Classroom Training
    • Study Material: Soft Copy
    Introduction to Dataware Housing
    • Data warehouse concept
    • Differences between Online Transaction Processing and data warehouse
    • Types of Data Warehouse
    • Data warehouse Architecture
    • Difference between Data warehouse & Data mart
    • Data Warehouse Approaches
    • Data Warehouse Components
    • Logical & physical Design
    • Operational data sources(ODS)
    MODELLING FOR DATA WAREHOUSE
    • Fact Table
    • Dimension tables and types
    • Data Warehouse Schemas: Star schema and
    • Star Query, star flake schema, snow flake
    • schema and Galaxy Schema
    • Informatica PowerCenter
    • Product Overview
    • PowerCenter Domain
    • Administration Console
    • PowerCenter Repository
    • PowerCenter Client
    • Repository Service
    • Integration Service.
    REPOSITORY MANAGER

    • Adding a Repository to the Navigator
    • Configuring a Domain Connection
    • Connecting to a Repository
    • Viewing Object Dependencies
    • Validating Multiple Objects
    • Comparing Repository Objects
    • Working with FoldersAgenda(Continue..)
    • POWERCENTER DESIGNER
    • Source Analyzer
    • Working with Relational Sources
    • Working with Flat Files
    • Target Designer
    • Mappings
    • Transformations
    • Working with Ports
    • Using Default Values for Ports
    • User-Defined Default Values
    • Tracing Levels
    • Basic First Mapping
    • Expression Transformation
    • Filter Transformation
    • Router Transformation
    • Union Transformation
    • Sorter Transformation
    • Rank Transformation
    • Aggregator Transformation
    • Joiner Transformation
    • Source Qualifier
    • Lookup Transformation
    • Lookup Types
    • Lookup Transformation Components
    • Connected Lookup Transformation
    • Unconnected Lookup Transformation
    • Lookup Cache Types: Dynamic, Static, Persistent, Shared
    • Update Strategy
    • Dynamic Lookup Cache Use
    • Lookup Query
    • Lookup and Update Strategy Examples
    • Stored Procedure Transformation
    • Connected Stored Procedure Transformation
    • Unconnected Stored Procedure Transformation
    • Sequence Generator Transformation
    • SCD Type 1 and Type 2 with real time examples
    • Mapplets: Mapplet Input and Mapplet Output Transformations
    • Normalizer Transformation
    • XML Sources Import and usage
    • Mapping Parameters and Variables
    • Parameter File
    • Indirect Flat File Loading
    • WORKFLOW MANAGER
    • Working with Workflows
    • Assigning an Integration Service
    • Working with Links
    • Workflow Variables
    • Session Parameters
    • Working with Tasks
    • Session Task
    • Command Task
    • Working with Event Tasks
    • Email task
    • Decision Task
    • Control Task
    • Timertask
    • Assignment Task
    • Session Properties
    • Workflow Properties
    ADVANCED TOPICS:
    • Push down Optimization Technique
    • Version Control
    • Constraint Based Load Ordering
    • Target Load Plan Order
    • Career oriented training.
    • One to One live interaction with a trainer.
    • Demo project end to end explanation.
    • Interview guidence with resume preparation.
    • Support with the trainer through E-mail.