Informatica Interview Questions

Get Technical Answers for Informatica Interview Questions by Informatica Developer, Advanced Technical Questions for Freshers and Experience Persons. Free practical tests

1. 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.

2. 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 Certification Training

  • Master Your Craft
  • Lifetime LMS & Faculty Access
  • 24/7 online expert support
  • Real-world & Project Based Learning


3. 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.

Subscribe to our youtube channel to get new updates..!


4. 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 Certification Training

Weekday / Weekend Batches


5. 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.

6. What are types of data ware houses?

There are three types of data ware houses:

·              Enterprise data ware house

·              ODS(operational data store)

·              Data mart

7. What is data mart?

A data mart is a subset of data warehouse that is designed for a particular line of business, such as sales, marketing, or finance. In a dependent data mart, data can be derived from an enterprise wide data warehouse. In a independent data mart can be collected directly from sources.

8. What is Data warehouse?

According to Bill Inmon, known as father of Data warehousing. “A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management’s decision making process”.

9. What is star schema?

 A star schema is the simplest form of data warehouse schema that consists of one or more dimensional and fact tables.

10. What is snow flake schema?

                A Snowflake schema is nothing but one Fact table which is connected to a number of dimension tables, The snowflake and star schema are methods of storing data which are multidimensional in nature.

11. What are ETL Tools?

 ETL Tools are stands for Extraction, Transformation, and Loading the data into the data warehouse for decision making. ETL refers to the methods involved in accessing and manipulating source data and loading it into target database.

12. What are Dimensional table?

Dimension tables contain attributes that describe fact records in the fact table.

13. What is data Modelling?

Data Modeling is representing the real world set of data structures or entities and their relationship in their of data models, required for a database.Data Modelling consists of various types like :

Conceptual data modeling

Logical data modeling

Physical data modeling

Enterprise data modeling

Relation data modeling

Dimensional data modeling

14. What is Surrogate key?

Surrogate key is a substitution for the natural primary key. It is just a unique identifier or number of each row that can be used for the primary key to the table.

15. What is Data Mining?

 A Data Mining is the process of analyzing data from different perpectives and summarizing it into useful information.

16. What is Operational Data Store?

 A ODS is an operational data store which comes as a second layer in a datawarehouse architecture. It has got the characteristics of both OLTP and DSS systems.

17. What is the Difference between OLTP and OLAP?

OLTP is nothing but OnLine Transaction Processing which contains a normalised tables .

But OLAP(Online Analtical Programming) contains the history of OLTP data which is non-volatile acts as a Decisions Support System.

18. How many types of dimensions are available in Informatica?

There are three types of dimensions available are :

Junk dimension

Degenerative Dimension

Conformed Dimension

19. What are the designer tools for creating tranformations?

Mapping designer

Transformation developer

Mapplet designer

20. What is the maplet?

 Maplet is a set of transformations that you build in the maplet designer and you can use in multiple mapings.

21. What is Session and Batches?

Session: A session is a set of commands that describes the server to move data to the target.

Batch: A Batch is set of tasks that may include one or more numbar of tasks (sessions, ewent wait, email, command, etc).

22. What are slowly changing dimensions?

Dimensions that change overtime are called Slowly Changing Dimensions(SCD).

Slowly Changing Dimension-Type1 : Which has only current records.

Slowly Changing Dimension-Type2 : Which has current records + historical records.

Slowly Changing Dimension-Type3 : Which has current records + one previous records.

23. What are 2 modes of data movement in Informatica Server?

There are two modes of data movement are:

Normal Mode in which for every record a separate DML stmt will be prepared and executed.

Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.

24. What is the difference between Active and Passive transformation?

Active Transformation:An active transformation can change the number of rows that pass through it from source to target i.e it eliminates rows that do not meet the condition in transformation.

Passive Transformation:A passive transformation does not change the number of rows that pass through it i.e it passes all rows through the transformation.

25. What is the difference between connected and unconnected transformation?

Connected Transformation:Connected transformation is connected to other transformations or directly to target table in the mapping.

UnConnected Transformation:An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation.

26. What are various types of Aggregation?

Various types of aggregation are

·              SUM

·              AVG

·              vCOUNT

·              MAX

·              MIN

·              FIRST

·              LAST

·              MEDIAN

·              PERCENTILE

·              STDDEV

·              VARIANCE

27. What are Aggregator Transformation?

Aggregator transformation is an Active and Connected transformation. This transformation is useful to perform calculations such as averages and sums (mainly to perform calculations on multiple rows or groups).

28. What are Expression transformation?

Expression transformation is a Passive and Connected transformation. This can be used to calculate values in a single row before writing to the target.

29. What are Filter transformation?

Filter transformation is an Active and Connected transformation. This can be used to filter rows in a mapping that do not meet the condition.

30. What are Joiner transformation?

Joiner Transformation is an Active and Connected transformation. This can be used to join two sources coming from two different locations or from same location.

Submit an interview question


Request for more information


Python tutorial for beginners

5th April | 08:00 AM

150 Registered

servicenow developer
Praneetha is a Post Graduate in Computer Science from Andhra University .She is currently working as an IT developer at hkr And she has great experience includes both IT development and operational roles. Connect with her also on LinkedIn and Twitter. Thank you

To Top