Informatica Training/

beginners level through to advanced level

Call/

+91 81486 07745

Home > Courses Offered > DataWare housing Training > Informatica Training

Informatica Training in Chennai with Placement

Informatica Training in Chennai

What is Informatica ?

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 is one of the leading data integration software available in the IT market today.

Each passing day, more and more companies are joining the Informatica band wagon for achieving Data Warehousing through ETL.

Informatica is 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 Core Mind Technologies 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 Core Mind Technologies is your solution.

Please feel free to contact us for any further queries and we will connect you with our faculty.
Our Informatica Training Institute is located in Chennai T.Nagar and Anna Nagar fully filled with real-time faculties and top consultants in IT sector.
So, If you want to learn, its a great opportunity for you. Please Contact Us. We will give you clear structure before joining with us.

INFORMATICA POWERCENTER 8.X/9.X

    Informatica Overview

  • History of Informatica
  • Opportunities of Informatica
  • Other ETL tools
  • Power center Administration
  • Informatica Power center architecture
  • Power center components
  • ETL Plan
  • Power center Clients
  • Designer
  • Workflow manager
  • Work Flow monitor
  • Workflow manager
  • Repository manager
  • Power center repository
  • Administrative tool
  • Repository services
  • Integration services
  • Power center domain
  • Application services
  • Concept of nodes and grid
  • Service manager
  • Power center administration console
  • Repository Administration
  • Creating Repository Users and Groups.
  • Connecting to the Repository.
  • Creating a Group
  • Assigning Privileges to a Group.
  • Creating a User
  • Creating a Folder
  • Folder Permissions

DESIGNER

  • Types of Transformations
  • Connected and Unconnected Transformations
  • Active and Passive Transformations
  • Creating Source Tables
  • Creating Target Definitions
  • Creating Target Tables
  • Creating source definitions
  • Creating a Mapping
  • Connecting Transformations
  • Transformation Creation
  • Importing sources and targets (database objects)
  • Importing sources and targets (flat files and XML files)
  • Using Transformations
  • Aggregator Transformation
  • Expression Transformation
  • Lookup Transformation (Connected and Un Connected)
  • Union Transformation
  • Joiner Transformation
  • Filter Transformation
  • Sequence Generator Transformation
  • Stored Procedure Transformation
  • Source Qualifier Transformation
  • Router Transformations
  • Rank Transformations
  • Update Strategy Transformation
  • XML Transformation
  • SQL Override in source qualifier Transformation and lookup Transformation
  • Connecting the Target
  • Connecting Transformations
  • Creating a Mapping
  • Completing the Mapping
  • Creating a Pass-Through Mapping
  • Creating a Mapping with SCD Type 1 and SCD Type 2
  • Creating a Mapping with Aggregate Values
  • Target load order plan
  • Mapping wizards
  • Reusable Transformation
  • Mapplet overview and usage

WORKFLOW MANAGER

  • Creating the Session
  • Creating the Workflow
  • Using the workflow manager
  • Creating Sessions and Workflows
  • Constraint base loading
  • Configuring Database Connections in the Workflow Manager
  • Creating a Reusable Session
  • Creating a Workflow
  • Running and Monitoring Workflows
  • Opening the Workflow Monitor
  • Workflow Tasks
  • Session
  • Assignment task
  • Link task
  • Event raise task
  • Event wait task
  • Timer task
  • Post session and Pre-session commands
  • Session recovery
  • Commit points
  • Creation of Parameter file
  • Mapping and session parameter
  • Performance tuning in ETL
  • Various optimization techniques
  • Pushdown optimization
  • Incremental aggregation

WORKFLOW MONITOR

  • How to monitor loads
  • Uses of Workflow monitor
  • Monitoring the jobs
  • How to get Session Logs and Workflow Logs

Real time Questions and Answers

Real time scenarios

Exercises for each Transformation

Datawarehousing Concepts

Core Mind Technologies5 Star Rating: Recommended Rated 5/5
based on 8648 reviews
Just Dial   

Sulekha   
Facebook   
Google+   
Yet5   

Training Courses

Testimonials

"I learned QTP and Selenium testing at Core Minds Technologies & i learnt lots of things in both functional and automation. Now i am working as a TEAM LEAD on both automation and Manual. This entire credit goes to Core Minds Technologies team. Even they are supporting the people after completion of course. Thank you very much to all Core Minds Technologies members"

"Joined for Oracle DBA course and continued for ETL Tools training as well. Now, I am completely confident enough in my subject. I never thought ORACLE is SO BIG and huge!!!Loved learning it for about three months and quite chappy now..."

"Every session is great and very valuable..its like aanimuthyalu! I want to say again n again we all are lucky to have you as the Oracle coach. I learnt a lot from Core Mind Technologies on SQL and PLSQL side. Tnx. I salute you from bottom of my heart for being such an amazing mentor..."

"I joined “Core Mind Technologies” because of their proven expertise in Testing and Quality Assurance. Here, I learnt the Magic of Testing. The constant and personal interaction with the Trainer, Live Projects, Certification Training and Study material are the best part. The trainers are extremely proficient in their knowledge and understanding of the topics. The instructors I had were both skillful and possessed the knowledge required to present the material to the classes..."