Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.

What is the difference between mapping and mapplet in Informatica?

Answer»
Discussion
2.

What is a shared cache in Informatica?

Answer»
Discussion
3.

What are the types of lookup caches in Informatica?

Answer»
Discussion
4.

How can we improve the performance of Informatica mapping?

Answer»
Discussion
5.

What is Informatica PowerCenter?

Answer»
Discussion
6.

What is the use of a source qualifier in Informatica?

Answer»
Discussion
7.

What are the different types of cache in Informatica?

Answer»

In INFORMATICA, there are seven TYPES of CACHES:

  • DATA CACHE
  • Index Cache
  • Static cache
  • Dynamic cache
  • Persistent Cache
  • Re cache, also known as Refill Cache
  • Shared Cache.
Discussion
8.

How to run parallel sessions in Informatica?

Answer»

There is a flag in the workflow of Informatica to HELP you run parallel SESSIONS. Here are the steps to achieve it successfully:

  • Firstly, open the workflow monitor and click on the Edit Workflow/Worklet present in the right-click command menu for the workflow.
  • Now, inside the general tab, you must enable the to Configure Concurrent Execution property.
  • Lastly, open the Configure Concurrent Execution dialogue box. There shall be two options:

         a. Allow the concurrent run with the same instance name

            Here,the workflow name remains the same for each parallel execution.

        b. Allow the concurrent run only with a unique instance name.

            In this, you will have to create at least one instance name inside the lower half of the dialogue box. You can also specify the PARAMETER FILE for each Instance created.

 
Discussion
9.

What is the difference between $$$sessstarttime and sessstarttime in Informatica?

Answer»
S.no$$$SessStartTimeSESSSTARTTIME
1.Type of In-built variableAlso a type of in-built variable.
2.Returns the session START TIME as a string valueIt returns the session start time with DATE and date timestamp.
3.Generally used in SQ overrides.They were generally used in expressions.
Discussion
10.

What are the mapping parameters and variables in Informatica?

Answer»

Mapping parameters and variables basically represent values in mappings and mapplets.

Mapping Parameters

  • They are used to represent a static VALUE which can be defined before STARTING a session.
  • It has the same value throughout the entire session.

Mapping Variables

  • Here, the values change between the sessions.
  • The latest value of a mapping variable is SAVED by the INTEGRATION Service in the repository at the end of each session.
  • It can be used to override a saved value within a PARAMETER file.
Discussion
11.

What is the difference between a repository server and a powerhouse?

Answer»
S.noREPOSITORY ServerPowerhouse Server
1.It is used for controlling the complete repository containing tables, CHARTS, and other VARIOUS procedures.It is used for GOVERNING the IMPLEMENTATION of various processes on the factors in a repository server.
2.Its primary function is to maintain integrity and consistency within a repository.It is concerned with maintaining the workflows and sessions in a repository.
Discussion
12.

Why do we use Lookup Transformation in Informatica?

Answer»

Here are the following USES of Lookup Transformation in INFORMATICA:

  • To RETRIEVE a VALUE from the lookup table based on the value from the source.
  • To get multiple rows from a lookup table.
  • Retrieving a value and then using it for various calculations.
  • For relational or FLAT line lookup.
Discussion
13.

What is the difference between Joiner and Lookup transformation in Informatica?

Answer»
S.noJOINER TRANSFORMATIONLOOKUP TRANSFORMATION
1.It is usually USED for joining data from two more tables or source qualifiers.It is used on a single query or table record for searching records that match with incoming records.
2.The join type can be left, right, INNER or outer join.The Lookup can be connected or unconnected transformation.
3.It is used when the table SIZE is LARGE.It is used when the table size is not too large.
Discussion
14.

What are the different types of transformations in informatica?

Answer»

Based on CONNECTIVITY or number of rows, the TRANSFORMATIONS in Informatica can be classified as:
Based on Number of Rows:

  • ACTIVE Transformations
  • Passive Transformations

Based on Connectivity:

  • Connected Transformations
  • Unconnected Transformations

Besides that, here is a complete list of all the transformations PRESENT in Informatica

  • Source QUALIFIER Transformation
  • Aggregator Transformation
  • Router Transformation
  • Joiner transformation
  • Rank Transformation
  • Sequence Generator Transformation
  • Transaction Control Transformation
  • Lookup and Re-usable transformation
  • Normalizer Transformation
  • Performance Tuning for Transformation
  • External Transformation
  • Expression Transformation
Discussion
15.

What is the use of lookup in Informatica?

Answer»

In Informatica, the LOOKUP is basically a massive TRANSFORMATION that is used for looking up any source, source qualifier, or any TARGET for getting relevant data. To put it down simply, it is a type of JOIN operation where one of the JOINING tables is the data source, and the other is the lookup table.
Discussion
16.

How to remove duplicate rows in Informatica?

Answer»

If you want to delete DUPLICATE records then you can use this query.Example

Select rowNumber FROM tableName
WHERE rowNumber  
       IN (SELECT rowNumber
             FROM (SELECT rowNumber  
                        , ROWNUMBER() OVER(PARTITION BY C1,C2,C3) dup
                     FROM tableName)
            WHERE dup> 1 )
Discussion