Informatica Training

Training in Chennai

Module 1

  • Introduction and Architecture
  • Introduction to Informatica
  • Architecture of Informatica PowerCenter
  • Installation and configuration
  • Informatica Design Process
  • Domain,node and services
  • Repository Service
  • Integration service
  • Configure security
  • Informatica Client Tool
  • Designer,Workflow manager ,Workflow monitor
  • Designer tools
  • Source analyzer,target designer,Transformation developer
  • Mapping and Mapplet designer

Module 2

  • Mapping Designer
  • Create a Simple Mapping
  • Overview of Transformations
  • Types of Transformations
  • Active and Passive
  • Expression Transformation
  • Source Qualifier Transformation
  • Introduction to Workflow Manager
  • Task Developer
  • Workflow Designer
  • Creating Connections

Module 3

  • Flat Files Handling
  • Create Simple Mappings
  • Flat File Analysis

Module 4

  • Architecture Review
  • Architecture Review
  • Differences between PowerMart and PowerCenter
  • Connecting to SAP-FTP Process
  • Command Task
  • Create a Mapping
  • Joiner Transformation

Module 5

  • ransformations
  • Create a Mapping
  • Using Join in a Source Qualifier Transformation
  • Expression Transformation
  • Filter Transformation

Module 6

  • Transformations Session1
  • Multiple Targets Loading
  • Router Transformation
  • Difference Between Filter and Router Transformations
  • Create a Mapping
  • Master Outer Join

Module 7

  • Transformations Session2
  • Reusable Transformation
  • Lookup Transformation
  • Debugger
  • Handling Multiple Files as Source

Module 8

  • Mapplets
  • Sequence Generator Transformation
  • Multiple Pipelines in a Single Mapping
  • Target Load Plan-Mapplets

Module 9

  • Update Strategy
  • SCD Type 1 mapping Implementation
  • Update Strategy Transformation
  • SCD Type 2 and Type 3 mapping Implementation

Module 10

  • Loading Strategy
  • Sequential and Parallel Loading
  • Union Transformation
  • Dynamic Lookup Cache
  • Introduction to Fact Loading

Module 11

  • Transformations
  • Date Dimension Loading
  • Lookup Transformation
  • Persistent Cache
  • Aggregator Transformation
  • Sorter Transformation
  • Creating Stored Procedure

Module 12

  • Transformations
  • Normalizer Transformation
  • Stored Procedure Transformation
  • Active Vs Passive Transformations
  • Connected Vs UnConnected Transformations

Chapter 13

  • Implementing Incremental Loading
  • Importance of Mapping Variable
  • Implementing Incremental Aggregation
  • Create a Mapping
  • Incremental Aggregation
  • Transaction and Variable Port
  • Transaction Control Transformation
  • Variable Ports

Chapter 14

  • Workflow Tasks
  • Scheduling
  • Task Link Properties
  • Event Raise Task
  • Event Wait Task
  • Worklet
  • Timer
  • Command
  • Email
  • Control
  • Decision
  • Assignment

About Informatica

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.Informatica powercenter is produced by Informatica Corp for data warehousing and business intelligence.

In real time, LLC is the world’s number one independent provider of data integration software. Over 5,800 enterprises depend on Informatica to leverage the potential of, and protect , their information from devices (IoT) to mobile to social to big data on-premise, in the cloud and across social networks.

Many of the industries are using ETL tools and in that,the most important one is Informatica.Geoinsyssoft gives you the live session about the informatica through our trainers in chennai. We take extra care for training the students in Informatica for acquiring wide knowledge and getting cleared in basic concepts.For the past decade we were involved in Informatica training in chennai.

We do online,classroom and corporate training.

If you are looking for the best institute for informatica training in chennai, then Geoinsyssoft is your correct choice. Geoinsyssoft’s informatica training in chennai received good reviews from students. We shifted their successful career into data warehousing space.Our Informatica training, will stimulates you to open avenues for carrier success in India and abroad in this space.

Developed by God Particles
Back to Top