Informatica

Informatica

Informatica is a Software improvement organization, which offers information joining items. … Informatica Powercenter ETL/Data Integration device is a most broadly utilized instrument and in the regular term when we say Informatica, it alludes to the Informatica PowerCenter apparatus for ETL. Informatica Powercenter is utilized for Data reconciliation.

INFORMATICA COURSE CONTENT

Data warehouse concepts

  • OLTP System
  • Data warehouse
  • Different Definitions of data warehouse
  • Difference between OPERATIONAL DS AND DWH
  • Types of ETL
  • Data Extraction
  • Data Transformation
  • Data Merging
  • Data Loading
  • Types of Data loading
  • Data Aggregation
  • Data warehouse Approaches
  • Top down approach and Bottom up approach
  • DW Life cycle
  • DW-database design
  • Star schema and Snow flake schema
  • Dimensional modeling
  • Facts and dimensions
  • Granularity
  • Types of Dimensions
  • Types of fact table
  • Types of OLAP

InformaticaPowerCenter9.5

  • History of Informatica
  • Opportunities of Informatica
  • Other ETL tools

Informatica Power center architecture

  • Service oriented architecture
  • Integration service architecture
  • Repository service architecture

Power center Clients

  • Repository manager
  • Designer
  • Workflow manager
  • Workflow monitor

Power center administrator home page

  • Power center repository
  • Administrative tool
  • Repository services
  • Integration services
  • Power center domain
  • Application services
  • Concept of nodes and grid
  • Service manager

Repository Administration

  • Creating Repository Users and Groups.
  • Connecting to the Repository.
  • Creating a Group
  • Assigning Privileges to a Group.
  • Creating a User
  • Creating a Folder
  • Folder Permissions
  • Creating Folders

Using the designer

  • Creating Source Tables.
  • Creating Target Definitions.
  • Creating Target Tables
  • Creating a Pass-Through Mapping
  • Creating source definitions
  • Creating a Mapping
  • Connecting Transformations

Transformation

  • Active and passive transformations
  • Connected and un connected
  • Filter transformation
  • Router transformation
  • Expression transformation
  • Aggregator transformation
  • Sorter transformation
  • Rank transformation
  • Joiner transformation
  • Union transformation
  • Source qualifier transformation
  • Lookup transformation connected and un connected
  • Update strategy transformation
  • Stored Procedure transformation connected and un connected
  • Sql transformation
  • Sequence Generator transformation
  • Normalizer transformation
  • Creating a Mapping with SCD Type 1,SCD Type 2 and Type 3

Advance Topics

  • Constraint based Loading.
  • Unconnected stored Procedure
  • Unconnected Lookup.
  • Dynamic Lookup
  • Target Load Plan
  • Creating Mapplet and Implementation
  • Creating Reusable Transformation and Implementation
  • Mapping Parameters.
  • Mapping Variables
  • File Repository (Data Extraction from Indirect Files).

Using the workflow manager

  • Creating Sessions and Workflows
  • Configuring Database Connections in the Workflow Manager
  • Creating a Reusable Session
  • Creating a Workflow
  • Creating Worklet and Implementation
  • Running and Monitoring Workflows
  • Opening the Workflow Monitor

Workflow Tasks

  • Session
  • Link task
  • Event raise task
  • Event wait task
  • Timer task
  • Control task
  • Decision task
  • Command task
  • Email task
  • Creation of Parameter file
  • Mapping and session parameter

Performance tuning in ETL

  • Various optimization technique
  • Pushdown optimization
  • Incremental  aggregation

GPS INFOTECH (Software Solutions)
Url: https://www.gpsinfotech.com
Contact person: prakash
Num: 919395190232 / 9989787231 with Whatsapp
Main mail id : gpsinfotech.net@gmail.com , prakash_m@gpsinfotech.com