Informatica Interview Questions

Informatica Interview Questions

  • What are the advantages of Informatica?

Informatica has some advantages over other data integration systems. A couple of the advantages are:

It is faster than the available platforms.
You can easily monitor your jobs with Informatica Workflow Monitor.
It has made data validation, iteration and project development to be easier than before.
If you experience failed jobs, it is easy to identify the failure and recover from it. The same applies to jobs that are running slowly.

Informatica Interview Questions

  • In what real situations can Informatica be used?

Informatica has a wide range of application that covers areas such as:

Data migration
Application migration
Data warehousing

Informatica Interview Questions

  • What are some examples of Informatica ETL programs?

Some basic Informatica programs are:

Mappings: A mapping is designed in the Designer. It defines all the ETL processes. Data are read from their original sources by mappings before the application of transformation logic to the read data. The transformed data is later written to the targets.
Workflows: The processes of runtime ETL are described by a collection of different tasks are known as workflow. Workflows are designed in the Workflow Manager.
Task: This is a set of actions, commands, or functions that are executable. How an ETL process behaves during runtime can be defined by a sequence of different tasks.

  • Which development components of Informatica have the highest usage?

There are many development components in Informatica. However, these are the most widely used of them:

Expression: This can be used to transform data that have functions.
Lookups: They are extensively used to join data.
Sorter and Aggregator: This is the right tool for sorting data and aggregating them.
Java transformation: Java transformation is the choice of developers if they want to invoke variables, java methods, third-party API’s and java packages that are built-in.
Source qualifiers: Many people use this component to convert source data types to the equivalent Informatica data types.
Transaction control: If you want to create transactions and have absolute control over rollbacks and commits, count on this component to bail you out.

Informatica Interview Questions

  • What are the uses of ETL tools?

ETL tools are quite different from other tools. They are used for performing some actions such as:

Loading important data into a data warehouse from any source known as Target.
Extracting data from a data warehouse from any sources such as database tables or files.
Transforming the data received from different sources in an organized way. Some of the notable sources where data are received include SAP solutions, Teradata, or web services.

Informatica Interview Questions

  • What are the types of data warehouses

There are three types of data ware houses:

Enterprise Data Ware House
ODS(Operational Data Store)
Data Mart

  • What Is Informatica?

Informatica is a Software development company, which offers data integration products. If offers products for ETL, data masking, data Quality, data replica, data virtualization, master data management, etc.

Informatica Powercenter ETL/Data Integration tool is a most widely used tool and in the common term when we say Informatica, it refers to the Informatica PowerCenter tool for ETL.

Informatica Powercenter is used for Data integration. It offers the capability to connect & fetch data from different heterogeneous source and processing of data.

For example, you can connect to an SQL Server Database and Oracle Database both and can integrate the data into a third system.

The latest version of Informatica PowerCenter available is 9.6.0. The different editions for the PowerCenter are

Standard edition
Advanced edition
Premium edition
The popular clients using Informatica Powercenter as a data integration tool
are U.S Air Force, Allianz, Fannie Mae, ING, Samsung, etc. The popular tools
available in the market in competition to Informatica are IBM Datastage,
Oracle OWB, Microsoft SSIS and Ab Initio.

Informatica Interview Questions

  • Why do we need Informatica?

Informatica comes to the picture wherever we have a data system available and at the backend we want to perform certain operations on the data. It can be like cleaning up of data, modifying the data, etc. based on certain set of rules or simply loading of bulk data from one system to another.

Informatica offers a rich set of features like operations at row level on data, integration of data from multiple structured, semi-structured or unstructured systems, scheduling of data operation. It also has the feature of metadata, so the information about the process and data operations are also preserved.

  • In what real situations can Informatica be used?

Informatica has a wide range of application that covers areas such as:

Data migration
Application migration
Data warehousing

Informatica Interview Questions

  • Define Enterprise Data Warehousing?

When the data of organization is developed at a single point of access it is known as enterprise data warehousing.

  • What do you understand by a term domain?

Domain is the term in which all interlinked relationship and nodes are under taken by sole organizational point.

  • Differentiate between a repository server and a powerhouse?

Repository server mainly guarantees the repository reliability and uniformity while powerhouse server tackles the execution of many procedures between the factors of server’s database repository.
Informatica Interview Questions

  • Define sessions in Informatica ETL

Session is a teaching group that requires to be to transform information from source to a target.

  • In one group how many number of sessions can we have?

We can have any number of session but it is advisable to have lesser number of session in a batch because it will become easier for migration.
Informatica Interview Questions

  • What are the features of complex mapping?

The features of complex mapping are:
Many numbers of transformations
tricky needscompound business logic

  • How we can identify whether mapping is correct or not without connecting session?

With the help of debugging option we can identify whether mapping is correct or not without connecting sessions.

  • Can we use mapping parameter or variables developed in one mapping into any other reusable transformation?

Yes, we can use mapping parameter or variables into any other reusable transformation because it doesn’t have any mapplet.

  • What is the use of aggregator cache file?

If extra memory is needed aggregator provides extra cache files for keeping the transformation values. It also keeps the transitional value that are there in local buffer memory.

  • What is lookup transformation?

The transformation that has entrance right to RDBMS Is known as lookup transformation.

  • What do you understand by term role playing dimension?

The dimensions that are used for playing diversified roles while remaining in the same database domain are known as role playing dimensions.
Informatica Interview Questions

  • Define Joiner transformation?

It combines two associated mixed sources located in different locations while a source qualifier transformation can combine data rising from a common source.

  • How we can use Union Transformation?

It is a different input group transformation that is used to combine data from different sources.

  • Define mapplet?

A mapplet is a recyclable object that is using mapplet designer.

  • What is surrogate key?

It is a substitute for the natural prime key. It is a unique identification for each row in the table.
Informatica Interview Questions

  • Define a session task?

It is a mass of instruction that guides power center server about how and when to move data from sources to targets.


This information box about the author only appears if the author has biographical information. Otherwise there is not author box shown. Follow YOOtheme on Twitter or read the blog.
+91 9952948899