Informatica Training

Informatica Training in Bangalore

Do you want to learn Informatica? You’ve come to the right place. At Dsm Infotech , we offer a wide range of computer language training programs as well as corporate training programs. We have a team of experienced and expert trainers who will provide the right support and guidance. Our training course is custom designed to meet the stringent requirements of the corporate world. At Dsm Infotech , we understand the huge gap between college curriculum and the work place requirements. That’s why we design training programs that will allow you to master the concepts and put them into practical applications in the lab classes. We also give you real-time projects that will give you a clear picture of the challenges you can expect to face in any work environment. We are one of the few Informatica training institutes in Bangalore where students can learn theoretical concepts and practical applications in the course program.

The virtual world is literally built on tons of data. From understanding customer requirement to making smart decisions, data analysis and management plays a vital role. Informatica is an efficient software platform that enables business analysts to integrate and analyze big data. The software platform architecture is designed in a manner that enables simultaneous sharing and multiple use. The various components of this software platform are tools, data repository, and server. The developer uses the tools to map, execute, and administer data. All the relevant data is sorted and stored in the data repository while all the data execution tasks are done in the server. The expert trainers at Dsm Infotech will help you clearly understand the various concepts and tools of this software platform.

Dsm Infotech is one of the renowned Informatica training institutes in Bangalore. We offer round-the-clock support for students. The course work is framed to give you the best knowledge and exposure to this software platform. We offer regular, fast track, and online course programs and you can choose one depending on your time constraints. We also offer placement assistance for students who have completed the certification program. You can apply for job profiles such as Informatica ETL lead, data warehouse engineer, IT application developer, business intelligence engineer, data warehouse consultant, and data base application developer. So, what are you waiting for? Contact the professionals in our training institute and set up an appointment for a consultation.

Get In Touch

Informatica Course Syllabus

 
Introduction to Informatica
  • Basic Definitions
  • Informatica Products
  • Informatica Architecture
  • Tools and their roles
  • Folders -sub Folders
  • Power Center I Power Malt
  • Introduction to designer
Informatica Designer -Introduction
  • Designer interfaces
  • Designer tools
  • Defining Sources
  • Database as a source
  • Rat Flies sources
  • Defining Targets
  • Importing from database
  • Creating a new target
  • Creating target database objects
  • Mapping Introduction
Informatica Designer
  • Source Qualifier
  • Ports
  • Mapping -Table to Table
  • Mapping flat File to Table
  • Connected/Unconnected Transformations
  • Active and Passive Transformation
  • Source Qualifier Transformation
  • SQl Override-Source Qualifier Transformation
Mapping Source Qualifier as Filter
  • Source qualifier to join Data
  • Filter Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Router Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Stored procedure Transformation (Connected & Unconnected)
  • Union Transformation
  • XMl Transformation
  • Mapping Wizards
  • Implementing Type-I, Type-II, Type-III Mappings
Workflow Introduction
  • Informatica – workflow Manager Task
  • Workflow tools
  • Connections
  • Defining tasks
  • Command Task
  • Email Task
  • Session Task
  • Link Conditions
  • Event Wait & Event Raise
  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow
  • Incremental Aggregation
Informatica Advanced Features
  • Mapplet Implementation
  • Target Load Plan
  • Constraint based Loading

    To Get Complete Course Information