Informatica Interview Questions

Informatica: Introduction

Informatica is actually a power center. It is widely used as an information, extraction, transformation and loading tool. It is further used to build an enterprise data warehouse. The components, which are located within Informatica help in extracting data from its sources and further using it for business requirements. But in order to use the data for business requirements, you need to convert in firstly. And finally, the data is loaded onto a target data warehouse.

Informatica: Career Prospects

Informatica has got the widespread ability in terms of efficient data processing, data partitioning, and bulk extraction. This altogether contributes to the maximum and quality work at any large-scale organization. Almost maximum of business domains utilize Informatica tools and thus career prospects are endless in the field of Informatica. But in order to land up with a good job in Informatica, you need to successfully crack Informatica interview questions.

Cracking Informatica Interview Questions

Cracking Informatica interview questions is not exactly a rocket science. No doubt since the web world is rapidly evolving, there are more and more challenges about the Informatica field. And you need to understand that you will not be ever able to know it all. What you need to do is brush up your foundation. Try to know and understand your basics. Clear up the basic know-how of Informatica and this will help you to a get an upper hand at the Informatica interview. Also, be open and honest about what you know and what you don’t know. This will give a clear picture in the mind of interviewers. But you must display a learning attitude. Make sure that you always tell the interviewer that you are willing to learn new things and incorporate new skills which will further help you in your personal and professional growth.

Following are the list of some Informatica Interview Questions and their answers.

#1 What is a surrogate key?

A surrogate key is a unique Identification key and acts as natural primary key .it is unique for each row of the table that why it is very useful to identify each unique row.

#2 Do you find any difficulty while working with flat files as source and target?

Yes, there are difficulties I found while working with flat file some of them are:
  1. We can’t use SQL override in flat files instead of that we have to use transformations.
  2. testing the flat files is very uninteresting job
  3. We need to specify the correct path in the session and mention either that file is ‘direct’ or ‘indirect. Keep that file in the exact path which we have specified in the session and we have to keep the file in the exact path as mentioned in the session.
  4. If we miss the link to any column of the target, then all the data will be placed in wrong fields. That missed column won’t exist in the target data file.

#3 In how many ways we can create ports?

We can create ports in two ways  by Dragging the port from another transformation and another by clicking the add port button on the ports tab

#4 What is Domain in terms of Informatica?

Domains are primary component Of Informatica power center, it is used for managing and administrating various services in Informatica power center.

#5 What is the Rank index port in Rank transformation?

Rank transformation is an active and Connected transformation. it is used to select bottom or top rank of data this means to select the smallest or largest numeric value in a group or port. rank index port used by Informatica server to store the rank position for each record A Designer can create a rank index port automatically for each rank transformation.For Example, if you create a Rank Transformation that ranks the top 10 products for each quarter, then the rank index numbers products from 1-10.


PMCMD(power Mart Command) is a built-in command line program or utility that is used to interact with the Informatica server .this Command mainly used to perform the following tasks.
  • Scheduling a workflow
  • Start or stop workflow
  • Start workflow from a task
  • Stopping / Aborting specific task
  • Aborting workflow

#7 What is Data Caches/ Index Caches?

Index cache contains all of the port values which satisfies the given condition those are stored in index cache data cache stores port values which are not satisfies the given condition is stored in a data cache.

#8 How can we handle two sessions in Informatica?

In Informatica Linking more than one session called batches, there are two types of batches
  • Sequential batches: sequential batches session runs one by one
  • Concurrent batch: concurrent batches session runs at the same time

#9 Explain sessions and how many types of sessions are there?

A session is a set of instructions which explains the movement of data from source to target.
There are two type of sessions in Informatica
  • Reusable Sessions
  • Non-Reusable  Sessions

#10 What are the static cache and dynamic cache in Informatica?

In the static cache, the cache memory will not refresh even though the record is inserted or updated in the lookup table it will refresh when in next session run.
In dynamic caches, cache memory will refresh as soon as the record is inserted or updated in the look-up table.

#11 What is data transformation manager Process?

The Integration Service process starts the data Transformation Manager (DTM)process when the workflow reaches a session.DTM process is also known as the PMDTM process. The main purpose of the DTM process is to create and manage threads that carry out the session tasks.

#12 Can you generate sequence numbers without using the sequence generator transformation?

Yes, we can generate sequence numbers with expression transformation instead of the sequence generator transformation. Also Prepare: Frequently Asked Tally interview questions

#13 What is different between the data warehouse and data mart?

A Data Mart Is a simple form of a data warehouse that is focused on a single subject or functional areas such as sales or finance or marketing.
A Data warehouse is a collection of multiple functional is the central unit which is made by combining all the data marts

#14 What is the fact table?

Fact table is the centralized table in a star schema that’s why it is also called central table. Fact table mainly contains the facts nothing measurement (values)that is related to the data in the dimension table. it typically has two types of columns one contains facts(values) and another contains foreign keys to dimension tables. a composite key that is made by all of its foreign keys is acts as a primary key of a fact table.

#15 Could you explain what is Enterprise data warehouse?

In enterprise data warehousing all organization data is created at a single point of access .data can be provided a global view to the server through a single source storage.we can do periodic analysis on the same takes time but it gives better results.
Ask a Question