Click to rate this post!
[Total: 2 Average: 3]

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.

to our newsletter

Drop Us A Query

Trending Courses
  • oracle 12c rac | OnlineITGuru
    Oracle RAC Training
  • Oracle is the large vendor in providing the various storge services to the people across the globe. This vendor provides a different amount of storage services to the people across the globe.

  • salesforce lightning training | OnlineITGuru
    Salesforce Lightning Training
  • Developing an application is not a simple and easy task. There are various parameters that the web developer need to take care while developing an application. One of those parameters that the developer needs to take care of is the code reusability.

  • Selenium with python
    Selenium with Python Training
  • As we know, that Selenium with Python Web Browser Selenium Automation is Gaining Popularity Day by Day. So many Frameworks and Tools Have arisen to get Services to Developers.

  • machine learning with python
    Machine Learning with Python Training
  • Over last few years, Big Data and analysis have come up, with Exponential and modified Direction of Business. That operate Python, emerged with a fast and strong Contender for going with Predictive Analysis.

  • Data science with R
    Data Science With R Training
  • Understanding and using Linear, non-linear regression Models and Classifying techniques for stats analysis. Hypothesis testing sample methods, to get business decisions.

  • data science with python
    Data Science with Python Training
  • Everyone starts Somewhere, first you learn basics of Every Scripting concept. Here you need complete Introduction to Data Science python libraries Concepts.


100% Secure Payments. All major credit & debit cards accepted.

Call Now Button