Informatica Training in Chennai

Informatica Training in Chennai “Informatica” is a tool, supporting all the steps of Extraction, Transformation and Load process. Now a days Informatica is also being used as an Integration tool. Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases. Informatica can communicate with all major data sources (mainframe/RDBMS/Flat Files/XML/VSM/SAP etc), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement only. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.

Informatica Training Course Duration: 60 Hrs.

Informatica Training Mode: Class Room/On-line.

Informatica Training Methodology: Real-time Project oriented.

Informatica Training Prerequisites

Basic Knowledge of Data Base.
No domain experience reqd.
Can be studies for freshers.

Informatica Training Features:

Trainers from Corporate
Unlimited Lab facility
Valid Materials(Soft/Hard Copy)
Resume Preparation and Mock Interview
100% Placement Assistance
Free Counseling

Topics Covered

Introduction to Data Warehousing

  • Scope of Data warehouse project in business application
  • Data warehouse Architecture and Design
  • Slow Change  Dimension 1
  • Slow Change  Dimension 2
  • Slow Change  Dimension 3
  • OLTP
  • OLAP
  • ODS
  • Master Table
  • Detail Table
  • Dimension Table
  • Fact Table
  • Data Mart
  • Passive and Active Transformers

 

  • DB Concepts
  • DML
  • DDL
  • DCL
  • JOINS
  • Informatica and Data warehousing
  • Informatica Architecture
  • Informatica Server
  •  ETL concepts

 

  • Repository Manager
  • Creating Repository
  • Managing the Repository
  • ODBC DSN creation
  • Designing the ETL
  • Understanding The After-Design Scenario
  • Specifying the Database Connections
  • Advanced Informatica
  • Troubleshooting Informatica

 

  • Power Center Design
  • Source Analyzer
  • Warehouse Designer
  • Mapping Designer
  • Mapplets Designer
  • Transformations in Informatica
  • Importing sources and Targets
  • Source Qualifier Transformation
  • Filter Transformation
  • Expression Transformation
  • Aggregator Expression
  • Router Transformation
  • Union Transformation
  • Update Strategy Transformation
  • SQL Transformation
  • Lookup Transformation
  • Rank Transformation
  • Sequence Generator
  • Creating, Configuring and Linking Ports
  • Joiner Transformation
  • Sorter Transformation
  • Using Informatica Manager

 

  • Workflow Manager
  • Understanding Jobs and Scheduler
  • Session
  • Command Task
  • Email Task
  • Task Developer

 

  • Workflow Monitor
    • Session Logs
    • Workflow Logs

 

  • Informatica and Unix
  • Informatica and Teradata
  • Informatica and Salesforce.com

AMEKS Infotech

33.26, Jawaharlal Nehru Road, Ekkattuthangal, Chennai-600032. Landmark: Opposite to Hyundai Showroom. Behind Ambal Nagar Bus Stop. Phone:044 43563040, 50.

Are you located in any of these areas – Adyar, Ambattur, Aminjikarai, Adambakkam, Anna Nagar, Anna Salai, Ashok Nagar, Besant Nagar, Choolaimedu, Chromepet, Egmore, Ekkattuthangal, Guindy, K.K.Nagar, Kilpauk, Kodambakkam, Madipakkam, Medavakkam, Mylapore, Nandanam, Nanganallur, Nungambakkam, OMR, Pallikaranai, Perungudi, Porur, Saidapet, Sholinganallur, St. Thomas Mount, T. Nagar, Tambaram, Teynampet, Thiruvanmiyur, Thoraipakkam,Vadapalani, Velachery, Villivakkam, Virugambakkam and West Mambalam.

Our GUINDY, AMBAL NAGAR office is just few kilometer away from your location. If you need the best SAP Training in Chennai Guindy, Ambal Nagar, driving couple of extra kilometers is worth it!

 


Informatica  Placements & Training

register icon Ab Initio Training in Chennai


 

 

Related Searches :

Informatica Training in Chennai, Informatica Training Institutes in Chennai, Informatica Training Centers in Chennai, Informatica Course in Chennai, Best Informatica Training in Chennai, Corporate Training for Informatica, Online Training Informatica, Informatica training in Chennai with placement, Real Time Informatica training in Chennai, Informatica training Institute in Chennai, Best Informatica Training Institute in Chennai, Informatica Training Center in Chennai, Best Informatica Training Center in Chennai, Informatica Course in Chennai, Best Informatica Course in Chennai, Informatica Certification training in Chennai, Informatica Training, Informatica Online Training in Chennai, Informatica Training in Chennai

About admin

Currently Working in SAP as Consultants 10+ Yrs Experience in SAP Implementation Projects Exceptional Experience in Support and Rollout Projects