Informatica free practice questions lets you to boost your confidence on nuances of informatica techonology.A great place for you to enhance your knowledge. Most Frequently asked Informatica Interview Questions and Answers: This article is covering the top Informatica MDM, PowerCenter, Workflow Manager, Workflow Monitor, Designer etc.

Below are the Top 100 Questions in Excel format. Kindly scroll Left to Right to View the answers and scroll down for more questions.


 

  
Question

  
Option 1

  
Option 2

  
Option 3

  
Option 4

  
Option 5

  
Correct Answer

 

  
What type of tool is Informatica?

  
ETL

  
OLTP

  
OLAP

  
Reverse Engineering

  
Data Modeling

  
1

 

  
Which database does not support user-defined return
  values?

  
Sybase     

  
Oracle 

  
Informix

  
SQL Server

  
Teradata

  
3

 

  
What is cache?

  
An area in Source database

  
An area in Target database

  
An area in Repository Server

  
An area in Informatica Server

  
An area in
  Memory

  
5

 

  
Which of the following are join types are there in
  informatica?

  
Normal  

  
Master Outer

  
Left Outer

  
Exclusive Outer

  
Right outer

  
1,2

 

  
In ASCI I mode for each character, how many bytes are
  required

  
1 byte

  
2 bytes

  
3 bytes

  
4 bytes

  
1 bit

  
1

 

  
Comparing with Informatica power center 5.1 and 6.1
  version, in 6.1 version, which transformations have been newly added?

  
Lookup & Union 

  
Sorter and sequence  
  

  
Transaction
  control & Sorter

  
Sorter & Union

  
Filter

  
3

 

  
XML stands for

  
Extended Mainframe Language 

  
Extended Markup
  language    

  
Enhanced Mainframe Language

  
Enhanced Markup Language

  


  
2

 

  
Which types of data movement modes does Informatica
  server supports?

  
ASCII

  
Unicode

  
Binary

  
Decimal

  
Hexadecimal

  
1,2

 

  
In what version of Informatica  FlatFile Lookup Is available.

  
Infa 5

  
Infa 6

  
Infa 7

  
All The Above

  


  
3

 

  
Which one of these are not terminologies related to
  Informatica

  
Drill down

  
Dimension

  
Mapping

  
Workflow

  
Session

  
2,3,4,5

 

  
Which of the following terms are applicable for
  Datawarehousing?

  
OLAP

  
OLTP

  
Dimension

  
Cube

  
Fact

  
1,3,4,5

 

  
What are the types of extractions available?

  
Full Extraction

  
Progressive Extraction

  
Incremental
  Extraction

  
Big Bang Extraction

  
Slow Extraction

  
1,3

 

  
Where is the Source and Target information stored?

  
Repository Server

  
Informatica Server

  
Specific Folder

  
Repository
  Database

  
Source and Target Database respectively

  
4

 

  
Informatica server holds two different values for a
  mapping Variable. What are they called as?

  
Start value/End value

  
Start
  Value/Current Value

  
Start Value/Persistent Value

  
Start Value/Active Value

  
No values are held

  
2

 

  
Where will the Informatica server store data until it
  completes Aggregate calculations?

  
Memory  

  
Repository Server Cache

  
Database   

  
Cache

  
Informatica Server Cache

  
3

 

  
Characters in the parameter file must be a subset of

  
Repository server code page   

  
Information
  Server code page 

  
Repository agent code page    

  
Informatica client code page 

  
Database Server Code Page

  
2

 

  
Informatica Server uses the following environment variable
  defined on the server plat form to locate the dynamic link library or shared
  object on window operating server

  
PATH  

  
LD_LIBRARY_PATH

  
SHLIB_PATH       

  
LIBPATH 

  
LOGPATH

  
1

 

  
What will happen if the maximum number of sessions are
  reached

  
The new sessions enter into a queue and are run one by
  one

  
Failure or
  queuing can be controlled by another option

  
