Informatica Online/Classroom Training

Teacher
Category:
Data Warehousing/ TRENDING COURSES/
₹24,999.00

₹24,999.00

2314 in stock

2314 Students
Duration: 30 HRS
Lectures: 30 Sessions
Video: Recordings would be shared.
Course Completion Certificate would be given after the training.

About the course

Informatica Course introduces learners to advanced learning of Informatica Installation, Configuration and Administration using PowerCenter 9.X. This course gives exposure to using automated, scalable and auditable approach to test and monitor critical data processing. It also coversWorkflow Informatica, Manager and Monitor, Repository Management anddeployment of strategies like creating transformations, session, mappings, performance tuning and others.

Learning Objectives

After completion of this course, you will be able to:

  • Understand what is Informatica and PowerCenter Workflow Manager
  • Understand Workflow Task and Job Handling
  • Use Session Parameters, Workflow Variables in PowerCenter
  • Perform debugging, troubleshooting, Error Handling and Recovery in PowerCenter
  • Understand and implement session caches
  • Gain insights into Performance Tuning and Optimization
  • Understand Informatica Administration Console and Security
  • Define Technical Architecture of Informatica 9.X
  • Learn Informatica Installation and Configuration
  • Learn to handle ETL scenarios and understand functionalities of Repository Management
  • Understand Informatica Error Handling framework
  • Use SQL Transformations, XML Transformations and Perform XML processing and Push Down Optimization 

Who should take the course:

Recommended Audience

  • Business Intelligence Professionals or ETL Developers
  • Professionals aspiring to master Business Intelligence
  • Project Managers, Database Professionals, Mainframe Professionals, SQL Developers
  • Individual learners aiming to build career in Enterprise Business Intelligence

Course Content

1.Introduction to Datawarehousing

  1. Data Warehousing Concepts
  2. Dataware housing (what/Why/How)
  3. Data Modelling(Schemas, FACTS and DIMENSIONS)
  4. Slowly Changing Dimensions
  5. Metadata

2. Power Center Components

  1. Designer
  2. Repository Manager
  3. Workflow Manager
  4. Workflow Monitor

3. Informatica Concepts and Overview

  1. Informatica Architecture.
  2. Source Qualifier
  3. Target Designer
  4. Transformations
  5. Mappings
  6. Mapplets
  7. Sessions
  8. Tasks

4. Sources

  1. Working with relational Sources
  2. Working with Flat Files

5. Targets

  1. Working with Relational Targets
  2. Working with Flat file Targets

6. Transformations

  1. Expression Transformation
  2. Lookup Transformation
  3. Sequence Generator Transformation
  4. Filter Transformation
  5. Joiner Transformation
  6. Sorter Transformation
  7. Procedural Transformation
  8. Router Transformation
  9. Aggregator Transformation
  10. Update Strategy Transformation
  11. Union Transformation
  12. Rank Transformation
  13. Transaction Control Transformation
  14. Normalizer Transformation
  15. Source Qualifier Transformation
  16. Stored Procedure Transformation
  17. XML Source Qualifier Transformation
  18. Debugging Mappings

7. ADVANCED INFORMATICA CONCEPTS

  1. Unconnected lookup Transformation
  2. Mapplet a
  3. Defining Reusable Transformations.
  4. Tasks And Types of Tasks.
  5. Worklet
  6. Scheduling Work flow
  7. Target Load Plan
  8. Types of Batch Processing
  9. Link conditions
  10. Mapping Parameters
  11. Mapping Variables
  12. Defining Session Parameters
  13. PMCMD Utility

8. TYPES Of LookUp Caches

  1. Static LookUp Cache
  2. Dynamic LookUp Cache
  3. Perisistance lookup Cache
  4. Shared LookUp Cache

9. Task Types:

  1.  Session
  2.  Command
  3.  EMAIL
  4.  Timer
  5.  Event Wait
  6.  Event Raise
  7.  Decision
  8.  Assignment
  9.  Control
  10.  Worklet

Testimonials

Vasudevan, USA

Just wanted to update you that I cleared my Oracle certification exam today. Jagadeesh – I would like to thank you for the training & guidance you have provided me throughout. thanks for introducing me to a brilliant trainer (Jagadeesh) and providing all necessary support.

Mohita, Australia

I have completed my Testing training with Kumar and I am very satisfied with the quality of training and support that he gave me. I am now in a very confident position to begin my career in Testing Platform. Because of the quality of the training I received, I will be recommending friends and colleagues to take up similar courses with your training provision

Rashel, Australia

As being of your customer, I am really happy with Mr Rao and his capabilities and the Datastage training capability. Training over the online, it is not only matter of providing training…there should have some sort of caring and relationship with end user which Mr Rao has got in a full pace… Thanks Mr Rao. I really appreciate your help. We will be in contact.

Anupama, Singapore

We have completed the Teradata training as per the curriculum. Thanks a lot Girish for your detail explanation, i hope you continue the same after, in-case any doubts.

Ahmed, USA

Testing Selenium is complete now. 1) I am impressed by your sincere dedication to make students understand the concepts and then testing the students by conducting the mock interviews & QA… I have not seen this type of dedication anywhere. 2) Your quick replies on any technical questions helped me alot. 3) Your soft, humble manners made me give you a name. In my friends circle, I refer you as a Professional Center for Testing Training.

Mahendra, USA

Please be informed that, I have finished the basic Java course with Krishna. He has done a good job. I am on a Project now, however, I will go through the recorded session, as and when I find time and reach him for any clarification required

James, USA

Syam Kumar did a wonderful job in training the DBA class. He was eloquent, knowledgeable and extremely helpful in making sure we understand every concept. I would definitely recommend the class to my peers.

Asim, Aus

My Salesforce Admin training has been completed and the consultant, Mr.Vasant is very supportive. He explains each and every concept in detail with practical examples. He provide lots of help while practicing topics. Finally in fact he has very sound technical knowledge. He satisfies each query and do not ignore any question till student get full understanding.

Dharan, Aus

Thank you for delivering the SAS course. Your delivery method was excellent and the course material covered I believe is enough for me to start as a SAS Professional. The best thing was that you were organised and you stuck to the schedule. I will now complete few excercises as discussed over the next two weeks to wrap it off.

Danny, USA

The Informatica instructor is clear and on target, overall the training sessions were excellent. Just scheduling is some times difficult,but at the end i would say the training was satisfactory and i could able to learn configuration in detail.I am happy to refer others to this course with you guys.

Reviews

Average Rating

0
₹24,999.00
0 Ratings

Detailed Rating

Stars 5
0
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0

There are no reviews yet.

Be the first to review “Informatica Online/Classroom Training”