Informatica Training in Chennai

Hope Tutors

Training

In Chennai (India)

Price on request

The best .Net and C# courses

See all

See all

Description

  • Type

    Training

  • Level

    Intermediate

  • Location

    Chennai (India)

  • Duration

    Flexible

  • Start date

    Different dates available

Informatica is successful ETL tool with significant way of transforming the data. ETL can be abbreviated as extract, transform, load.

There are plenty of job opportunities for Informatica professionals in India and abroad.

We at Hope Tutors have the best trainers who not only teach but also guide your career.

We are proud to say that Hope Tutors is a top-notch Informatica Training in Chennai. Our in-house trainers have trained and placed 100s’ of Informatica professionals. Our Informatica Training Course is 100% real-time with assured placement.

Facilities

Location

Start date

Chennai (India)
See map
600042

Start date

Different dates availableEnrolment now open

About this course

College Students
Freshers
Business Analysts
Analytics Managers
Information Architects

A recent study by the McKinsey Global Institute says that “a need for 1.5 million more managers and analysts with deep analytical and technical skills by 2018”
There is a huge demand for Informatica professionals across all industries

We will give you Informatica course certification under the name of Hope Tutors.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Introduction
  • Warehousing
  • Data
  • Transactional
  • System
  • Normalization
  • Reporting
  • Architecture
  • Star Schema
  • Schema
  • Flake
  • Informática
  • ETL tools

Course programme

COURSE CURRICULUM
  • Introduction to Data warehousing
  • Overview of an OLTP/Transactional system
  • Forms of Normalization
  • Pros/Cons of having an OLTP system in real time reporting.
  • Data warehouse layer architecture.
  • Star Schema
  • Snow Flake Schema
Introduction to Informatica/ETL tools
  • The role of ETL tools in data warehousing.
  • An introduction to Informatica
  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
Flat File Mapping
  • Designer and its usage.
  • Working with the Sources-Source Analyzer
  • Working with Flat file targets- Target Analyzer
  • Flat File to Flat File Mapping
  • Task / Session Creation
  • Work flow Creation and Execution
Relation Database Mapping
  • Working with the Sources-Source Analyzer
  • Working with Flat file targets- Target Analyzer
  • Flat File to Table Mapping
  • Table to Flat File Mapping
  • Table to Table Mapping
  • Task / Session Creation
  • Work flow Creation and Execution
Dimension Table Mapping
  • Active versus Passive Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Lookup Transformation
  • Sorter Transformations
  • Aggregator Transformations
  • Filter Transformation
Fact Table Mapping
  • Union Transformation
  • Source Qualifier Transformation
  • Joiner Transformation
  • Stored Procedure Transformation
  • XML Source Qualifier Transformation
  • External Procedure Transformation
  • Input Transformation (Mapplet)
  • Output Transformation (Mapplet)
  • Load Fact tables.
Slowly Changing Dimension
  • Implement Type1, Type2 and Type3 Mappings.
  • Normalizer Transformation
  • Rank Transformation
  • Router Transformation
  • Update Strategy Transformation
  • Advanced External Procedure Transformation

See related categories

Informatica Training in Chennai

Price on request

The best .Net and C# courses

See all

See all