Signup as a Tutor

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

Enquire

Submit your enquiry for Informatica PowerCenter Training - Marathahalli

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 DTech IT Education

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

Share

course photo

Informatica PowerCenter Training - Marathahalli

Malleshpalya, Bangalore

13,900

No Reviews Yet
0 Interested

About the Course


100% job oriented training by 10+ years experienced trainer. This hands on Informatica training training provides the required skills and practical knowledge required for developers to implement data integration projects & data migration projects by learning the core features of PowerCenter.

Why DTecH?

* Oracle Partner & Pearson Vue Test Center
* 100% Satisfaction Guaranteed
* Trained more than 2000 students on Oracle & DW/BI in past 4 years.
* Conducted more than 60,000 hours of trainings in past 4 years.
* More than 80 Senior consultant trainers worked with us in 4 years.

Topics Covered

Duration: 10-12 days/ 3 hours per day


Availability: Batches available for Weekend & Online trainings


Project: Project included along with the course


Infrastructure: High End Servers & Setups available for Lab practice


Trainer Profile: 10+ Experienced real time Professional working with leading MNC


Pre-requisite/s: Working knowledge of SQL


Topics Covered:


I. Data Warehousing Concepts
What is and OLTP?
What is Data Warehouse?
OLTP Vs Data Warehouse?
Why do you need Data Warehouse?
How do you build Data Warehouse?
Data Warehousing Technology
Definitions and descriptions
Data Warehouse Architecture
Introduction to BI tools
Introduction to ETL tools
Data Warehouse – Infrastructure
Top Down Vs Bottom Up Approach
Data Warehouse Vs Data Marts
Standalone Data Marts
Enterprise Data Warehouse
Operational Data Store (ODS)
OLAP, ROLAP, MOLAP, HOLAP
Star Schema Vs Snow Flake Schema
Facts & Dimensions
Type 1, Type 2 and Type 3
Slowly Changing Dimension updates
Surrogate key Concept.
Data Staging
Basic ETL Techniques


II. Informatica Powercenter 9x - Project oriented
Power Center: Terminology and Architecture
Informatica Repository Manager
Informatica Designer
Informatica Workflow manager
Informatica Workflow monitor
Mapping Fundamentals
Workflow Fundamentals
Expression and Filter Transformations
Joining and Merging Data
Lookup Transformation
Aggregator and Sorter Transformations
Using the debugger
Updating Target Tables
Mapping Techniques
Create and use reusable transformations
Mapplets
Controlling Workflows
Mapping Design Workshop
Workflow Design Workshop
Informatica Advanced Features



Who should attend

Any BE/MCA graduate who wish to work in Data Warehousing -ETL
Any working professional who wish to switch their career to Informatica

Pre-requisites

Stong knowledge of SQL

What you need to bring

Notebook and pen""

Key Takeaways

Learn how to use Informatica PC with atmost easiness by working around with its excellent Graphical interface. Also learn to crunch huge volumes of data using its complex architecture and innovative performance.
Content
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 2 of 2
S

Swaminathan 13/10/2015

Hi ,

I am looking for informatica training and I would like to know the details . I am looking for in-depth training in informatica in regard to transformations , installation on linux or unix and running process from backgroud etc. Please let me know the details.

0 0

Answer

You can add upto 6 Images

U

chandni 16/06/2014

Hi,

I am interested in Informatica training and I would like to know the details about the date for new batch start, the cost, mode of instructions and any online place with reviews for instructors. Also, please let me know, if I can have any demo session.

Chandni

0 0

Answer

You can add upto 6 Images


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer


8+ yrs experience in IT
Working in MNC in Bangalore
Taken more than 2500 hours of training
Seats Left-

Students Interested 0

Course Id: 18020