Informatica Online Training and job Support at affordable prices.

visit for more details : http://www.itvidya.co/informatica-online-training/

Contact Details :
Email : info@itvidya.co
US : 972-646-8090 India : +91 9966881730

About the course:

Informatica is a widely used ETL tool that is used to extract the source data and load the data into the target after applying the necessary transformation. The efficiency of Informatica in the contemporary era has made it inevitable for organizations. Informatica helps organization to attain a competitive advantage while empowering them with relevant data for an enhanced performance of the organization.

Course Objectives:

After completion of the Business Objects Training from ITVidya, you should be able to:

Learn about the core concepts of Data Warehousing
Understand the Architecture of Informatica
Create and Display different types of Workflows
Deep understanding of Power Center Components
Implement Informatica best practices.
Who should go for this course?

This Business Objects tutorial course is more intended for beginners who want to advance their career in the networking field.

What are the pre-requisites for this Course?

Knowledge of Database concepts is recommended.

Why Learn Informatica?

This Online tutorial Course will deliver an all-inclusive training module with all the possible Informatica solutions. We understand your Informatica need and our Informatica online training module can be customized as per your requirements.

Course Curriculum :

Data Warehousing Concepts

• Data Warehouse
• Data Mart
• OLAP VS OLTP
• Data Warehouse Architecture (Basi
• Data Warehouse Architecture (with a Staging Are
• Dimensional Modeling
• Star Schema
• Snowflake Schema
• Dimension
• Fact
• Slowly Changing Dimension
• Hierarchy
• Confirmed Dimension
• Fact less Fact
• Summary / Aggregations table
• Change Data capture

E T L Informatica Power Center 9

1. Power Center Components

• Designer
• Repository Manager
• Workflow Manager
• Workflow Monitor

2. Informatica Concepts and Overview

• Informatica Architecture
• Source Qualifier
• Target Designer
• Transformations
• Mappings
• Mapplets
• Sessions
• Tasks

3. Sources

• Working with relational Sources
• working with Flat Files

4. Targets

• working with Relational Targets
• working with Flat file Targets

5. Transformations

• Expression Transformation
• Lookup Transformation
• Sequence Generator Transformation
• Filter Transformation
• Joiner Transformation
• Sorter Transformation
• Procedural Transformation
• Router Transformation
• Aggregator Transformation
• Update Strategy Transformation
• Union Transformation
• Debugging Mappings