All the sessions will fail

  
All new sessions will fail

  
Server goes to a sleep mode untill sessions are
  manually terminated

  
2

 

  
What will happen if the maximum number of sessions are
  reached

  


  


  


  


  


  


 

  
What are different ways Null can be handled by
  Informatica in comparisons?

  
Null cannot be
  used for comparisons

  
Treated as Null

  
Treated as a Low/High value

  
Determined at runtime

  
Determined by the database

  
2,3

 

  
By enabling the Enhanced security option, the following
  permissions are provided

  
Read/Write

  
Append

  
Execute

  
Overwrite

  
Override

  
1,3

 

  
External Stored procedure transformation object resides
  at

  
Repository Server

  
Informatica Server

  
Repository
  Database

  
Informatica Client Machine

  
Database where Stored Procedure is present

  
3

 

  
Which of the following are the security options not
  avaialble in Repository Manager?

  
Manage Users

  
Manage Groups

  
Manage Folders

  
Manage Privileges

  
Manage
  Repository

  
3,5

 

  
Which of the following are false about Metadata
  Extensions

  
It is not a
  property of the object in which it is created

  
It appears on the Metadata extension tab of the each
  object of that type created

  
Metadata
  extension names need not be unique for each type of object in a domain

  
The datatype could be numeric (integer), string, or
  boolean

  
Metadata extension names must be unique for each type
  of object in a domain

  
1,3

 

  
By default how does the Informatica server treat NULL
  values in aggregator functions?

  
Zero      

  
NULL

  
Will throw an error message

  
Zero for Numeric, NULL for String variable

  


  
2

 

  
Where will you set the type of Update for an Update
  Strategy transformation?

  
In session                    

  
In mapping

  
In repository

  
In workflow

  
In task

  
2

 

  
Which of the following properties belong to update
  strategy transformation

  
Variable

  
Forward rejected
  rows

  
Data driven                                      

  
Tracing

  
SQL Override

  
2,4,5

 

  
If the lookup table is not changed in between sessions
  which cache is better to use?

  
Static

  
Index

  
Persistent  

  
Dynamic

  
Cached

  
3

 

  
If lookup transformation uses dynamic cache which
  operator we can use in lookup condition?

  
 =       
  

  
>=

  
 <=   

  
=>'

  
=<'

  
1

 

  
What will happen when the Informatica Server encounters
  multiple matches for a dynamic Lookup transformation

  
It returns all the results

  
It returns the first matching value

  
It returns an
  error

  
It returns the values one by one sequentially

  
Duplicate data will be deleted in the lookup table

  
3

 

  
What will happen if this condition is given as a filter
  condition?

  IIF(ISNULL(FIRST_NAME),FALSE,TRUE)

  (Assume FIRST_NAME is a column in a Database table)

  
All rows that
  have FIRST_NAME as NULL are filtered

  
All rows that do not have FIRST_NAME as NULLare
  filtered

  
Will result in an error when mapping is validated

  
All rows will be filtered

  
No rows will be filtered

  
1

 

  
What is the default Sorter Transformation Cache size

  
2000000 bytes

  
4000000 bytes

  
8000000 bytes

  
16000000 bytes

  
0 bytes

  
3

 

  
We use the Update Strategy transformation before or
  after the lookup, to flag rows for _____ to the target

  
Insert  

  
Update

  
Append

  
Reject

  
Override

  
1,2,4

 

  
When the stored procedure transformation is after the
  joiner transformation, the informatica server uses the database connection of
  the

  
Detail table   

  
Master table

  
Target table

  
1 or 2 (If existing in both the DBs, Master will be
  used)

  
2 or 3

  
2

 

  
All rows of data from the detail source and the
  matching rows from the master source are selected.This type of join called
  as?

  
Master-Outer

  
Normal

  
Detail-Outer

  
Full-Outer

  
Inner-Join

  
1

 

  
From the below which transformation cannot be reusable?

  
ERP Source
  Qualifier   

  
