Informatica Certification Training
Informatica Training provided by Proideators will help you be the master in Power center ETL tool, data integration and data warehousing concepts. This Informatica course will help you to clear Power Center developer certification and Power Center administrator certification. You will master advanced concepts like installation & configuration, Informatica Architecture, advance Informatica transformations, performance tuning and data migration.Why take this Course?
Informatica is the market leader in the ETL segment. It can work on a wide variety of data sets, varying standards and multiple applications and systems. Thus it is rapidly being adopted by organizations around the world providing huge job opportunities for professionals with the right skills. These Informatica online classes will prepare you for passing Informatica certification.
71% enterprises to adopt hybrid or cloud-only analytics by 2018 – IDG Research Report
Cloud-based BI is fastest growing BI segment; to reach $2.94 billion by 2018 – Redwood Capital Report
Informatica PowerCenter is the most widely adopted ETL Technology – Forrester Research.
Drop us a Query !!!
Informatica Training Course Content and Syllabus
This Proideators Informatica certification training course lets learners grasp advanced skills like Informatica Installation, Configuration and Administration using PowerCenter. You will be able to test and monitor critical data processing using automated, scalable and auditable approach. Get trained in Workflow Informatica, data warehousing, Repository Management and other processes.
Introduction to Informatica
- Basic Definitions
- Informatica Products
- Informatica Architecture
- Tools and their roles
- Folders -sub Folders
- Power Center I Power Malt
- Introduction to designer
Informatica Designer -Introduction
- Designer interfaces
- Designer tools
- Defining Sources
- (i) Database as a source
- (ii) Rat Flies sources
- Defining Targets
- Importing from database
- Creating a new target
- Creating target database objects
- Mapping Introduction
Informatica Designer
- Source Qualifier
- Ports
- Mapping -Table to Table
- Mapping flat File to Table
- Connected/Unconnected Transformations
- Active and Passive Transformation
- Source Qualifier Transformation
- SQl Override-Source Qualifier Transformation
Mapping Source Qualifier as Filter
- Source qualifier to join Data
- Filter Transformation
- Expression Transformation
- Sequence Generator Transformation
- Rank Transformation
- Router Transformation
- Aggregator Transformation
- Joiner Transformation
- Stored procedure Transformation (Connected & Unconnected)
- Union Transformation
- XMl Transformation
- Mapping Wizards
- Implementing Type-I, Type-II, Type-III
- Mappings
- Workflow Introduction
Informatica - workflow Manager Task
- Workflow tools
- Connections
- Defining tasks
- (i) Command Task
- (ii) Email Task
- (iii) Session Task
- (iv) Link Conditions
- (v) Event Wait & Event Raise
- Setting Properties of Session Task
- Creating Workflow
- Starting Workflow
- Monitoring Workflow
- Incremental Aggregation
Informatica Advanced Features
- Mapplet Implementation
- Target Load Plan
- Constraint based Loading
- Mapping Parameters
- Mapping Variables
Connect with us !!