What is Informatica?
Informatica Power Center is a powerful ETL tool from. Informatica Corporation. Informatica® is a data integration tool, that is used for Extraction Transformation Loading ( ETL ),
Informatica Corporation products are:
- Informatica Power Center
- Informatica on demand
- Informatica B2B Data Exchange
- Informatica Data Quality
- Informatica Data Explorer
Informatica Power Center is a single, unified enterprise data integration platform for accessing, discovering, and integrating data from virtually any business system, in any format, and delivering that data throughout the enterprise at any speed.
Informatica Training in Chennai
Our Informatica Training in Chennai aims to teach the complete Data Warehousing Concepts in a easier way. We are the Best Informatica Training Institute in Chennai in-terms of syllabus and expert teaching. We are covering almost all the transformations which is required for companies in Informatica.
This software is used for Data Warehousing( DW ) solution to more than 70% of all Business Intelligence( BI ) projects today all over the world. Informatica is predominantly used by most of companies to overcome challenges of Data Warehousing ( DW ) and Business Intelligence ( BI ) compared to any of its competitors.
Informatica® is one of the leading data integration software available in the IT market today.
Each passing day, more and more companies are joining the Informatica band wagon for achieving Data Warehousing through ETL.
Informatica® is one of the fastest growing ETL tools and is way ahead in terms of market and business than any other ETL tool today.
Here at Buoyancy Technologies we will help you master this tool with interactive sessions. The advantage of mastering Informatica® here is that, the sessions will be covered by faculty working in live ETL projects thus giving you an insight into how this ETL tool used in today’s business.
Please feel free to contact us for any further assistance and we will connect you with our experts.
Informatica Training Syllabus
Data Warehouse Introduction
Power Center Components
- Repository Manager
- Workflow Manager
- Workflow Monitor
- Power Center Admin Console
Informatica Concepts and Overview
- Informatica Architecture.
- Working with relational Sources
- Working with Flat Files
- Working with Relational Targets
- Working with Flat file Targets
Transformations – Active and Passive Transformations
- Lookup –Different types of lookup Caches
- Sequence Generator
- Source Qualifer
- Update Strategy
- Stored Procedure
- Slowly Changing Dimension
- SCD Type1
- SCD Type2 — Date, Flag and Version
- SCD Type3
- Creating Reusable tasks
- Workflows, Worklets & Sessions
- Decision task
- Control Task
- Event wait task
- Timer task
- Monitoring workflows and debugging errors
Constraint based load ordering
Target Load plan
Worklet ,Mapplet ,Resuable transformation
Migration –XML migration and Folder Copy.
Parameter and variables
XML Source, Target and Transformations
- Pipeline Partition
- Dynamic Partition
- Pushdown optimization