Informatica Admin Online Training
About Course
This Informatica Admin Online Training is an industry-designed course for mastering the Informatica tool and Data Integration concepts such as ETL and Data Mining using Informatica PowerCenter:
- Informatica is the best ETL tool in the market.
- It can extract data from multiple heterogeneous sources, transforming them as per business requirement and loading to target tables. In addition, Data migration and loading projects are created using Informatica as a tool.
- . Here at Nisa Online Training, you will learn how to configure, install, and administer the PowerCenter.
- As part of the training, you will also test and monitor data processing using an automated, scalable and auditable approach.
As a result, you will get trained in Workflow Informatica, data warehousing, Repository Management and other processes.


Why should you learn Informatica?
Informatica is the market leader in the ETL segment. It can work on a wide variety of data sets, varying standards and multiple applications and systems. Thus, organisations worldwide rapidly adopt it, providing substantial job opportunities for professionals with the right skills.
What will you learn in this Informatica Admin Online Training Course?
- Informatica architecture and Informatica PowerCenter
- Installation and configuration of Informatica
- Managing and monitoring Informatica workflow
- PowerCenter handling Jobs and Tasks
- Informatica workflow variables and session parameters
Why should you choose Nisa For Informatica Admin Online Training?
Nisa Trainings is the best online training platform where we conduct one-on-one interactive live sessions with a 1:1 student-teacher ratio. You can gain hands-on experience by working on near-real-time projects under the guidance of our experienced faculty. We support you even after the completion of the course and are happy to clarify your doubts anytime. Our teaching style at Nisa Trainings is entirely hands-on. You’ll have access to our desktop screen and will be actively conducting hands-on labs on your desktop.
Job Assistance
If you are working on Informatica and facing any problem while working on it, then Nisa Trainings is simply a Call/Text/Email away to assist you. We offer Online Job Support for professionals to help them and to solve their problems in real-time.
The Process we follow for our Online Job Support Service:
- We receive your enquiry about Online Job Support.
- We will arrange a telephone call with our consultant to grasp your complete requirement and the tools you’re using.
- If our consultant is 100% confident in taking up your requirement and when you are also comfortable with our consultant, then only we will agree to provide service. And then you have to make the payment to get the service from us.
- We will fix the timing for Online Job Support as mutually agreed by you and our consultant.
Course Information
Informatica Training
Duration: 40 Hours
Timings: Weekdays (1-2 Hours per day) [OR] Weekends (2-3 Hours per day)
Training Method: Instructor Led Online One-on-One Live Interactive Sessions.
What Will I Learn?
- Working with Informatica Admin Console
- Informatica performance tuning
- Managing Informatica Repository
- ETL functionalities and scenarios
- Informatica SQL and XML transformation
- Preparing for Informatica certification
Topics for this course
Data warehouse basics
OLTP System
Datawarehouse
Different Defeinitions of datawarehouse
Difference between OPERATIONAL DS AND DWH
Data Extraction
DataTransformation
Types of ETL
Data Merging
Data Loading
Types of Data loading
Data Aggregation
Datawarehouse Approaches
Top down approach and Bottom up approach
DW Life cycle
DW-database design
Types of Dimensions
Types of fact table
Star schema and Snow flake schema
Dimensional modelling
Facts and dimensions
Granuality
Types of Olap
Informatica Power Center 9.1
Power center Administration
Power center components
Informatica Power center architecture
ETL Plan
Power center Clients
Workflow manager
Desiginer
Work Flow monitor
Workflow manager
Repository manager
Power center repository
Administrative tool
Repository services
Integration services
Power center domain
Application services
Concept of nodes and grid
Service manager
Power center administration console
Repository Administration
Creating Repository Users and Groups .
Connecting to the Repository.
Creating a Group
Assigning Privileges to a Group.
Creating a User
Creating a Folder
Folder Permissions
Creating Folders
Using the designer
Creating Source Tables.
Creating Target Definitions.
Target Tables Creation
Creating a Pass-Through Mapping
Source definitions creation
Creating a Mapping
Connecting Transformations
Transformation Creation
Using Transformations
Creating a Mapping with Aggregate Values
Creating an Aggregator Transformation
Active and passive transformations
Creating an Expression Transformation
Creating a Lookup Transformation
Connecting the Target
Creating the Session
Creating the Workflow
Mapping with SCD Type 1 and SCD Type 2
Filter Transformation Creation
Creating a Sequence Generator Transformation
Creating a Stored Procedure Transformation
Completing the Mapping
Creating the Target
Expression Transformation
Creating Router Transformations
Completing the Mapping
How to monitor loads
Use of Workflow monitor
Using the workflow manager
Connecting Transformations
Creating Sessions and Workflows
Configuring Database Connections in the Workflow Manager
Creating a Reusable Session
Creating a Workflow
Running and Monitoring Workflows
Opening the Workflow Monitor
Workflow Tasks
Session
Assignment task
Link task
Event raise task
Event wait task
Timer task
Post session and Pre-session commands
Session recovery
Commit points
Creation of Parameter file
Mapping and session parameter
Performance tuning in ETL
Various optimization technique
Pushdown optimization
Incremental aggregation
Student Ratings & Reviews
Requirements
- You don’t need any specific skills to learn Informatica. However, a basic knowledge of SQL can be an added advantage.
Target Audience
- Business Intelligence, ETL, SQL and Database Professionals, Project Managers and graduates looking to make a career in BI