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
- 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.