Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Informatica Power Center Training

No Reviews Yet

Ashoke Nath Sastry Road, Kolkata

Course ID: 32231

Ashoke Nath Sastry Road, Kolkata

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

This course will contain following topics:

Oracle Concepts:
? Oracle Objects
? DDL Statements
? DML Statements
? TCS Statements
? Joins
? Sub Query
? Correlated Sub Query
? Oracle Analytical functions
? Views, Materialized views

Data Warehousing Concepts
? Data Warehousing (what is Data Warehousing /Why Data warehousing/How Data warehousing)
? Slowly Changing Dimensions (SCD1, SCD2, SCD3)
? OnLine Transaction Processing (OLTP)
? OLAP (Online Analysis And Processing
? Metadata
? Dimentinal Table
? Types Of Dim Tables
? Fact Table
? Types of Fact Tables
? Advantages of OLAP
? Different Methodologies of DWH

Expression, Filter, File Lists and Workflow Scheduler
? Workflow Scheduler
? Expression Editor
? Filter Transformation
? File Lists

Lookups and Reusable Transformations
? Lookup Transformation
? Reusable Transformations

Joins, Features and Techniques
? Joiner Transformation
? Shortcuts

? Debugging Mappings
Lookup Caching, More Features and Techniques

? Lookup Caching
? Lab A – Load Promotions Dimension Table
? Lab B – Features and Techniques II
? Review and more Lab Activities and Real time issues

Sequence Generator
? Sequence Generator Transformation
? Lab – Load Date Dimension Table and Real time issues

Router, update Strategy and Overrides
? Router Transformation
? Update Strategy Transformation
? Expression Default Values
? Source Qualifier Override
? Target Override
? Session Task Mapping Overrides

Dynamic Lookup and Error Logging
? Dynamic Lookup
? Error Logging

Unconnected Lookup, Parameters and Variables
? Unconnected Lookup Transformation
? System Variables
? Mapping Parameters and Variables
? Lab – Load Sales Fact Table

Sorter, Aggregator and Self-Join
? Sorter Transformation
? Aggregator Transformation
? Active and Passive Transformations
? Data Concatenation
? Self-Join
? Lab – Reload the Employee Staging Table and Real time issues

Workflow Variables and Tasks
? Link Conditions
? Workflow Variables
? Assignment Task
? Decision Task
? Email Task
? Lab – Load Product Weekly Aggregate Table

? Mapplets
? Lab – Load Product Daily Aggregate Table
? Review and more Lab Activities and Real time issues

More Tasks and Re-usability
? Event Raise Task
? Event Wait Task
? Command Task
? Reusable Tasks
? Reusable Session Task
? Reusable Session Configuration

Worklets and More Tasks
? Worklets
? Timer Task
? Control Task
Informatica Functions
? aefwdf

Performance Tunning
? Performance tuning of various transformations.
? Performance tuning using Informatica functions.
? Performance tuning using Informatica mathematical signs.
? Proper Performance tuning using various session properties.
? Track performance using Informatica log.
? Informatica various inbuilt variables for performance tracking.
? Partitioning
? Push down optimization
o Source-Side Pushdown Optimization
o Target-Side Pushdown Optimization
o Full Pushdown Optimization

Real Time Project
? Dimension Creation (SCD-1 & SCD-2)
? Fact Creation
? Load data from source to stage
? Load data from stage to dimension/fact

Interview Question & Answer

Date and Time

Not decided yet.

About the Trainer

Nayan Mondal picture

5 Avg Rating

1 Reviews

1 Students

6 Courses

Nayan Mondal


8 Years of Experience

- 9 years experience in IT industry.
- Experience in ETL mapping, performance tuning for 5 years.
- Experience in Data Modeling of 3 years.
- Prepare for interview.


No reviews currently Be the First to Review


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Informatica Training Post your requirement now


Submit your enquiry for Informatica Power Center Training

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Nayan

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more