...

+91 78994 89468 | 78994 89384

Informatica Training in BTM, Marathahalli, Bangalore & Best Informatica Training Institutes in Bangalore

About Informatica Training

Techie Zone is a leader in Providing Informatica Training Courses located in BTM Layout, Bangalore based on real-time scenarios and placement oriented topics. Our Informatica training course covers basic to advanced levels. Our team consists of highly qualified and certified trainers who are working professionals with hands on real time Informatica projects knowledge. This  which will provide you an edge over other training institutes.

We provide certification training programs in Informatica Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our Informatica training center is well equipped with lab facilities and excellent infrastructure for providing you real time training experience.

Techie Zone provides regular training classes(day time classes), weekend training classes, and fast track training classes for Informatica Training in our Training Centers located in BTM Layout, Bangalore. Students can Enroll and start attending classes as well as practice sessions in the labs without effecting their regular college or office work. We also provide Online Training Classes for Informatica Training Course.

Our team of experts at Techie Zone Training Institute, Bangalore have designed our Informatica Training course content and syllabus based on students requirements to achieve everyone's career goal.  Our Informatica Training course fee is economical and tailor-made based on training requirement.
 
Contact us today to schedule a free demo and complete course details on Informatica Training Course.


Informatica Training Course Content

Informatica training course content and Syllabus in Bangalore

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
  • (i) Database as a source
  • (ii) 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
  • (i) Command Task
  • (ii) Email Task
  • (iii) Session Task
  • (iv) Link Conditions
  • (v) 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
  • Mapping Parameters
  • Mapping Variables



Reviews for Informatica Training Course

No Reviews for this Course Yet.. Be the First to Review?

Interview Questions

1.      What is a control task?

2.      What is a pipeline partition and how does provide a session with higher performance?

3.      What is the maximum number of partitions that can be defined for in a single pipeline?

4.      Pipeline partitions is designed to increase performance, however list one of it’s disadvantages?

5.      What is a dynamic session partition?

6.      List three dynamic partitioning configurations that cause a session to run with one partition

7.      What is pushdown optimization?

8.      List the different types of pushdown optimization that can be configured?

9.      What databases are we able to configure pushdown optimization?

10.   List several transformations that work with pushdown optimization to push logic to the database?

11.   What is real-time processing?

12.   What types of real-time data can be processed with Informatica PowerCenter?

13.   What is a real-time processing terminating condition?

14.   List three real-time processing terminating conditions?

15.   What is real-time processing message recovery?

16.   What factors play a part in determining a commit point?

17.   List all configurable commit types?

18.   What performance concerns should you be aware of when logging error rows?

19.   What functionality is provided by the Integration Service when error logging is enabled?

20.   What is the difference between stopping and aborting a workflow session task?

21.   What is a concurrent workflow?

22.   What is Informatica PowerCenter grid processing and its benefits?

23.   List the types of parameters and variables that can be defined within a parameter file?

24.   With PowerCenter, what two locations can one specify a parameter file?

25.   How are mapplet parameters and variables defined withing a parameter file different?

26.   What is an SQL Transformation in Informatica?

27.   What is dynamic lookup cache?

28.   What is a Unstructured Data transformation?

Quick Contact