Understanding Domains Nodes Application Services Using Administration Console Managing the Domain Managing Alerts Managing Folders Managing Permissions Managing Application Services Managing the Nodes Managing Users and Groups Managing Privileges and Roles Domain Privileges Repository Services Privileges Reporting Service Privileges Managing Roles – Assigning Privileges and Roles to Users and Groups Creating and Configuring the Repository Services Managing the Repository Creating and Configuring Integration Services Enabling and Disabling the Integration Services Running in Normal and Safe Mode Configuring the Integration Services Processes Integration Services Architecture Creating the Reporting Services Managing the Reporting Services Configuring the Reporting Services Managing License

Using Command Line Programs Infacmd Infasetup Pmcmd pmrep

Using the Designer Configuring Designer Options Using Toolbars Navigating the Workspace Designer Tasks Viewing Mapplet and Mapplet Reports Working with Sources Working with Relational Sources Working with COBOL Sources Working with Cobol Source Files Working with Flat Files Importing Flat Files Editing Flat Files Definition Formatting Flat Files Column Working with Targets Importing Target Definition Creating Target Definition from Source Definition Creating Target Definition from Transformations Creating Target tables Mappings Working with Mappings Connecting Mapping Objects Linking Ports Propagating Port Attributes Working with Targets in a Mapping Working with Relational Targets in a Mapping Validating a Mapping Using Workflow Generation Wizard Mapplets Understanding Mapplets Input and Output Using Mapplet Designer Using Mapplets in Mapping Mapping Parameters and Variables Working with User-Defined Functions Using the Debugger Creating Breakpoints Configuring the Debugger Monitoring the Debugger Evaluating Expression Creating Cubes and Dimensions Using Mapping Wizard Naming Conventions

Understanding the Repository Using Repository Manager Folders Managing Object Permissions Working with Versioned Objects Exporting and Importing Objects Copying Objects

INFORMATICA 10.X DEV + ADMIN

Featured Review

4.8 (2094 Ratings)

In challenging times good decision-making becomes critical. The best decisions are made when all the relevant data available is taken into consideration. The best possible source for that data is a well-designed data warehouse. To make any new decision or to introduce new Plan data warehousing is very important.

0 +

Google Reviews

0 +

JustDial Reviews

Overview

The Syllabus

Curriculum Designed by Experts

Introduction to Informatica

Informatica is a tool, supporting all the steps of Extraction, Transformation and Load process. Now days Informatica is also being used as an Integration tool. Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases. Informatica can communicate with all major data sources (Mainframe/RDBMS/Flat Files/XML/VSM/SAP etc.), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement only. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information

Informatica is not only ETL tool but also Data integrator.Informatica is one of the Best tool in current industry provides versatile solutions to any kind of data.In Radical we provide scenario based training with real time examples, project explanation, project related queries.
Any one who is having basic knowledge of SQL queries can start learning Informatica tool.
As it is a GUI based tool, coding knowledge wouldn’t be necessary.At least 1-3 yrs of experience is good enough to get interview calls.

Administrator Module

Understanding Domains

Nodes
Application Services

Using Administration Console
Managing the Domain

Managing Alerts
Managing Folders
Managing Permissions
Managing Application Services
Managing the Nodes

Managing Users and Groups
Managing Privileges and Roles

Domain Privileges
Repository Services Privileges
Reporting Service Privileges
Managing Roles – Assigning Privileges and Roles to Users and Groups

Creating and Configuring the Repository Services
Managing the Repository
Creating and Configuring Integration Services

Enabling and Disabling the Integration Services
Running in Normal and Safe Mode
Configuring the Integration Services Processes

Integration Services Architecture
Creating the Reporting Services

Managing the Reporting Services
Configuring the Reporting Services

Managing License

Advanced Workflow Module

Understanding Pipeline Partitioning

Partitioning Attributes
Dynamic Partitioning
Partitioning Rules
Configuring Partitioning

Partitioning Points

Adding and Deleting Partitioning points
Partitioning Relational Sources
Partitioning File Targets
Partitioning transformations

Partitioning Types
Real Time Processing
Commit Points
Workflow Recovery
Stopping and Aborting

Error Handling
Stopping and Aborting Workflows

Concurrent Workflows
Load Balancer
Workflow Variables

Predefined Workflow Variables
User- Defined Workflow Variables
Using Worklet Variables
Assigning Variable Values in a Worklet

Parameter and variables in Sessions

Working with Session Parameters
Assigning Parameter and Variables in a Session

Parameter File
Session Caches
Incremental Aggregation
Session Log Interface

Command Reference

Using Command Line Programs

Infacmd
Infasetup
Pmcmd
pmrep

Designer Module

Using the Designer

Configuring Designer Options
Using Toolbars
Navigating the Workspace
Designer Tasks
Viewing Mapplet and Mapplet Reports

Working with Sources

Working with Relational Sources
Working with COBOL Sources
Working with Cobol Source Files

Working with Flat Files

Importing Flat Files
Editing Flat Files Definition
Formatting Flat Files Column

