Power Center Informatica Training Course Content

Spread the love

Power Center Informatica Training Course Content Details

What is Power Center Informatica

Informatica may be a code development company supported in 1993 . it’s headquartered in Redwood town, California. it absolutely was co-founded by Gaurav Dhillon and Bartholomeu Diaz Nesamoney. Anil Chakravarthy is that the company’s corporate executive.

Power Center Informatica Training in hyderabad kukatpallyInformatica’s product may be a portfolio targeted on information integration: extract, transform, load, data lifecycle management, business-to-business information exchange, cloud computing integration, complicated event process, information masking, information quality, information replication, information virtualization, master information management, immoderate electronic communication. These parts type a toolset for establishing and maintaining information warehouses. it’s a client base of over five,000 corporations.
nformatica uses a service homeward-bound design, and has the aptitude to share services and resources across many machines. For more info click here.





Power Center informatica Course Content

01. Introduction to Data Warehousing Concepts.

  • What is Data warehousing?
  • Who needs Data warehouse?
  • OLTP Vs OLAP
  • Why Data warehouse is required?
  • Components of a Data warehouse & Architecture
  • Data Cleansing
  • ODS (Operational Data Store)
  • Understand Dimensions, Fact tables
  • What is Confirmed Dimension, Factless Fact Table
  • Understand Datwarehouse Schema- Star Schema, Snowflake Schema

02. Introduction to ETL

  • Components of ETL
  • Various ETL tools available in Market

03. Power Center 9.0.1 Architecture and Components:

  • Introduction to Informatica Power Center (Data Integration)
  • Components of Power Center:
  • Power Center Server Components: Integration Server, Repository Server.
  • Power Center Client tools: Repository Manager, Designer, Workflow manager,Workflow Monitor.

04. Informatica Power Center Designer

  • Introduction to designer
  • Designer Interfaces
  • Designer tools
  • Connecting to Designer
  • Components of Designer
  • Creating Data Source Names (ODBCs)
  • Accessing the source, destinations to the designer
  • Defining Sources using Source Analyzer
  • Database as a source
  • Flat Files sources
  • Defining Targets using Target Designer
  • Working with Relational Targets
  • Working with Flat File Targets
  • Creating target database objects
  • Mapping designer
  • Mapping between the source and target tables
  • Transformation between source and target tables

05. Informatica PowerCenter Designer Understand Transformations

  • What are Informatica Transformations.
  • Active and Passive Transformations
  • Connected and Unconnected Transformations




06. Informatica Transformations:

  • Filter Transformation
  • Router Transformation
  • Expression Transformation
  • Source Qualifier Transformation
  • Joiner Transformation
  • Sorter Transformation
  • Aggregator Transformation
  • Rank Transformation
  • Union Transformation
  • Lookup Transformation:

07. Informatica PowerCenter Reusable Components

  • Creating Reusable Transformations using Transformation Developer
  • Creating Mapplets using Mapplet Designer
  • Creating Worklets using Worklet Designer

08. Informatica PowerCenter Workflow Manager

  • Define Informatica Workflow and why do we need them
  • How to create a Workflow using Workflow Manager
  • Components of a Workflow
  • Defining Tasks in Workflow
  • Informatica Course Outline SVR
  • Technologies
  • Create a Command Task
  • Configure Event Wait
  • Create a Email Task
  • Create a Session Task and understand different settings
  • Start Workflow
  • Monitor Workflow
  • Understand Session logs
  • Understand Workflow Logs

9. Slowly Changing Dimensions (SCDs):

  • SCD concept (Slowly Changing Dimensions)
  • Understand the Flow of Type-I mappings
  • Understand the Flow of Type-II mappings
  • Understand Type-III mappings

Power Center Informatica Training Demo






Contact Us for Power Center Informatica Online and Classroom Training
venkat: 9059868766
email:[email protected]
Address: PlotNo 126/c,2nd floor,Street Number 4, Addagutta Society, Jal Vayu Vihar, Kukatpally, Hyderabad, Telangana 500085

Sharing is caring!

Updated: May 11, 2017 — 4:06 am

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.