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)

₹ 15,000

No Reviews Yet

Date and Time

Not decided yet.

Nayan Mondal picture

About Nayan Mondal

- 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

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
? OLTP Vs OLAP
? 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


Debugger
? 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
? 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

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

₹ 15,000

Post your requirement and let us connect you with best possible matches for Informatica Training Post your requirement now
₹ 15,000 Enquire

Enquire

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.

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 support@urbanpro.com 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 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