Informatica

About The Course

Informatica Developer & Admin Course, can introduce the participants to work with the Power Center. Developers will use Informatica to create, execute, as well as administer, monitor and schedule ETL processes and understand how these are used in data mining operations. The course will also cover Installation & Configuration of Informatica and basic Administration Activities. Participants will also get to implement one project towards the end of the course.

Who should go for this course?

The following professionals can go for this course:

Software Developers

Analytics Professionals

BI/ETL/DW Professionals

Mainframe developers and Architects

Individual Contributors in the field of Enterprise Business Intelligence

Pre-requisites

The pre-requisites for this course include knowledge of SQL and basic UNIX.

Why learn Informatica?

Informatica provides the market’s leading knowledge integration platform. Tested on nearly 500,000 combinations of platforms and applications, the information integration platform lay operates with the broadest doable vary of disparate standards, systems, and applications. This unbiased and universal view makes Informatica unique in today’s market as a leader in the data integration platform. It also makes Informatica the ideal strategic platform for companies looking to solve data integration issues of any size.

Informatica Concepts and Overview

Data Warehousing concepts

ETL Concepts.

Informatica Architecture.

Power Center Tools

Designer

Repository Manager

Workflow Manager

Workflow Monitor

Basic Concepts and Components

Source Qualifier

Target Designer

Transformations

Mappings

Mapplets

Sessions

Tasks

Sources

Working with relational Sources

Working with Flat Files

Targets

Working with Relational Targets

Working with Flat file Targets

Transformations

Expression Transformation

Lookup Transformation

Sequence Generator Transformation

Filter Transformation

Joiner Transformation

Sorter Transformation

Router Transformation

Aggregator Transformation

Update Strategy Transformation

Union Transformation

Rank Transformation

Transaction Control Transformation

Normalizer Transformation

Source Qualifier Transformation

Stored Procedure Transformation

XML Source Qualifier Transformation

Debugging Mappings

Advanced Informatica Concepts

Unconnected lookup Transformation

Mapping Parameters

Mapping Variables

Target Load Plan

Defining Reusable Transformations.

Mapplets

Tasks And Types of Tasks.

Worklet

Scheduling Workflow

Types of Batch Processing

Link conditions

Defining Session Parameters

PMCMD Utility

Types Of Lookup Caches

Static LookUp Cache

Dynamic LookUp Cache

Perisistance lookup Cache

Shared LookUp Cache

Task Types:

We record every live session we hold. Video recordings of each and every session will be posted on our blog too. So, this means you can get access to what the session is about and this way you do not miss any class. But take a note of it that you can have access to these Video recordings for 6 months only from the date you start your training. Access to these videos or to other required course material will be provided using Google Drive Cloud for lifetime.

We have a team of industry-expert instructors or trainers who possess 8-10 yrs. of relevant experience in various Business Technologies. Every instructor / trainer undergo our specialized training program called “Train the Trainer” at Xoomtrainings. Our trainers are trained so that our learners get a great learning experience.

Yes, classes at Xoomtrainings are conducted through online video streaming where there is two-way communication between users and instructors. The users can speak by using a microphone, chat by sending a message through a chat window and share their screens with an instructor. For better understanding, users can take the sample recorded class on this page to know of the quality of instruction and the way the class is conducted.

For your practical work, we will help you set up a Virtual Machine on your system with IDE’s. This will be local access for you. The detailed step-wise installation guides are present in your LMS which will help you install and set-up the environment for any course. In case, you come across any doubt, the 24/7 support team will promptly assist you through mail(support@xoomtrainings.in)or Phone (+91 -40-4018 3355)

Xoomtrainings is the largest online education company and a large number of recruitment firms contacts us for our student’s profiles from time-to-time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placement. However, if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

You will get 24/7 access to the blog to post your questions. Trainers will answer your questions through email within 24 hrs. of time. Also, our support team will help you 24/7 through mail(support@xoomtrainings.in)or Phone (+91-40-4018 3355 ,7093502091,92 ).

Xoomtrianings enjoys strong relationship with multiple staffing companies in US, UK and India. If you are looking out for exploring Placement opportunities, you can pass your resumes once you complete the course and we will help you with job assistance. We don’t charge any extra fees for passing the resume to our partners and clients