Dynamic lookup cache

  
Sequence Generator 

  
Aggregator

  


  
1

 

  
Where do you configure the Index and data cache of
  Aggregator transformation?

  
Session
  properties  

  
Aggregator
  transformation

  
Mapping properties

  
Changes can be
  made using Designer or Workflow Manager tool

  
Paramater Variables

  
1,2,4

 

  
Which of the data type is preferable when making
  comparisons using lookup And filter transformations?

  
Date

  
DateTime

  
Integer

  
String

  
Char

  
3

 

  
Find out the Active transformations?

  
Expression 

  
Filter

  
Lookup

  
Aggregator

  
XML Source Qualifier 

  
2

 

  
Find out the Passive transformation?

  
Source Qualifier

  
Rank

  
Aggregator

  
Router

  
Filter

  
3

 

  
We Use the Normalizer transformation with COBOL sources
  which are often stored in?

  
Demoralized Form

  
Normalized Form

  
Hierarchical Form

  
Referential Form

  
Textual Form

  
1

 

  
Which transformation is designed to handle data read
  from COBOL sources

  
 Union  

  
Router

  
Advanced External Procedure

  
Normalizer

  
Filter

  
4

 

  
Assume your
  source table has a column EmployeeID, and you want to include the
  EmployeeName in your target. In this case which Transformation will you use?

  Assume mapplets are not used in this Repository

  
Update strategy

  
Stored procedure

  
Lookup

  
Joiner

  
Filter

  
3

 

  
What is the use
  of Variable port?

  
To improve the performance

  
To reduce time

  
To store
  intermediate results

  
To parameterise values in a mapping

  
Used in mapplets for reusability

  
3

 

  
Which of these groups are Router Transformation
  supported Groups?

  
Variable Group 

  
User defined
  Group    

  
Dynamic Group

  
Static Group

  
Custom Group

  
2

 

  
Which Transformation won’t allow addition of any port?

  
Custom

  
Union    

  
Sequence  

  
Mid Stream XML Parser

  
Aggregator

  
3

 

  
What is the default join that Source qualifier
  provides?

  
Inner join

  
Outer join

  
Inner equi join

  
Inner non-equi join

  
Outer equi join

  
3

 

  
What is the default join in the joiner transformation?

  
Normal    

  
Outer join 

  
Inner

  
Full Outer

  
Exclusive

  
1

 

  
Which one is correct for the following example?

  The total commission of employees who exceeds their quarterly quota?

  
Sum (commission,
  commission > quota)

  
Sum (commission, commission >=quota)

  
Sum (commission, commission > quota=)

  
Sum (commission, commission => quota)

  
Sum (commission, commission <= quota)

  
1

 

  
If we do not set the cycle option in sequence generator
  what happens when it reaches maximum value?

  
Starts from initial value

  
Does not effect the session

  
Session
  fails  

  
Decrements from maximum value

  
Mapping is invalidated

  
3

 

  
In my source there are two fields entry date and apply
  date i want to reject  the data if the
  entry date is after the apply date for this which expression correct

  
IIF ((ENTRY_DATE >=APPLY_DATE), DD_REJECT,
  DD_Update)

  
IIF ((ENTRY_DATE <= APPLY_DATE), DD_UPDATE,
  DD_REJECT)

  
