100% Job Assistance
A technology oriented professional trainer having 5+ years of experience in Data Warehousing.
Learn from the basics to advance level of ETL & Informatica tools.
Personal attention given to each & every participant during the training program
Live Projects to get hand-on knowledge.
Batches with limited seats
Weekend batches as per your suitability.
Two training centers for your convenience: Kothrud and Wakad
- If you are located in Kothrud or nearby areas like Karve Nagar, Warje-Malwadi, Bhusari Colony, Shivaji Nagar etc. then our branch in located a short distance away from you i.e. Vanaz Corner, Kothrud.
- If you are located in Pimpri Chinchwad or nearby areas like Pimple Saudagar, Wakad, Chinchwad, Balewadi, Sangvi, Dapodi etc. then you can visit our branch in Wakad near Kalewadi Phata.

Outline

Informatica Course Content:
Informatica Power Center Contents

Introduction & History of Informatica.
Advantages of Informatica compare to traditional coding.
Extraction, Transformation and loading process.
Informatica Power Center Architecture.

Informatica Components

Server
Client

Server Components

Integration Service.
Repository Service.
Reader & Writer DTM.

Client Components

PC Designer.
PC Workflow Manager.
PC Monitor.
PC Repository Manager.

Transformations

Router
Joiner
Expression Transformation.
Rank Transformation.
Sorter Transformation.
Aggregator Transformation.
Lookup Transformation.
Union T/F.
Normalizer transformation.
Update strategy.
Sequence Generator transformation.
Transaction control.
SQL Transformation.
Non reusable transformations.
Reusable transformations.

Power center workflow manager

Workflow Tools.
Workflow Structure and configuration.
Workflow Tasks.
Workflow Design and properties.

Advanced topics

Normal Load & Bulk Load.
Incremental Load.
CBL Loading.
Target Load Ordering.
Dynamic Lookups.
SCD types, 1,2,3.
Mapplets & Worklets.
Limitations of Mapplets.
Pushdown Optimization.
Unit Testing.
Export and import of objects
Debugger
Versioning
Parameters & variables
Enable Test load
Commit Types
Over View PMCMD & PMREP Commands
Pre SQL’s and Post SQL’s
Target Over ride

PC workflow tasks

Session
Email Task
Command task
Control Task
Timer Task
Worklet
Decision Task
Event Wait
Event Raise
Assignment task
Link Conditions

Concurrent and sequential Workflows

Concurrent Workflows.
Sequential Workflows.
Stopping, Starting and suspending tasks and workflows
Scheduling of workflows.

Performance Tuning

Overview of System Environment.
Identifying Bottlenecks .
Source Level
Target Level
Mapping Level
Data Base level

Data Warehouse Concepts

Basics of DWH.
Data Mart.
Data Modeling.
Star Schema.
Snow Flake Schema.
Types of Facts and Fact Tables.
Types of Dimensions.

Additional Contents

Informatica cd.
Informatica Installation.
Unix Commands.
Unix Shell scripting.
Interview questions.
Resume writing tips.
All advanced topics.
Informatica certification Assistance.
Informatica blogs.
Informatica scenarios.

Reviews

Be the first to write a review about this course.

Write a Review

Training Institute Pune is a leading institute in Pune conducting training programs for various software fields & provides certification for both individuals and organizations.Training Institute Pune is subsidiary of Optimized Infotech which offers IT services and training.

We have built a strong reputation to provide an excellent service to individuals with a team of fully qualified professionals. We deliver training to the employed and unemployed individuals to enhance their knowledge & qualities in desired field. We design a training program for additional qualifications beneficial for future & for great career start to candidate undergoing training at our Institute.

Institute offers a wide variety of software classes and access to the concepts and skill development reinforced through training & consulting and certification. The institute is taking a lead in spreading an innovative form of learning that provides you with theoretical as well as practical training.

OUR OBJECTIVE
Our objective is to cater all individuals ranging from beginner level to the IT professionals. Our motto is to provide interactive environment so that the candidates can excel themselves in their desired field & help them grow their career. We put efforts to honestly serve the society & to provide excellent training & classes facilities to our candidates. ...

View Complete Profile

Database & Information Systems