Informatica is existing and has huge demand everywhere.
Competition is high due to its scope in the future. Informatica is software the company which deals with enterprise cloud data management and data integration.
Informatica tool is used to build enterprise data warehouses.
We hope these Informatica interview questions and answers are
useful and will help you to get the best job in the networking industry. This
Informatica interview questions and answers are prepared by Informatica
Professionals based on MNC Companies expectation. which, in turn, would enable
you to brush your knowledge about Informatica concepts in an easier way.
onlineitguru supports
the students by providing Informatica interview questions and answers for the
job placements and job purposes.
The best
Informatica Interview Questions and Answers
1. What is
INFORMATICA? Why do we need it?
INFORMATICA is a software development firm which offers some
data integration solution for ETL, data virtualization, master data management,
data quality, data replica, ultra messaging, etc.
Some of the popular INFORMATICA products are:
INFORMATICA PowerCenter
INFORMATICA PowerConnect
INFORMATICA Power Mart
INFORMATICA Power Exchange
INFORMATICA Power Analysis
INFORMATICA Power Quality
We need INFORMATICA while working with data systems which
contain data to perform certain operations along with a set of rules. INFORMATICA
facilitates operations line cleaning and modifying data from structured and
unstructured data systems.
2 What is
Enterprise Data Warehousing?
When the data of an organization is developed at a single point
of access, it is known as enterprise data warehousing.
Enterprise Data Warehousing is the data of the organization
being created or developed at a single point of access. The data is globally
accessed and viewed through a single source since the server is linked to this
single source. It also includes the periodic analysis of the source.
What is ETL
and what are ETL Tools?
ETL is a process of Extract, Transform and Load the data into
DataWarehousing in the required format for decision-making.
ETL TOOLS:
IBM Datastage
Informatica PowerCenter
Abinitio
Talend Studio etc.
4. What is
Informatica PowerCenter Tools?
Informatica PowerCenter had 2 types of Tools:
Server Tools: Administrator Console, Integration Service
Client Tools: Repository Manager, Designer, Workflow Manager,
Workflow Monitor.
5. What the difference
is between a database, a data warehouse, and a data mart?
The database includes a set of sensibly affiliated data which is
normally small in size as compared to the data warehouse. While in data warehouse
there are assortments of all sorts of data and data is taken out only according
to the customer's needs. On the other hand, datamart is also a set of data which
is designed to cater to the needs of different domains. For instance an
organization having a different chunk of data for its different departments i.e.
sales, finance, marketing, etc.
6. What is
meant by a domain?
When all related relationships and nodes are covered by a
sole organizational point, its called domain. Through this data management can
be improved.
7. What is the
difference between a repository server and a powerhouse?
Repository server controls the complete repository which
includes tables, charts, and various procedures, etc. Its main function is to
assure the repository integrity and consistency. While a powerhouse server
governs the implementation of various processes among the factors of the server's
database repository.
8. How many
repositories can be created in Informatica?
There can be any number of repositories in Informatica but
eventually, it depends on the number of ports.
9. Which are
the different editions of INFORMATICA PowerCenter that are available?
Ans: Different editions of INFORMATICA PowerCenter are:
Standard Edition
Advance Edition
Premium Edition
The current version of PowerCenter available is v10 with a
high-performance increase.
10.
What are the different Components of PowerCenter?
Ans: Given below are the 7 important components of
PowerCenter:
PowerCenter Service
PowerCenter Clients
PowerCenter Repository
PowerCenter Domain
Repository Service
Integration Service
PowerCenter Administration Console
Web Service Hub
11.
What is the difference between a data warehouse, a
data mart and a database?
Data warehouse consists of different kinds of data. A
database also consists of data but however, the information or data of the
database is smaller in size than the data warehouse. Data mart also includes
different sorts of data that are needed for different domains. Examples -
Different dates for different sections of an organization like the sales,
marketing, financing, etc.
12.
What are the typical use cases for Informatica?
https://onlineitguru.com/blog/what-typical-use-cases-informatica
13.
What is Cloud Data Masking In Informatica?
The Data Masking transformation returns different values when
the same source value occurs in different rows. You can define masking rules
that affect the format of data that the Data Masking transformation returns. In
random masking, numeric, string, and date values can be masked
14.
Which All Databases PowerCenter Server On Windows Can
Connect To?
Answer: PowerCenter Server on Windows can connect to
following databases:
IBM DB2
Informix
Microsoft Access
Microsoft Excel
Microsoft SQL Server
Oracle
Sybase
Teradata
15.
Explain the difference between the mapping parameter and
mapping variable?
When values change during the session's execution it's called
a mapping variable. Upon completion, the Informatica server stores the end value
of a variable and is reused when session restarts. Moreover, those values that
do not change during the execution of the session are called mapping parameters.
Mapping procedure explains mapping parameters and their usage. Values are
allocated to these parameters before starting the session.
16.
Where can we find the throughput option in
Informatica?
Throughput option can be found in Informatica in workflow
monitor. In workflow monitor, right click on the session, then click on get run
properties and under source/target statistics we can find throughput option.
17.
What is OLAP (On-Line Analytical Processing?
A method by which multi-dimensional analysis occurs.
18.
What are the different types of OLAP? Give an example?
ROLAP eg.BO, MOLAP eg.Cognos, HOLAP, DOLAP
19.
What are the different types of profiles in
Informatica?
20.
In Informatica, how many numbers of repositories are
possible to be made?
The total figure of repositories created in
Informatica mainly depends on the total amounts of the ports of the
Informatica.
Differentiate between a connected look up and
unconnected look up?
In connected lookup, inputs are taken straight away
from various transformations in the pipeline, it is called connected lookup.
While unconnected lookup doesn’t take inputs straight away from various
transformations, but it can be used in any transformations and can be raised as
a function using LKP expression.
21.
What is Transformation?
Ans: Transformation can be defined as a set of rules
and instruction that is to be applied to define data flow and data load at the
destination.
22.
Define Mapping?
It is a set of Source and Target definitions linked by
transformation objects that define the rules for transformation.
23.
What is Workflow Manager?
It is used to store workflow metadata and connection
object information in the repository. A wf contains sessions and different
tasks according to the requirement. Tasks can include session, email
notification, assignment task, decision task, etc. Each task in a wf needs to be
connected via links and also we can provide link task based on the
requirements.
24.
What is Workflow Monitor?
It is used to retrieve wf run status and session logs.
A wf is a set of instructions that tells an integration service on how to run the
tasks. Basically, WF monitor is used to monitoring workflows and tasks.
25.
What is session?
It is a set of instructions that describe how and when
to move the data from source to target.
26.
What are the different ways to filter rows using
Informatica transformations?
·
Source Qualifier
·
Joiner
·
Filter
·
Router
27.
What are the different transformations where you can
use a SQL override?
·
Source Qualifier
·
Lookup
·
Target
28.
What is Status Code in INFORMATICA?
Ans: Code provides Error Handling Mechanism during
each session. Status Code is issued by stored Procedure to recognize whether it
is committed successfully or not and provides information to the INFORMATICA
server to decide whether the session has to be stopped or continued.
29.
What is Decode in INFORMATICA?
Ans: To understand Decode in an easy way, let's
consider it as similar to the CASE statement in SQL. It is basically the
function that is used by an expression transformation in order to search a
specific value in a record.
There can be unlimited searches within the Decode
function where a port is specified for returning result values. This function
is usually used in cases where it is required to replace nested IF statements
or to replace lookup values by searching in small tables with constant values.
Decode is a function that is used within Expression
Transformation. It is used just like CASE Statement in SQL to search a specific
record.
Below is a simple example of a CASE in SQL:
Syntax:
SELECT EMPLOYEE_ID,
CASE
WHEN EMPLOYEE_AGE <= 20 THEN 'Young' WHEN
EMPLOYEE_AGE > 30 AND AGE <= 40 THEN
'Knowledgeable' WHEN EMPLOYEE_AGE > 40 AND AGE = 60
THEN ‘Wise’
ELSE ‘Very Wise’
END AS EMPLOYEE_WISDOM
FROM EMPLOYEE
3 What is parallel processing in Informatica?
After optimizing the session to its fullest, we can
further improve performance by exploiting underutilized hardware power. This
refers to parallel processing and we can achieve this in Informatica
PowerCenter using Partitioning Sessions.
The Informatica PowerCenter Partitioning Option
increases the performance of the PowerCenter through parallel data processing.
The Partitioning option will let you split the large data set into smaller
subsets which can be processed in parallel to get a better session performance.
31.
Mention few Power Centre client applications with
their basic purpose?
Ans: Tasks like session and workflow creation,
monitoring workflow progress, designing applets, etc are performed by
Powercentre client applications.
Enlisted below is the list of Power center client
applications with their purpose:
Repository Manager: It is an administrative tool and
its basic purpose is to manage repository folders, objects, groups, etc.
Administration Console: Here the service tasks like
start/stop, backup/restore, upgrade/delete, etc are performed.
Power center designer: The designer consists of
various designing tools which serve various purposes. These designing tools
are:
·
Source Analyzer
·
Target designer
·
Transformation Developer
·
Mapplet Designer
·
Mapping Manager
Workflow Manager: Its basic purpose is to define a set
of instructions/workflow that is required to execute mappings designed in the
designer. To help develop a workflow, there are 3 tools available, namely Task
developer, Workflow designer, Worklet Designer.
Workflow Monitor: As the name suggests, Workflow
monitor monitors the workflow or tasks. The list of windows available are:
·
Navigator Window
·
Output window
·
Time window
·
Properties window
·
Task view
·
Gantt chart view
32.
What are the different mapping design tips for
Informatica?
The different mapping design tips are as follows
-
Standards - The
design should be of a good standard. Following a standard consistently is
proven to be beneficial in the long run projects. Standards include naming
descriptions, conventions, environmental settings, documentation and parameter
files, etc.
Reusability - Using
reusable transformation is the best way to react to the potential changes as
quickly as possible. applets and worklets, these types of Informatica
components are best suited to be used.
Scalability
- It is important to scale while designing. In the development of
mappings, the volume must be correct.
Simplicity - It is
always better to create different mappings instead of creating one complex
mapping. It is all about creating a simple and logical process of design
Modularity - This
includes reprocessing and using modular techniques for designing.
Mention with the assistance of batches.
Converting data from a source to a target is
generally implemented by a teaching service and this is known as a session.
Usually, the session's manager executes the session. In order to combine the session’s
executions, batches are used in two ways - serially or parallelly.
33.
How many numbers of sessions are grouped in one
batch?
Any number of sessions can be grouped in one batch but
however, for an easier migration process, it is better if the number is lesser
in one batch.
34.
What are the mapping parameters and mapping variables?
In Informatica, Mapping parameter represents a constant value that we can define in parameter file before running a session.
Informatica mapping parameter retains the same value throughout the entire
session.
Unlike a mapping parameter, Informatica mapping
variable represents a value that can change throughout the session. The
integration service saves the value of mapping variable to the repository at
the end of the session run and uses that value next time we run the session.
35.
What are two types of processes that Informatica runs
the session?
Load Manager Process
DTM Process
36.
What is Pushdown Optimization?
We can push transformation logic to the source or
target database using pushdown optimization. When we run a session configured
for pushdown optimization, the Integration Service translates the
transformation logic into SQL queries and sends the SQL queries to the
database. The source or target database executes the SQL queries to process the
transformations.
Conclusion
I hope, by now you must have got a clear idea about
the tool and the type of questions that will be asked in interviews.
INFORMATICA is the best solution to perform Data
Integration. It works with Multi-data management in a multi-platform an environment such as Windows, Linux, Unix, etc.
I hope this Informatica Interview questions blog was of some
help to you. It tests your hands-on knowledge of working on Informatica tool.
You can go through Informatica training
Comments
Post a Comment