+91 8197 102 102 | 8970 70 4000
Informatica Training

|  185   Reviews

Informatica Training Institutes in Bangalore & Best Informatica Training Institutes in Bangalore

Best  INFORMATICA  training institute ecare technologies bangalore,  provides real-time and placement oriented INFORMATICA   training in Bangalore. ecaretechnologies provides Best INFORMATICA   training courses in bangalore . ecare  INFORMATICA    training  course content designed basic to advanced levels. we have a team of INFORMATICA     experts who are working professionals with hands on real time INFORMATICA projects knowledge, which will give students an edge over other Training Institutes. INFORMATICA   training  course content is designed to get the placement in major MNC companies in bangalore as soon as you complete the INFORMATICA   training course.

Best INFORMATICA  training institute in Bangalore focus on the needs of the INFORMATICA  community. Ecare technologies listed one of the top INFORMATICA training institutes in Bangalore. We offer INFORMATICA   education for working professionals. INFORMATICA   training in Bangalore understands the need of INFORMATICA  community. we offer all INFORMATICA    training courses as students option. Ecare technologies provides free INFORMATICA  training materials of soft copy and hard copy. Discover best INFORMATICA  training in Bangalore at Ecare technologies
Our INFORMATICA  training courses helps to students to get placement immediately after course completion. Our practical ,real time INFORMATICA  project scenarios training helps to work on INFORMATICA projects. Our INFORMATICA   training program helps every student to achieve their goal in INFORMATICA career.

Best Training Institute,ecare technologies,Marathalli  Bangalore offers  training with choice of multiple training locations across bangalore. Ecare technologies INFORMATICA   training  centers are having Best lab facilities and excellent infrastructure. we have successfully trained and provided placement for many of our Trained INFORMATICA    students, INFORMATICA  training  training course fee is very economical compared to other Training Institutes In Bangalore

INFORMATICA  Training In Bangalore ,ecaretechnologies provide regular training classes,Morning Batches,Evening Batches, weekend training classes, and fast track training classes for INFORMATICA . Ecaretechnologies provides online and Corporate training classes for INFORMATICA 

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

Popular Interview Questions for Informatica Training

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?

29.   How to Join 2 tables connected to a Source Qualifier w/o having any relationship defined .

30.   In a mapping if three are 2 targets to load header and detail, how to ensure that header loads first then detail table.

31.   A mapping just take 10 seconds to run, it takes a source file and insert into target, but before that there is a Stored Procedure transformation which takes around 5 minutes to run and gives output ‘Y’ or ‘N’. If Y then continue feed or else stop the feed. (Hint: since SP transformation takes more time compared to the mapping, it shouldn’t run row wise).

32.   What is difference between view and materialized view?

33.   What is bitmap index why it’s used for DWH?

34.   What is star schema?  And what is snowflake schema?

35.   Why need staging area database for DWH?

36.   What are the steps to create a database in manually?

37.   Difference between OLTP and DWH?

38.   What is the significance of surrogate key?

39.   What is slowly changing dimension. What kind of scd used in your project?

40.   Row will you handle this situation?

41.   What is difference between primary key and unique key constraints?

42.   What are the types of index? And is the type of index used in your project?

43.   A  table have 3 partitions but I want to update in 3rd partitions how will you do?

44.   When you give an update statement how memory flow will happen and how oracles allocate memory for that?

45.   Write a query to find out 5th max salary? In Oracle, DB2, SQL Server

46.   When you give an update statement how undo/rollback segment will work/what are the steps?

47.   What is DTM? How will you configure it?



Reviews of Informatica Training


"Just Completed my Informatica Training. By reference I joined ecaretechnologies. Trainer explained every concept in real time examples with many case studies. Thanks a lot for providing best trainer. "


 thank you for your valuable information http://www.rstrainings.com/informatica-online-training.html


 I work in top mnc, my friends refereed this institute for informatica etl tool. Training was good. Excellent infra



Chosen this institute to learn Informatica training. My Batch Informatica Trainer is very professional and I am getting good coaching from here. I am thankful to their service. Thanks to ecare Marathalli.



"I would like to recommend to the learners who wants to be Informatica just one place i.e., ecare. After several research with several Training Institutes I ended up with ecaretechnologies,marathalli. My Informatica trainer was so helpful in replying, solving the issues and Explanations are clean, clear, easy to understand. Best Training Institute for Informatica at marathalli "



"This is the best Informatica Training Center at Marathalli available at a very reasonable price. The course content, instructors and Management team are all very good. The Classroom sessions and Project classes make study enjoyable. This is one of the best institute for Informatica. "


Join Now

eCare Training Benefits
  • Real Time Trainers
  • 100% Placement
  • Small Training Batch
  • Flexible Timings
  • Practical Guidance
  • Excellent Lab Facility
  • Resume Preparation
  • Hands on Experience
  • Certification Support