Working with Targets

Importing Target Definition
Creating Target Definition from Source Definition
Creating Target Definition from Transformations
Creating Target tables

Mappings

Working with Mappings
Connecting Mapping Objects
Linking Ports
Propagating Port Attributes
Working with Targets in a Mapping
Working with Relational Targets in a Mapping
Validating a Mapping
Using Workflow Generation Wizard

Mapplets

Understanding Mapplets Input and Output
Using Mapplet Designer
Using Mapplets in Mapping

Mapping Parameters and Variables
Working with User-Defined Functions
Using the Debugger

Creating Breakpoints
Configuring the Debugger
Monitoring the Debugger
Evaluating Expression

Creating Cubes and Dimensions
Using Mapping Wizard
Naming Conventions

Performance Tuning Module

Performance Tuning Overview

Bottlenecks

Using Thread Statistics
Target Bottlenecks
Source Bottlenecks
Mapping Bottlenecks
Session Bottlenecks
System Bottlenecks

Optimizing the Targets
Optimizing the Source
Optimizing the Mapping
Optimizing the Transformations
Optimizing the Sessions
Optimizing thePowerCenter Components
Optimizing the System
Using Pipeline Partitions
Performance Counters

Repository Module

Understanding the Repository
Using Repository Manager
Folders
Managing Object Permissions
Working with Versioned Objects
Exporting and Importing Objects
Copying Objects

Transformation Module

Working with Transformations

Configuring Transformations
Working with Ports
Working with Expressions
Reusable Transformations

Aggregator Transformation
Custom Transformation
Expression Transformation
External Transformation
Filter Transformation
Joiner Transformation
Java Transformation
Lookup Transformation
Lookup Caches
Normalizer Transformation
Rank Transformation
Router Transformation
Sequence Generator Transformation
Sorter Transformation
Source Qualifier Transformation
SQL Transformation
Stored Procedure Transformation
Transaction Control Transformation
Union Transformation
Update Strategy Transformation

Transformation Language Reference

The Transformation Language
Constants
Operators
Variables
Dates
Functions
Creating Custom Function

Workflow Basics Module

Workflow Manager

Workflow Manager Options
Navigating the Workspace
Working with Repository Objects
Copying Repository Objects
Comparing Repository Objects

Workflow and Worklets

Creating a Workflow
Using Workflow Wizard
Assigning an Integration Service
Working with Worklets
Working with Links

Sessions

Creating a Session Task
Editing a Session
Pre- and Post- Session Commands

Session Configuration Objects
Tasks

Creating a Task
Configuring Tasks
Working with Command Task
Working with Decision Task
Working with Event Task
Working Timer Task
Working with Assignment Task

Sources

Configuring Sources in a Session
Working with Relational Sources
Working with Flat Sources

Targets

Configuring Targets in a Session
Working with Relational Targets
Working with File Targets
Reject Files

Validation

Validating Tasks
Validating Worklets
Validating Session
Validating Workflows

Scheduling and Running Workflows

Scheduling a Workflow
Manually Starting a Workflow

Sending Email

Working with Email Tasks
Working with Post-Session Email

Workflow Monitor

Using Workflow Monitor
Customizing Workflow Monitor Options
Working with Tasks and Workflows
Using Gantt Chart View and Task View

Workflow Monitor Details

Integration Services Properties
Workflow Run Properties
Worklet Run Properties
Session Task Run Properties
Performance Details

Session and Workflow Logs

Log Events
Log Events Window
Working with Log Files
Workflow Logs

Note : Lab sessions for all the points mentioned above will be taken.

DATA WAREHOUSING SYLLABUS

Evolution of Datawarehousing – History
The need of Datawarehousing
Why Datawarehousing
What is Datawarehousing – The Definition

Subject -Oriented
Integrated
Non – Volatile
Time Varying

Datawarehousing Architecture

Data Source Layer
Data Extraction Layer
Staging Layer
ETL Layer
Data Storage Layer
Data Logic Layer
Data Presentation Layer
Metadata Layer
System Operation Layer

Dimension table
Fact table

Additive Facts
Semi Additive Facts
Non – Additive Fact
Cumulative
SnapShot

Attribute
Hierarchy
Types of Schema

Star Schema
Snow Flake Schema
Fact Constellation Schema

Slow Changing Dimension

SCD1 – Advantages/ Disadvantages
SCD2 – Advantages/ Disadvantages
SCD3 – Advantages/ Disadvantages

OLAP and OLTP

Difference between OLAP and OLTP
Types Of OLAP
Multi-Dimensional (MOLAP)
Relational(ROLAP)
Hybrid(HOLAP)

Enquire Now

Why Radical Technologies

Live Online Training

Highly practical oriented training

Installation of Software On your System

24/7 Email and Phone Support

100% Placement Assistance until you get placed

Global Certification Preparation

Trainer Student Interactive Portal

Assignments and Projects Guided by Mentors

And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Live Classroom Training

Weekend / Weekdays / Morning / Evening Batches

