Best informatica training and placement institute in chennai/adyar

Best informatica training institute in chennai/adyar

àDINESH B.E.MIS(USA),OCMà9940516384

àPARTHIBAN M.C.Aà9840496320

About Greens Technologys

Greens Technologys is a Chennai based Software Firm. Our main focus areas are Software Training and Software Development. Greens Technologys started with the ambitious aim of providing QUALITY training to Students and Corporate. We are integrated as an organization of talented trainers having extensive expertise in all facts of providing quality training. 5000   IT Professionals got trained and placed in various MNCs.

How we are no1 in Training & Placements

• Real time Project Specific  training is the Key Success of Greens Technology’s and their Students.


• Trainer with certified technical skill set.


• Trainee Will be get Trained by Actual real world system.


• Trainee Will be the certified Professional end of the every training program.


• No hidden and commerical Training Cost.


• No marketing Strategy to converting Students , Such no false commitments like 100% Placement and Assurance.


• Trainee can closely with trainer until get complete their assignments or find better placements.


• Never charged for Resume preparation and Placement Trail software install on your laptop.


• Trainee can do lab assignment from home connecting to use our Advanced technologies such as cloud computing


• Students can attend multiple session with one time pay.


• Students never failed to get job in our past history.

Who can join Greens Technology’s

• Fresh Engineers who can challenge their IT career.


• Who worked in IT Industry and looking for their skills upgrade and certifications.


• Who really need a break through and their career change.


• People not worked in IT but can be a domain knowledge.


• Who interested to work in abroad.

About Informatica Training

Introduction to Data warehousing

Overview of a OLTP/Transactional system

Forms of Normalization

Pros/Cons of having an OLTP system in real time reporting.

Need of a data warehouse.

Data warehouse layer architecture.

Designing a warehouse using Star/Snowflake schemas.

Logical/Physical Models in Erwin

Introduction to Informatica/ETL tools

The role of ETL tools in data warehousing.

An introduction to Informatica

Informatica Architecture

Components/Process flow

Informatica Designer

Basic Concepts

Using the designer.

Working with the Sources-Source Analyzer

Working with Relational/Flat file targets- Warehouse Designer.

Defining Keys in Informatica.

Working with Transformations –Transformation Developer

Working with Mapplets- Mapplet designer.

Creating mappings –Mapping Designer.

Understanding Pipelines in mappings.

Setting Target Load order.

Configuring Constraint Based loading.

Introduction to Mapping Parameters/Variables.

Implementing Type1, Type2, and Type3 Mappings.

Loading Fact tables.

Working with Transformations

Active/Passive Transformations

Caching concepts in Informatica.

Connected/Unconnected Transformation

Importance of Source Qualifier.

Filter, Router

Expression

Sorter, Aggregator

Rank

Joiner

Lookup

Stored Procedure

Sequence generator

Union

Transaction Control

Update Strategy

Xml transformation

Normalizer

Creating Workflows

Understanding the server Architecture

Working with Workflows

Working with Tasks Assignment,Command,Decision,Control,Event raise,

Event Wait,Timer,Email,Session Task

Working with Work lets

Working with Sessions

Understanding Commit Points

Recovering Data

Monitoring Work flows

Using Multiple Servers

Log files

Row Error Logging

Session parameters

Parameter files

Using Incremental Aggregation

Real-Time Implementation with Informatica

Performance Tuning(With Real time Examples).

Using Incremental Aggregation

Extraction modes(Pull, Push).

Change Data capture concepts.

Incremental Extraction using control tables..

Session parameters and variables.

Session and Workflow properties Reference.

Pipeline partitioning.

Using Multiple Servers, Log files, Error, Row logging

Session Recovery.

Configuring Session caches lookup, Aggregate, Sort, Joiner caches.

Restart able Tables.

Reject Capture and Reprocessing.

Handling SoftHard Rejects.

Duration : 45 Working hours

Thanks

Greens Technologys,
No.15 First Street,Padmanabha nagar,
Adyar,
Chennai-20.

Best Regard’s

N.PARTHIBAN
Phone(M): +91 98404 96320
Phone(L): 044 43511623

eMail: greens.adyar@yahoo.com

www.greenstechnologys.com