Weekend Specials Offer - Upto 50% Off | OFFER ENDING IN: 0 D 0 H 0 M 0 S

Log In to start Learning

Login via

Post By Admin Last Updated At 2020-06-15
Informatica interview questions

You are right place, If you are looking for Informatica interview questions and answers, get more confidence to crack interview by reading this questions and answers we will update more and more latest questions for you…

  1. What is Informatica?

Informatica is a data integration and quality service tool.The purpose of Informatica ETL is to provide the users, not only a process of extracting data from source systems and bringing it into the data warehouse.

  1. What is ETL?

ETL is short for extract, transform, load. ETL is defined as a process that extracts the data from different RDBMS source systems, then transforms the data.The tools that execute these functions are called ETL tools.

  1. Why Informatica is best ETL tool?

Informatica claims have high ratio of successful deployment than any other ETL tools. Also its easiness to use and learn, features to connect with wide variety of source data and data types, re usable components  etc make it more favorite for ETL developers. Also its own scheduler is another advantage, where other ETL tools have to use an external scheduler.

  1. What are the advantages of using Informatica as an ETL tool over Teradata?

The most advanced and used data integration/ETL tool is Informatica. Aspirants looking to foray into database management and electing Informatica training should clearly understand the difference between Informatica and Teradata. Teradata is a database, used for storing large amount of data.

  1. What is the difference between Informatica and ETL?

Informatica is ETL tool so your question is ETL development/testing is good.

As you are working as a Java developer you have a explosure to collecting

the requirements and developing the code so better you go for development


Ab initio , Big-Data Spark are good ETL tools in present time.

Interested to learn ETL tools please go through informatica training or ETL testing training
  1. What is Informatica PowerCenter?

Informatica PowerCenter is one of the Enterprise Data Integration products developed by Informatica Corporation,used to build and manage PowerCenter objects like sour and Transformation.The PowerCenter server executes tasks based on work flow created by work flow managers.

  1. Define the Enterprise of Data Warehousing?

Data is harder to analyse when it is fragmented and/or is stored in multiple areas. An enterprise data warehouse (EDW) consolidates data from multiple sources,An enterprise data warehouse is a unified database that holds all the business information an organization and makes it accessible all across the company.

  1. What are the Components of PowerCenter?

Power Center Service

PowerCenter Clients

PowerCenter Repository

Power Center Domain

Repository Service

Integration Service

PowerCenter Administration Console

  1. How To Delete Duplicate Row Using Informatica?

Add a Lookup Transformation with Dynamic lookup cache and Source filter set to something like 1=2 - we don't want any data to be read by the lookup in fact.

Set up the Condition to compare all the ports you want to use to determine duplicates (eg. all but the surogate key)

Each new row instance will be assigned the NewLookupPort=1 value. Each subsequent instance (i.e. duplicate) will result in NewLookupPort=2.

Use Filter Transformation to discard all NewLookupPort=1 rows

Use Update Transformation to set DD_DELETE for all the other rows.

  1. examples of Informatica ETL programs?





  1. Why use ETL tools?

ETL tools give an advance and effective solution for data fragmentation issues. It will help your IT personnel to modify applications and data sources without the need of restructuring and integration layer that helps in simplifying regulatory reporting, improve customer engagement.

  1. Do I have any future in ETL tool?


Informatica - Its highly used ETL tool you can't go wrong with it but after knowing the basics ..then concentrate on the following. ILM - Informatica Life cycle Management , IDQ - Data Quality and data Cleansing , Informatica XML and Web Service, there a lot of opportunities.

its used by bigger organizations.

  1. The use of ETL tool in Informatica?

Any ETL tool extracts data from the required source , applies business rules to it and transforms it and loads into the target.

In informatica ETL tools are power center designer and informatica cloud.

ETL is the concept (one vague example like RDBMS is the concept and oracle is the vendor)

There are many players in the market who offers ease and best tools to carry out ETL processes smoothly. Informatica, is one such tool.

  1. Define sessions in Informatica ETL.

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

  1. How can we create Index after completion of Load Process?

 Command Tasks are used to create Index. Command Task scripts can be used in a session of workflow to create an index.

  1. What is workflow?

The workflow includes a set of instructions which allows the server to communicate for the implementation of tasks.

  1. What is Joiner Transformation in Informatica?

Joiner transformation is an active and connected transformation that provides you the option to create joins in Informatica.

  1. Define workflow and work-let informatica?

Worklet is a set of tasks. If a certain set of task has to be reused in many workflows then we use worklets. To execute a Worklet, it  has to be placed inside a workflow.

A workflow is an execution wrapper around tasks and/or worklets. WorkLet. A worklet is an object that represents a set of tasks.


SUBSTR Function is used to extract a portion of the string. General Syntax, SUBSTR is used primarily within the Expression Transformation in Informatica.

  1. Name the different types of OLAP? Write an example?

Different types of OLAP are ROLAP, HOLAP< DOLAP.

  1. What is a Dimensional Model?

Data Modeling :- It is a process of designing the database by fulfilling business requirements specifications.

  1. Name the different types of OLAP? Write an example?

Different types of OLAP are ROLAP, HOLAP< DOLAP.

  1. What is a Dimensional Model?

Data Modeling:- It is a process of designing the database by fulfilling business requirements specifications.

  1. What is the difference between a data warehouse and data base?

Data warehouses and databases are both relational data systems, but were built to serve different purposes. A data warehouse is built to store large quantities of historical data and enable fast, complex queries across all the data, typically using Online Analytical Processing.

-----------Best of Luck-----------
Note: Please leave your comment below, according to that we will update more and more information.