80:20 Practical and Theory Ratio

Real-life Case Studies

Easy Coverup if you missed any sessions

PSI | Kryterion | Redhat Test Centers

Life Time Video Classroom Access ( coming soon )

Resume Preparations and Mock Interviews

And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Self Paced Training

Self Paced Learning

Learn 300+ Courses at Your Own Time

50000+ Satisfied Learners

Course Completion Certificate

Practical Labs Available

Mentor Support Available

Doubt Clearing Session Available

Attend Our Virtual Job Fair

10% Discounted Global Certification

Course completion certificate and Global Certifications are part of our all Master Program

Like the Curriculum ? Let's Get Started

Global Certification

Radical Technologies is the leading IT certification institute in Kochi, offering a wide range of globally recognized certifications across various domains. With expert trainers and comprehensive course materials, it ensures that students gain in-depth knowledge and hands-on experience to excel in their careers. The institute’s certification programs are tailored to meet industry standards, helping professionals enhance their skillsets and boost their career prospects. From cloud technologies to data science, Radical Technologies covers it all, empowering individuals to stay ahead in the ever-evolving tech landscape. Achieve your professional goals with certifications that matter.

Online Classroom PREFERRED

Live Classes from IIT Faculty & Industry Experts
Certification from IHUB IIT Roorkee
Career Services (Mock Interviews, Resume Preparation)
Placement Assistance upon clearing PRT
Dedicated Learning Manage

Discount Voucher

"Register Now to Secure Your Spot in Our Featured Course !"

BOOK HERE

career services

Job Assistance
Interview Preparation
Profile Buliding

At Radical Technologies, we are committed to your success beyond the classroom. Our 100% Job Assistance program ensures that you are not only equipped with industry-relevant skills but also guided through the job placement process. With personalized resume building, interview preparation, and access to our extensive network of hiring partners, we help you take the next step confidently into your IT career. Join us and let your journey to a successful future begin with the right support.

At Radical Technologies, we ensure you’re ready to shine in any interview. Our comprehensive Interview Preparation program includes mock interviews, expert feedback, and tailored coaching sessions to build your confidence. Learn how to effectively communicate your skills, handle technical questions, and make a lasting impression on potential employers. With our guidance, you’ll walk into your interviews prepared and poised for success.

At Radical Technologies, we believe that a strong professional profile is key to standing out in the competitive IT industry. Our Profile Building services are designed to highlight your unique skills and experiences, crafting a resume and LinkedIn profile that resonate with employers. From tailored advice on showcasing your strengths to tips on optimizing your online presence, we provide the tools you need to make a lasting impression. Let us help you build a profile that opens doors to your dream career.

Radical Learning Eco-System

Exam simulator

Cloud Send Borey

Hands - on Cloud Lab

Developer Coding Ground

Testimonials

Play

Our Alumni

Online Batches Available for the Areas

INFORMATICA 10.X DEV + ADMIN Course Certification with Training in Kochi

At Radical Technologies, we are committed to providing world-class Azure Data Engineer Training in Bangalore, helping aspiring data professionals master the skills needed to excel in the rapidly growing field of cloud data engineering. As the leading institute for Azure Data Engineer Course In Bangalore, we offer comprehensive, hands-on training designed to meet the demands of today’s data-driven organizations.

Our Azure Data Engineer Training Bangalore program covers every aspect of the Azure Data Engineer Syllabus, ensuring that students receive in-depth knowledge of data architecture, data processing, and data storage on Microsoft Azure. Whether you prefer attending classes in-person or via Azure Data Engineer Online Training, Radical Technologies provides flexible learning options to suit your needs.

Our Azure Data Engineering Training is renowned for its practical, real-world approach. Students have access to an industry-leading Azure Data Engineer Bootcamp, which combines theory and hands-on labs to ensure they are fully prepared for their certification exams. The Microsoft Azure Data Engineer Training is tailored to cover all key topics, from data integration to security, and is led by experienced professionals who are experts in their field.

For professionals and organizations seeking Azure Data Engineering Corporate Training, we offer tailored courses that address specific business needs. Our Azure Data Engineering Corporate Training Course ensures that teams gain practical experience in building scalable, secure, and efficient data solutions on Azure.

At Radical Technologies, our Azure Data Engineer Courses are structured to ensure that both beginners and experienced professionals alike can enhance their knowledge. The Azure Data Engineer Certification Training offered here equips students with the skills and credentials needed to stand out in a competitive job market.

Our institute also offers the Azure Data Engineer Full Course, which provides a comprehensive pathway for mastering Azure Data Engineering concepts and techniques. We take pride in being one of the top Azure Data Engineer Institutes in Bangalore, with a proven track record of helping students achieve their Azure Data Engineering Certification.

Whether you are looking for Azure Data Engineer Training Online or prefer our in-person classes in Bangalore, Radical Technologies is your trusted partner for career advancement in data engineering. Join us today to enroll in the Best Azure Data Engineer Course and kick-start your journey towards becoming a certified data engineer.