IIF ((ENTRY_DATE
  > APPLY_DATE), DD_REJECT, DD_UPDATE

  
IIF ((ENTRY_DATE =>APPLY_DATE), DD_REJECT,
  DD_Update)

  
IIF ((ENTRY_DATE =< APPLY_DATE), DD_UPDATE,
  DD_REJECT)

  
3

 

  
To verify the target tables and disk space on the
  target system, Stored procedure must be the type of

  
Source pre-load

  
Target pre-load 

  
Source post-load                 

  
Target post-load

  
Source commit-load

  
2

 

  
What is the purpose of SQL Override in a Source
  Qualifier?

  
Joining 2 or
  more homogenous sources

  
Peform cross-platform joins

  
Joining 2 or more heterogenous sources

  
To change column order of source

  
To eliminate duplicate data

  
1

 

  
A transformation has the following ports:

  Port_1: String, Input port; Port_2: String, Input port; Port_3: String,
  Output port

  Which of the expressions shown below would be valid?

  Assume that it is associated with Port_3 and that the string ENDSTRING is no

  
Port_1|| Port_2
  || 'ENDSTRING' 

  
Port_1 || Port_2 || "ENDSTRING" 

  
Port_1 || Port_2 || ENDSTRING 

  
CONCAT(Port_1, CONCAT(Port_2, "ENDSTRING")) 

  


  
1

 

  
A transformation has the following ports: 

  Port_1: Decimal, Input port; Port_2: Decimal, Input port; Port_3: String,
  Input port; Port_4: Decimal, Output port; Port_5: Decimal, Output port. 

  Which of the expressions shown below would be invalid?

  
IIF ( Port_1 > 5, Port_2 * 10, Port_2 * 15 ) 

  
IIF ( Port_1 > 5, Port_1 * 10,Port_1 * 20)

  
IIF ( Port_5 > 7, Port_5 * 10, Port_5 * 15 ) 

  
IIF ( Port_2 > 8, Port_2 * 10, Port_2 * 15 ) 

  
IIF ( Port_3
  > 8, Port_3 * 10, Port_3 * 15 ) 

  
5

 

  
When can we use a connected Lookup?

  
Does not support UserDefined Values

  
DynamicCache is
  possible

  
Returns
  MultipleColumns

  
DynamicCache is not possible

  
If rows are to
  be passed to a Filter or Router transformation directly

  
2,3,5

 

  
When using Mapping Designer, what are all the
  Transformations that cannot be used in a Mapplet?

  
Sequence
  Generator

  
Sources

  
Aggregator

  
Targets

  
Normaliser

  
1,4,5

 

  
How is the Pre and Post SQL Commands validated?

  
By the Designer

  
Cannot be
  validated

  
By the Workflow Manager

  
Validated when session is created

  
Validated at run time by Informatica Server

  
2

 

  
Baed on a flag (0 or 1) either Insert or Update has to
  be done on a Target.

  What are the ways in which this can be best achieved?

  
Use Router
  Transformation

  
Use Filter Transformation

  
Group the data using Aggregator and send to target

  
Use Update
  Strategy and use the flag for setting the condition as DD_UPDATE or DD_INSERT

  
Write two mappings and filter data using source
  qualifier

  
1,4

 

  
._____means the row will not have SQL Written for it

  
DD_INSERT     

  
DD_REJECT

  
DD_UPDATE 

  
DD_DELETE

  
DD_APPEND

  
2

 

  
Which of the following properties you can change for a
  newly added Source column without invalidating a mapping:

  
Data type 

  
Table Name

  
Redefines 

  
Key constraints

  
Column Name

  
1,3,4

 

  
When you import the Source definition, which of the
  following source metadata you import?

  
Source name

  
Triggers

  
Column Names

  
Key Contraints

  
Indexes

  
1,3,4

 

  
When you import a COBOL source, the Designer scans the
  file for which of the following components?

  
Target

  
Source

  
Redefines

  
Fields

  
Occurs

  
3,4,5

 

  
You can create
  Transformations in designer using

  
Mapping
  Designer  

  
Source Analyzer

  
Mapplet Designer

  
Transformation
  Developer

  
Warehouse Designer

  
1,3,4

 

  
Which of the
  following are tools of Designer?

  
Source Analyzer

  
Session Developer

  
Task Developer

  
Warehouse
  Designer

  
Mapping Designer

  
1,4,5

 

  
Designer is used
  for

  
Creating source
  and target definitions

  
Creating
  mappings

  
Create Folders and set privileges

  
Creating
  Mapplets

  
Creating Sessions and Workflows

  
1,2,4

 

  
Jumping from one
  transformation to any other transformation using the debugger can be done
  using

  
Step to instance                  

  
Next instance 

  
Break points

  
Forward instance

  
Break to Instance

  
1

 

  
Sources do not
  contain 

  
Input ports 

  
Output ports

  
Variable ports

  
Sorted ports

  
Metadata Extensions

  
1,3,4

 

  
Update the row
  if it exists,otherwise insert it.Which option is suitable for this one

  
Update as update                

  
Update as insert 

  
Delete 

  
Insert

  
Update as
  update/Insert as Insert

  
5

 

  
Which of the
  following tasks can we perform in the designer?

  
Create shortcuts

  
Export/Import
  Registry

  
Export and Import repository objects

  
Copy objects

  
Compare Folders

  
1,2,4

 

  
If the object is
  Target, then what are the dependencies that are displayed when "View
  Dependencies" is selected for it?

  
Target within
  the same folder that reference the target through a foreign key relationship

  
Shortcuts to the
  target

  
Mappings using
  the target

  
Mapplets using the target

  
Sources that are dependent on the target

  
1,2,3

 

  
I used a
  Sequence Generator in a mapping and I have done some testing on this
  particular mapping.In this particular Scenario, how I can set the sequence
  Generator to its Initial value?

  
Set the current
  value to 1        

  
Remove from
  mapping and recreate 

  
Cannot be reset

  
1,2

  
2,4

  
4

 

  
Variable ports are not visible in_____view

  
Normal 

  
Edit  

  
Debug

  
Read-only View

  
Full-screen View

  
1

 

  
----' is a set
  of source and target definitions linked by transformation Objects that define
  the rules for transformation

  
Session

  
Mapping

  
Workflow   

  
Worklet

  
Batch

  
2

 

  
What is Slowly changing dimensition?

  
To manage the
  data 

  
To manage the mapping

  
To manage the workflow 

  
To manage the Session

  
To manage Workflow monitor

  
1

 

  
How many types of techniques are there for SCD?

  
1

  
2

  
3

  
4

  
5

  
3

 

  
What is the default source option for update strategy
  transformation

  
Insert

  
Update 

  
Delete 

  
Data driven

  
Reject 

  
4

 

  
The Designer includes a "Find" search tool as
  part of the standard toolbar.What can be searched using the tool?

  
Persistent
  Values

  
Port Names

  
Source
  Definitions

  
Target
  Definitions

  
Descriptive Text

  
2,3,4

 

  
If a source is
  imported form a databases what all can be configured?

  
Owner Name

  
Database Type

  
Constraint Name

  
Index Name

  
Database Name

  
1,2,5

 

  
If a target is imported form a databases what all can
  be configured?

  
Constraint Name

  
Database Type

  
Index Name

  
Business Name

  
Nullability

  
2,4,5

 

  
A -------- is a set of transformations that you build
  in the Mapplet Designer and can use in multiple mappings

  
Session

  
Mapping

  
Workflow   

  
Mapplet

  
Batch

  
4

 

  
Which of the
  following is not possible while copying/moving columns from one source to
  another without connecting to database

  
Create a
  shortcut and rename it

  
Cannot be copied

  
Use the Copy columns option

  
Drag and drop
  columns into the new source

  
Use the Move columns option

  
1,2,4

 

  
Repository manager is not used for

  
Creating
  Sessions

  
User Administration

  
Creating Folders

  
Folder Administration

  
Creating Mapping

  
1,5

 

  
Where is the cache (lookup, index) created?

  
Cache directory

  
Informatica Repository

  
Session Logs directory

  
Workflow Logs Directory

  


  
1

 

  
Which of the following is true about Advanced external
  procedures

  
AEP
  transformations are connected transformations

  
AEP
  transformations cannot be referenced in an expression

  
AEP transformations can be referenced in an expression

  
AEP transformations are un-connected transformations

  
AEP can be
  created only using Transformation Developer

  
1,2,5

 

  
Disabling of high precision for numeric data converts
  data to which data type?

  
Integer

  
Decimal

  
Char

  
Double

  
Date

  
4

 

  
What happens to the session if the commit interval is
  too high and Informatica server fills the database log file?

  
Session waits for the Log to be cleared

  
Does not affect the session

  
Session fails

  
Session resumes once the log is cleared

  
Informatica Server hangs

  
3

 

  
Default location of the parameter file is 

  
$PMSourceFileDir

  
$PMCacheDir

  
$PMSessionLogCount

  
$PMSessionLogDir

  
$PMBadFileDir

  
1

 

  
Config object tab in a session properties includes ____
  settings

  
Commit  

  
Load

  
Reject

  
Commit on Insert

  
Commit on Update

  
1,2

 

  
Which tracing level of Informatica Server logs

  1. Initialization 

  2. Error message and 

  3. Notification of rejected data

  
Normal

  
Verbose Init

  
Verbose data              

  
Terse

  
Descriptive

  
4

 

  
Workflow manager displays a _______ Invalid Icon if the
  worklet instance in the  Workflow is
  invalid?

  
Red 

  
Blue

  
Yellow

  
Green

  
Black

  
2

 

  
You want to use the same session to extract transaction
  records for each of your customers individually. Which way is preferred?

  
Create a mapping
  parameter to represent a single customer account

  
Create individual sesion for each customer account

  
Create individual mappings and sessions for each
  customer account

  
Create mapplets

  
Create mapplets and worklets for re-using

  
1

 

  
Which of the
  following is not applicable for CONTROL task in workflow manager?

  
To send e-mails
  when session fails 

  
To stop the workflow that is running

  
To send alerts
  to the Notification Window

  
To fail a workflow that is running

  
To check the performance
  of session  

  
1,3,5

 

  
Which of the following is applicable for COMMAND task
  in workflow manager?

  
To check the performance of session

  
Allows Batch
  File to be executed

  
Allows Unix
  command to be executed

  
To send alerts to the Notification Window

  
Allows shell
  scripts to be executed

  
2,3,5

 

  
Which Threads are created in DTM process?

  
Master

  
Input, Output

  
Transformation

  
Mapping

  
Reader

  
1,2,4,5

 

  
Whether or not a Session Task can be considered to have
  heterogeneous targets is determined by 

  
The Mapping properties alone

  
The Session Task
  properties alone.

  
Either the Mapping properties or the Session Task
  properties

  
Either the Mapping properties or the Workflow properties.

  
Either the Mapping properties or the Workflow
  properties or Session Properties

  
2

 

  
How can we compare the mapping and mapplets of the same
  name belonging to different folders?

  
Mapping
  Designers

  
Mapplet
  Designers

  
Cannot be compared

  
Only by using a Repository Manager Compare

  
Workflow Manager

  
1,2

 

  
Which of the following tasks are re-usable?

  
Command

  
Control

  
E-mail

  
Session

  
Timer

  
1,3,4

 

  
Worklet variables are not used for 

  
Reference values                      

  
Record information 

  
Performance
  Tuning

  
Database
  Comparisons

  
Storing metadata
  extensions

  
3,4,5

 

  
Which of the
  following are applicable for Resuable tasks

  
Task instance
  can be edited using workflow designer

  
changes made to
  an instance is only applicable to the instance

  
changes made to an instance is propogated to the
  original task

  
Once an instance property is changed, the changes
  cannot be reverted

  
An instance
  property if changed, can be reverted

  
1,2,5

 

  
User defined worklet variables cannot be ______

  
Static

  
Dynamic

  
Persistent  

  
Non-Persistent  

  
Volatile

  
1,2,5

 

  
Which of the following objects you cannot include in a
  mapplet?

  
Filter

  
XML Sources

  
Normaliser

  
Aggregator

  
Target Definitions

  
2,3,5

 

  
I selected
  sorted input option but workflow takes same amount of time as before. What
  all could be the reason for this?

  
Aggregator expression contains nested aggregate
  functions 

  
Source uses Incremental aggregation 

  
Source data is data-driven

  
Source data has
  lesser data

  
Source has lesser columns

  
4

 

  
The number of threads depends on the ________ information
  for each pipeline?

  
Partition

  
Expression

  
CPU bandwidth

  
session

  
workflow

  
1

 

  
Where will the Informatica server stores data until it
  completes Aggregate calculations?

  
Memory

  
Repository

  
Database  

  
Cache 

  
log dir

  
3

 

  
Which data type is preferable when making comparisons
  using lookup and filter transformations?

  
Decimal  

  
Double

  
Integer                            

  
char

  
varchar

  
3

 

  
To improve the
  session Performance which one has to be done?

  
Increase the no
  of partitions 

  
Always use Verbose Tracing

  
Use only Normal load

  
Use ODBC for loading huge data

  
Avoid staging
  area

  
1,5

 

  
What is the order of identifying performance bottleneck

  
Source->Target->Mapping->Session->System

  
Target->Source->Mapping->Session->System

  
System->Source-> Target->Mapping->Session

  
Mapping->Session->System->Source->Target

  
Mapping->Session->System->Target->Source

  
2

 

  
To increase the performance of target load which one we
  have to do? 

  
Use External
  load

  
Use Normal load

  
Decrease checkpoint intervals

  
build indexes

  
to enable cache

  
1

 

  
In lookup transformation which cache we have to use

  to improve session Performance?

  
Shared cache

  
Persistent cache

  
Recache from db

  
1 &2

  
1 & 3

  
1,2

 

  
There are  three
  lookup cache counters having numbers 2000,4000,10000.Which of the following
  is true?

  
Tuning the lookup having counter 2000

  
Tuning the
  lookup having counter 10000

  
Tuning the lookup having counter 4000

  
All of them have the same performance

  
Disabling cache will improve performance

  
2

 

  
For a lookup on
  a small set of unchanging values which functions will degrade Session
  performance?

  
IIF

  
Is Null

  
Decode with
  single condition

  
Not NULL

  
Decode with multiple conditions

  
1,2,4

 

  
I have a table employee. I want the data only of deptno
  10 using filter. To improve session performance where will I place the filter
  transformation?

  
Nearer to Target

  
After the lookup

  
Near to source

  
In the middle

  
Before the lookup

  
1

 

  
Which one will
  optimize Aggregator transformation?

  
Group by simple
  columns

  
Use sorted input

  
Use incremental
  aggregation

  
Use lookup

  
Use cache

  
1,2,3

 

  
If your Target consists key constraints and indexes
  that will slow the loading of data, to improve the session performance, what
  you will do?

  
Trace Level should be Verbose Init

  
Drop indexes
  before load

  
Drop table and re-create

  
Drop constraints
  before load

  
Trace Level should be Verbose

  
2,4

 

  
To run the informatica server which data movement you
  prefer?

  
ASCII 

  
Unicode 

  
Binary

  
EBCDIC

  
Decimal

  
1

 

  
Which of the following are types of lookup cache?

  
Non-volatile cache

  
Recache from
  database

  
Static cache

  
Dynamic cache

  
Volatile Cache

  
2,3,4

 

  
Which of the following is applicable in Sources with
  respect to File sources

  
Fixed-width file
  is supported

  
De-limited file
  is supported

  
No header should exist in a file

  
One source can act as placeholder for multiple sources

  
Escape character should always be / for delimited files

  
1,2,4

 

  
What components of a datawarehouse can you create using
  informatica

  
Cubes

  
Dimensions

  
Attributes

  
Levels

  
Marts

  
1,2,4

 

  
For which of the following transformations you will use
  Sorted Ports option to improve performance?

  
Source

  
Rank

  
Aggregator

  
Target

  
Joiner

  
2,3,5