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 DevelopmentTraining

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 Chethan H G Institute

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 DevelopmentTraining

Basavanagudi, Bangalore

11,000

3 Reviews
1 Interested

About the Course


- Real Time Trainers with more than 9+yrs exp.
- Regular tracks & Fast tracks are available
- Week-end batches for working professionals
- Weekday early morning & evening batches
- Helps in cracking Certifications
- Real time projects discussion
- Resume preparation
- Mock Interviews
- Placement assistance

Topics Covered

Dataware House Concepts Architecture
ETL Concepts
Informatica Power Center
Informatica Transformations
Advanced Transformations
Performance Tuning
Scheduling
Features
======Detailed Contents=======

Section1: Data WareHouse Concepts
DatawareHouse Concepts
Normalization
De-normalization
ED warehouse,
Data mart, OD Source
Top down approach
Bottom up approach
Fact & Dimension Tables,
Dimensional modeling
Dimensions & its Types
Facts & its Types
Star schema
SnowFlake Schema
Slowly Changing Dimensions (SCD)
type 1
type 2
type 3
type 4
type 6
ETLProcess
ETLArchitecture
Tools
BI basics
BI tools


Section2: ETL Testing Tool

? ETL Process & Architecture
? ETL Tool (Informatica (8.6.1 or 9.x))
? Installation
? Power Centre Client Tools
? Mapping Creation
? Workflow & Task Creation
? Running of the workflow
? Monitoring the tasks

Section3: ETL Testing

? ETL Testing
? ETL Transformations
? Testing Startegy & methods
? DB Testing
? DB Test cases
? Report (BI)Testing
? Introduction to (BI) OBIEE tool

Section4: Informatica Development

Designer Module

? Working with sources
? Working with flat files
? Working with targets
? Mappings
? Mapplets
? Mapping parameters and variables
? Using the debugger
? Using the mapping wizards

Transformation Module
? Aggregator
? Expression
? Filter
? Joiner
? Lookup
? Lookup Caches
? Rank
? Router
? Sequence Generator
? Sorter
? Source Qualifier
? Stored Procedure
? Union
? Update Strategy
? Xml Transformation

Workflow Administration Module

? Using workflow manager
? Managing connection objects
? Working with workflows
? Working with workflow variables
? Working with tasks
? Working with worklets
? Working with sessions
? Session configuration object
? Working with sources
? With targets
? Sending emails
? Partitions
? Parameter files.
? Incremental aggregation

Who should attend

-PL/SQL Developers
-ETL Testers
-DB analysts
- Working professionals who wants better opportunities
- Professionals who want to move to Datawarehouse field from their current domain

Pre-requisites

-ANY Graduation
-SQL Knowledge

What you need to bring

Book and Pen"""""

Key Takeaways

- Experienced level training matching industry standards
- Deep understanding of the subject
- Relevant class notes
- Real time project related scenarios
- Tips for cracking the interviews
- Resume preparation points
Content
Reviews

Recommendations & reviews from previous Customers:

Pramod

"I would like to recommend SarlacG technologies to the people who are willing to learn some evergreen technologies like Java, ETL, Sql & Pl/Sql and many more. I have joined this institute just 1 month back and now I am finding very easy to work on these technologies eventhough they seems very difficult technologies. This is only because the trainers of this institute especially Chethan sir is extremely awesome at his technical knowledge. And also he is very helpful, polite and he clears each and every doubts even a silly ones at the time of teaching itself. And also they provide all the needed softwares, notes and much more study materials to help students to improve their skills. And also they will assure students to get the job very soon after finishing the course. So I can suggest you people to join this institute to improve your technical skills and also to have bright future in IT field. Thank you. "

attended Informatica DevelopmentTraining


Singh Dinesh Selvaraj

"It's good actually to learn job oriented course. They will give placement assistance to everyone. "

attended Informatica DevelopmentTraining


Radhiya Rabi

"SarLakG technology should be the choice if your looking for a bright career. I'm blessed that i took up plsql and informatica courses in Sarlakg institute and now i'm placed in one of the best companies. All thanks to Chetan sir who has been a great guide for my bright career :) "

attended Informatica DevelopmentTraining


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


Recommendations & reviews from previous Customers:

Pramod

"I would like to recommend SarlacG technologies to the people who are willing to learn some evergreen technologies like Java, ETL, Sql & Pl/Sql and many more. I have joined this institute just 1 month back and now I am finding very easy to work on these technologies eventhough they seems very difficult technologies. This is only because the trainers of this institute especially Chethan sir is extremely awesome at his technical knowledge. And also he is very helpful, polite and he clears each and every doubts even a silly ones at the time of teaching itself. And also they provide all the needed softwares, notes and much more study materials to help students to improve their skills. And also they will assure students to get the job very soon after finishing the course. So I can suggest you people to join this institute to improve your technical skills and also to have bright future in IT field. Thank you. "

attended Informatica DevelopmentTraining


Singh Dinesh Selvaraj

"It's good actually to learn job oriented course. They will give placement assistance to everyone. "

attended Informatica DevelopmentTraining


Radhiya Rabi

"SarLakG technology should be the choice if your looking for a bright career. I'm blessed that i took up plsql and informatica courses in Sarlakg institute and now i'm placed in one of the best companies. All thanks to Chetan sir who has been a great guide for my bright career :) "

attended Informatica DevelopmentTraining


Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer


Visit Our Website and Justdial and search for Sarlakg Technologies, Bangalore

www.sarlakg.com
Seats Left-

Students Interested 1

Course Id: 13108