Greens Technology Informatica training in Chennai

Posted by Dinesh Jaganathan
1
Education & Training
Aug 30, 2015
371 Views
Informatica Training in Chennai

Learn ETL and data mining concepts and best practices using Informatica PowerCenter Designer covering Development Techniques, Error Handling, Data Migration and Performance Tuning


About The Course

Greens Technologys Informatica training in Chennai, will introduce the participants to work with the PowerCenter. Developers can 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 PowerCenter 9.X and basic Administration Activities. Participants will also get to implement one project towards the end of the course.

Course Objectives

After the completion of the Informatica course at Edureka, you will be able to : 
1. Understand and identify different Informatica Products 
2. Describe Informatica PowerCenter architecture & its different components
3. Use PowerCenter 9.x components to build Mappings, Tasks, Workflows
4. Describe the basic and advanced features functionalities of PowerCenter 9.X transformations
5. Understand Workflow Task and job handling
6. Describe Mapping Parameter and Variables
7. Perform debugging, troubleshooting, error handling and recovery
8. Learn to calculate cache requirement and implement session cache
9. Execute performance tuning and Optimization
10. Recognize and explain the functionalities of the Repository Manager tool.
11. Identify how to handle services in the Administration Console
12. Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation
13. Gain insight on ETL best practices using Informatica


Who should go for this course?

The following professionals can go for this course :
1. Software Developers
2. Analytics Professionals 
3. BI/ETL/DW Professionals
4. Mainframe developers and Architects
5. Individual Contributors in the field of Enterprise Business Intelligence Best Informatica training in Chennai

Pre-requisites

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

Project Work

Towards the end of the Course, you will be working on a live project to perform data analytics.
 
Project #1 : Creation of Sales Data Warehouse 
Industry : Retail 
Data : NorthWind/AdventureWorks dataset. 
Problem Statement : Creation of ETL jobs to build Sales Data Mart using Informatica. 

Project #2 : Transaction Analysis for Retail
Industry : Retail 
Data : Sales data from Real time retail project. ( Data will be masked) 
Problem Statement : Analyzing Retail Transaction Information using Informatica.

Why learn Informatica?

Informatica provides the market's leading data integration platform. Tested on nearly 500,000 combinations of platforms and applications, the data integration platform inter operates with the broadest possible range 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 Training in Chennai

Our Informatica Training in Chennai aims to teach the complete Data Warehousing Concepts in a easier way. We are the Best Informatica Training Institute in Chennai in-terms of syllabus and expert teaching. We are covering almost all the transformations which is required for companies in Informatica.

Informatica one of the most widely used ETL tools for data warehousing and business intelligence. This is the tool that provides DW solution to more than 70% of all DWBI projects today. Informatica is emerging in the market and overcoming all challenges of DWBI compared to any of its competitors.

If you are looking forward to a promising career in DWBI look no further this is your tool and we are your destination.

Informatica is one of the fastest growing ETL tools and is way ahead in terms of market and business than any other ETL tool today.

Here at GreensTechnologies we will help you master this tool with interactive sessions. The advantage of mastering Informatica here is that, the sessions will be covered by faculty working in live ETL projects thus giving you an insight into how this ETL tool used in today’s business.

So if you are looking for a promising IT career for a long time, then look no further, ETL is your answer and Greens Technologies is your solution.

Please feel free to contact us for any further queries and we will connect you with our faculty.

Informatica Training Syllabus

Data Warehouse Introduction

Power Center Components

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Power Center Admin Console

Informatica Concepts and Overview

  • Informatica Architecture.

Sources

  • Working with relational Sources
  • Working with Flat Files

Targets

  • Working with Relational Targets
  • Working with Flat file Targets

Transformations – Active and Passive Transformations

  • Expression
  • Lookup –Different types of lookup Caches
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Rank
  • Router
  • Aggregator
  • Source Qualifer
  • Update Strategy
  • Normalizer
  • Union
  • Stored Procedure
  • Slowly Changing Dimension
    • SCD Type1
    • SCD Type2 — Date, Flag and Version
    • SCD Type3

Workflow Manger

  • Creating Reusable tasks
  • Workflows, Worklets & Sessions
  • Tasks
    • Session
    • Decision task
    • Control Task
    • Event wait task
    • Timer task
  • Monitoring workflows and debugging errors

Indirect Loading

Constraint based load ordering

Target Load plan

Worklet ,Mapplet ,Resuable transformation

Migration –XML migration and Folder Copy.

Scheduling Workflow

Parameter and variables

XML Source, Target and Transformations

Performance Tuning

  • Pipeline Partition
  • Dynamic Partition
  • Pushdown optimization

We have weekly demo classes for Informatica, do feel free to give us a call and drop in.



Comments
avatar
Please sign in to add comment.
Advertise on APSense
This advertising space is available.
Post Your Ad Here
More Articles