Informatica Powercenter is an ETL ( Extract, Transform and Load) tool in the Data warehouse and Business Intelligence area. Its an product of Informatica Corp which also offers a wide variety of Business Intelligence products. Informatica is the pioneer in the ETL space. It has a foot print of nearly 40 % in the ETL space. Informatica offers a lot of GUI based interface which is very easy to learn. It also offers a lot of support to the SQL based databases. It's one of the tools which offers a wide variety of support to all the databases including Hadoop, Aster etc... This tool provides a very easy interface to perform medium to complex scale ETL operations.

Informatica has a service oriented architecture where multiple machines can be controlled and monitored using an single console. It is also called as web oriented architecture as everything runs on a web based service.

Informatica Powercenter the ETL tool of informatica comes with four different client based interfaces.

DesignerTo Build Sources, Targets and Mappings

Workflow Manager To Build workflows

MonitorTo Monitor and run the workflow.

Repository Manager Manages the repositories and configure the users groups and folders.

It also has an adminstrator console where all the permissions and load balancing of servers are configured.


DATA WAREHOUSE CONSEPTS

  • Data Warehouse
  • Data Mart
  • OLAP VS OLTP
  • Data Warehouse Architecture
  • Dimensional Modeling
  • Star Scheme
  • Snowflake Scheme
  • Dimensions
  • Fact
  • Slowly Changing Dimension
  • Hierarchy
  • Confirmed Dimension
  • Fact less Fact
  • Summary/Aggregations table
  • Change Data Capture

E T L INFORMATICA POWER CENTER 9


POWER CENTER COMPONENTS

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor

INFORMATICA CONCEPTS AND OVERVIEW

  • Informatica Architecture
  • Source Qualifier
  • Target Designer
  • Transformations
  • Mappings
  • Mapplets
  • Session
  • Tasks

SOURCES

  • Working with relational Sources
  • Working with Flat Files

TRANSFORMATIONS

  • Expression Transformation
  • Lookup Transformation
  • Sequence Transformation
  • Filter Transformation
  • Joiner Transformation
  • Sorter Transformation
  • Pocedural Transformation
  • Router Transformation
  • Aggregator Transformation
  • Update Strategy Transformation
  • Union Transformation
  • Rank Transformation
  • Transaction Control Transformation
  • Normalizer Transformation
  • Source Qualifier Transformation
  • Stored Qualifier Transformation
  • XML Source Qualifier Transformation
  • Debugging Mappings

POWER CENTER TRANSFORMATION LANGUAGE

  • Numeric functions
  • String functions
  • Date functions
  • Conversion functions
  • Cleansing functions
  • Aggregate functions
  • User Defined functions

ADVANCED INFORMATICA CONCEPTS

  • Unconnected lookup Transformation
  • Unconnected Stored Procedure to Create and Drop Index
  • Mapplet and Types of Mapplets
  • Defining Reusable Transformations
  • User Defined Functions
  • Tasks And Types of Tasks
  • Worklet and Types of Worklets
  • Scheduling Work flow
  • Constraint Based Load Ordering
  • Target Load Plan
  • Types of Batch Processing
  • Link conditions
  • Mapping Parameters
  • Mapping Parameters
  • Defining Session Parameters
  • Session Recovery
  • Difference Between Normal and Bulk Loading.
  • Push Down Optimization.
  • PMCMD Utility
  • PMREP Utility
  • Incremental Aggregation
  • Types Of LookUp Caches.
    • Static LookUpCache
    • Dynamic LookUpCache
    • perisistance lookup Cache
    • Shared LookUp Cache

Demo Recording:-

 

Free Demo Class

Register Now