Informatica

1) What is the data format u prefer for informatica server

1) ASCII 2)EBCDIC 3)UNICODE 4)DECIMAL 5) BINARY

REASON:
Possible values are ASCII and UNICODE. The default data movement mode is ASCII, which passes 7-
bit ASCII character data. To pass 8-bit ASCII and multi byte character data from sources to targets, use the
Unicode mode.

2) HOW MANY TYPES OF DATA EXTRACTION ARE THERE

1, 2, 3, 4 OR 5 ANS 2

REASON:
There are two kinds of logical extraction:
 Full Extraction
The data is extracted completely from the source system.
 Incremental Extraction
At a specific point in time, only the data that has changed since a well-defined event
back in history will be extracted.

3) IF max no of sessions are 20 then what is the minimum shared memory size
1)2000000 2)1000000 3)4000000 4)3000000

REASON:
For every 10 sessions in Max Sessions, you need at least 2,000,000 bytes reserved in LMSharedMem.
The default is 2,000,000 bytes.

4) What are the dependencies of repository manager (check box question?)

1) workflow dependencies2) worklet dependencies 3) mapping dependencies 4) source dependencies 5)
transformation dependencies

REASON & ANSWER:

The repository manager displays following dependencies:
1) Source-Target 2) Mapping 3) Short cut dependencies

5) Config tab contains -------- and ------- properties (check box one)
1) Commit
2) Reject
3) Commit on insert
4) Commit on update
5) Load

6) What are the things that should be configured when a source is directly imported from database?
1) Data base name
2) Owner name
3) Index name
4) Constraint name
5) Data base type

NOTE:
This is just my opinion of the answer. The two sets of ans tat was actually marked were:
1,2,3 and 3,4,5.

7) An informatica variable contains

1)startvalue/end value
2)start value/current value
3)start value//persistent value
4)start value/…..
5)start value/dynamic value

REASON:
Mapping variable represents a value that can be changed during the mapping run. Mapping variables
have two identities:

Start value and Current value

8)some question like………….. what are the groups in router transformation

1)user defined groups
2)constant groups
Some other options

We guess the ans is user defined.

NOTE:
A Router transformation has the following types of groups:

 Input
 Output
Input Group
The Designer copies property information from the input ports of the input group to create a set of output
ports for each output group.
Output Groups
There are two types of output groups:
 User defined
 Default

9)set of source and target definitons and tranformations is called

Ans Mapping

10)some question like ENTERED_DATE and APPLIED_DATE

Ans . IIF((ENTERED DATE>APPLIED DATE) DD_REJECT,DD_UPDATE)
(updated by vijay)
( if (ENTERED DATE>APPLIED DATE) is true then it will do DD_REJECT else it will do DD_UPDATE)

11)if the data does not change from session to session the cache use is
Ans.. persistant cache

The questions might have one or more answers.

1. Which of the following are active Transformations?

(a) Sorter
(b) Expression
(c) Normalizer
(d) Filter

NOTE:
Transformations are of 2 types:
 Active  no. of rows changes from source and target
 Passive  no. of rows remains the same in source and target
Transformations can be either CONNECTED or UN-CONNECTED.
Connected  Transformation has connection between transformations or directly to target.
Un-Connected  There is no physical connection between transformations. It is generally called inside
another transformation.
TRANSFORMATION ACTIVE/PASSIVE CONNECTED/UN-
CONNECTED
Aggregator Active Connected
Filter Active Connected
Joiner Active Connected
Normaliser Active Connected
Rank Active Connected
Router Active Connected
Sorter Active Connected
Source qualifier Active Connected
Update strategy Active Connected
Advanced External procedure Active Connected
External procedure Active Connected/ un-connected
Sequence generator Passive Connected
Expression Passive Connected
XML source qualifier Passive Connected
Stored procedure Passive Connected/ un-connected
Look up Passive Connected/ un-connected

2. Which Function(s) cannot be used in Expression Widget(doubt)

(a) AVG
(b) COUNT
(c) LTRIM
(d) RTRIM
REASON:
Expression transformation can perform only non aggregate functions.

3. Write down the standards for the following

Input Port -> i_
Output Port -> o_
Variable Port -> v_

4. What manages the scheduling and execution of workflows?

(a) Informatica Server/Integeration services
(b) Repository Server
(C) Designer
(d) Monitor
REASON:
Informatica service  Scheduling and Execution of Workflows.
Repository service  Manages Metadata & Repository Connection Requests.
Designer  has 5 tools(Source Analyzer, Target Designer, Transformation Developer, Mapplet
Designer, Mapping Designer), using which we can create Mappings.
Monitor monitors workflows and tasks.

5. Which Client component can be used for creating Repository?

(a) Repository Manager
(b) Designer
(c) Workflow Manager
(d) Repository Server Administration Console

6. In Sequence Generator, If Current Value = 10, Increment By value=1, what is the NextVal value?
(a) 9
(b) 10
(c) 11
(d) 12
NOTE:
According to me, the answer should be 11 because the NEXTVAL is always CURRENT VALUE +
INCREMENT VALUE.

7. Can an Output Port be used in the editable area of widgets

(a) Yes
(b) No
(c) Depends on Widgets
(d) Possible only in active Transformation
REASON:
Ports- Input, Output, Variable, Return/Rank, Lookup and Master? Variable ports are used to store
intermediate results. Variable ports can reference input ports and variable ports, but not output ports.
8. If Sorted Input of Aggregator is unchecked,
(a) Sorter must be used before aggregator
(b) Sorter must be used after aggregator
(c) Sorter must be used before aggregator if data is not sorted via Source Qualifier
(d) Sorter must be used after aggregator if data is not sorted in Source Qualifier
REASON:
The Aggregator with 'sorted input' unchecked always sorts the data prior to aggregation. So in order to
increase performance we should have a sorter before sending the data to the aggregator.

9. Which of the following is/are better option if all below satisfies the requirement
(a) Filter Transformation used near to Source Qualifier
(b) Filter Transformation used near to Target
(c) Filter Transformation used anywhere in the mapping
(d) Filter Transformation used after any active transformation
REASON:
Always try to use filter and sorter transformation near source qualifier, this will increase the
performance. It is not mandatory but prescribed.

10. Which of the following is/are true?

(a) Shortcuts can be created for any object from any folder
(b) Shortcuts can be created for any object from shared folder
(c) Shortcuts can be created for sources and targets alone from any folder
(d) Shortcuts can be created for sources and targets alone from shared folder
REASON:
A shortcut is a reference (link) to an object in a shared folder, these are
commonly used for sources and targets that are to be shared between
different environments / or projects. A shortcut is created by assigning
'Shared' status to a folder within the Repository Manager and then dragging
objects from this folder into another open folder

11. Which of the following is/are true?

(a) If session is valid, Mapping will be valid
(b) If Mapping is invalid, Session will be invalid
(c) If session is invalid, Mapping will be invalid
(d) If session is valid, Mapping can be invalid
Ennaku sathiyama idha pathi theriyala…. (I have no idea about this…)
12. Joiner Can
(a) Join any two heterogeneous sources
(b) Join only Sources of same database
(c) Join only Flatfiles
(d) Join only Flatfile and database

13. Which of the following is/are true for Normalizer?

(a) Converts Rows into Columns
(b) Converts Columns into Rows
(c) Normalizer is active Transformation
(d) Normalizer is passive Transformation
REASON:
Normaliser transformation is a Active and Connected Transformation and it is generally used to create
multiple rows of data from a single row. Eg:
The following source rows contain four quarters of sales by store:
Source Table

Store Quarter1 Quarter2 Quarter3 Quarter4

Store1 100 300 500 700

Store2 250 450 650 850

The Normalizer returns a row for each store and sales combination. It also returns an index(GCID) that
identifies the quarter number:
Target Table

Store Sales Quarter

Store 1 100 1

Store 1 300 2
Store 1 500 3

Store 1 700 4

Store 2 250 1

Store 2 450 2

Store 2 650 3

Store 2 850 4

14. In which Order does the execution of ports take place

(a) Input Port, Output Port, Variable Port
(b) Input Port, Variable Port, Output Port
(c) Output Port, Input Port, Variable Port
(d) Output Port, Variable Port, Input Port

15. Which of the following are not possible Fan In ?

(a) Filter and Expression Widget Widgets being connected to input of another Expression Widget
(b) Expression and Sequence Generator Widgets connected to input of another Expression Widget
(c) Expression and Sorter Widgets connected to input of another Expression Widget
(d) Expression and Expression Widgets connected to input of another Expression Widget

I don’t understand the question itself… 

16. Which Component gets metadata from Repository?

(a) Informatica Server
(b) Informatica Workflow Designer
(c) Informatica Designer
(d) Informatica Repository Server/service

17. Repository Manager is used to

(a) Create, edit and delete folders
(b) Create, edit and delete repository users and user groups
(c) View locks and un-lock objects, versions and folders
(d) Copy a folder within a repository or to other repository

18. How many port values can be retrieved by an unconnected lookup and connected lookup respectively
(a) Zero, One
(b) One, Unlimited
(c) One, One
(d) Unlimited, Unlimited
19. For Unconnected Lookup how many ports can be given as input values
(a) Zero
(b) One
(c) Two
(d) Unlimited

20. For Updating Record on database table,

(a) We need Key on the Informatica target Metadata only
(b) We need key on the database only
(c) We need key on both Target Metadata and Database
(d) Keys are not required

1. How do you know that session has heterogeneous target?

a) Check the session properties and work floe properties
b) Either workflow properties or mapping properties or session properties(wrong)
c) Check session properties alone (updated by vijay)
d) Check mapping or work flow prop

2 which of the following is not used in Mapplet

Ans Target

REASON:

The transformations that cannot be used in MAPPLET and REUSABLE TRANSFORMATION are:
TARGET, NORMALISER, COBOL SOURCE, XML SOURCES, UPDATE STRATEGY, XML SOURCE,
QUALIFIER, TARGET DEFINITION

3.ER is ………. Ans.Entity relationship

4.XML……….. Ans: Extended Markup Language

5 Logical model is…………… Ans: RDBMS

6 we want to compare objects in Filter and aggregate transformation which data type you use……..
a) Integer
b)Double
c)String
d)Decimal
e) Char

7 which of the following are not the control task in workflow manager…….
A} Email notification
B} Alert notification
C} check the performance of session
Ans: A B C
REASON:
The lists of tasks supported in control task of workflow manager are:
 Fail me
 Fail parent
 Stop parent
 Abort parent
 Fail top-level workflow
 Stop top-level workflow
 Abort top-level workflow

8 Which of following Joins in Informatica………

1} Master outer
2 Full outer
3 Left outer
4 Outer join
REASON:
The types of Joins supported in Informatica are:
Normal (Default)  only matching rows from both master and detail
Master outer  all detail rows and only matching rows from master
Detail outer  all master rows and only matching rows from detail
Full outer  all rows from both master and detail ( matching or non matching)

9 Which of following are security tasks of repository manager

A} manage Repository
B} Create folders
C} Create users
D} Create groups

(Check Box Q)

10.What are tasks can do in designer …..

A} Inport / Export registry
B} Inport / Export repository objects
C} Create mapping
D} Creating mapplet

11 Update Strategy transformation……..

12 which one of these non-reusable transformation………….

A} ERP
B} Seq Generator Transform
C} Look up Transform
D} Dynamic lookup cache
REASON:
The transformations that cannot be used in MAPPLET and REUSABLE TRANSFORMATION are:
TARGET, NORMALISER, COBOL SOURCE, XML SOURCES, UPDATE STRATEGY, XML SOURCE,
QUALIFIER, TARGET DEFINITION

13 Types of Lookup cache…….

A} Dynamic Cache
B} Volatile Cache
C} Non volatile Cache
D} Re Cache from DB
E} Static Cache

REASON:
Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server
processes a lookup transformation configured to use the cache.

Re cache from database: If the persistent cache is not synchronized with he lookup table,U can configure the
lookup transformation to rebuild the lookup cache.

Static cache: U can configure a static or readonly cache for only lookup table.By default informatica server
creates a static cache.It caches the lookup table and lookup values in the cache for each row that comes into
the transformation.when the lookup condition is true,the informatica server does not update the cache while it
prosesses the lookup transformation.

Dynamic cache: If u want to cache the target table and insert new rows into cache and the target,u can create
a look up transformation to use dynamic cache.The informatica server dynamically inerts data to the target
table.

shared cache: U can share the lookup cache between multiple transactions.U can share unnamed cache
between transformations inthe same maping.

14 How will you improve performance of lookup transform?

A} Use memory cache for Large DB
B} Don’t Use cache for Small tables
C}use big cache…

15 Where aggregate store data in the processing………

Ans Cache
16 By default aggregate treats
Ans NULL as NULL (All numeric, character are treated as NULL)

17 Performance of Aggregate, Look up transform improved by sorter and cache

18.Diff Between Informatica 5.1 and 6.1 Version……….

A}Trans Control
B}Sorting

20 Number of transformation threads ……….. in Informatica into each pipeline.

Ans: Partitioning

21 Which of following is Passive Transformation………

A} Router
B} Rank
C} Source Qualifier
D} Aggregate
E} Séquence generator
REASON :
Refer to the table mentioned in start of the page.

22 Log initialisation, Error message and Notification of related data.

A} terse
B} Normal
C} Verbose init
D} Verbose Data
REASON:
Tracing level in the case of informatica specifies the level of detail of information that can be recorded in the
session log file while executing the workflow.

4 types of tracing levels supported

1.Normal: Integration Service logs initialization and status information

errors encountered and skipped rows due to transformation row errors.
Summarizes session results but not at the level of individual rows.

2.Terse: Integration Service logs initialization information and error

messages and notification of rejected data.
3. Verbose Initialization: In addition to normal tracing Integration Service
logs additional initialization details names of index and data files used and
detailed transformation statistics.

4.Verbose Data: In addition to verbose initialization tracing Integration

Service logs each row that passes into the mapping. Also notes where the
Integration Service truncates string data to fit the precision of a column and
provides detailed transformation statistics.

23.DW ------- Ans : OLAP

24 Which of the following is Active

Aggregator
Lookup
Expression
Router

25. …….. Converts from Source to Target by using the Transformation.

Ans: Session

26. Command,Session,e-mail are Reusable tasks.

REASON:
The Reusable tasks are:
command task
session task
email task

27 Cobol source used by ………. Transformation.

Ans Normalizattion

28……path….. are environment variables

29 Sorting can be used in ………

Ans Aggregate transformation
30 It takes some more time when I used Sorting.What is the reason

A} Use incremental Aggregation

B} nested Aggregation
C} Less data for source data
D} Less column
E} Data is Detailed data

Ans : C

31Types od SCD… Ans 3 (if techniques- 5 seq,rout,exp,update,look)

32 What type of Stored procedure is used to verify the target table?

And : Target Preload

33 Disable precision to numeric it becomes………..

Ans : Integer

34 Purpose of SQL override ?

Used to write user defined SQL statements in source qualifier and look up transformations

35 Ques on Metadata (blah! Blah!)

36 in retrieving if there are Multiple Rows matches in Look up transform?

And It returns an error(wrong)
(updated by vijay)
It will not through any error

37 If data is Overflowed in the load what happens?

Write to cache files

38 While importing relational source data from DB, What metadata u import?
A} Source name
B} DB location
C} Column Names
D}Datatypes
E} Key constraint

39 worklet variables are not used for………..

A}Reference
B} DB connection
C} Performance tuning
D}
E}

40 Performance degradation occurs due to……….

A} IS Null
B} NOT Null
C} IIF
D}abort
E}decode single
41. Non ressable transformations?

42 What is displayed when u click the “View dependencies” on any Target object.

Primary/foreign key dependencied

Global shortcut dependencies
All children
All parents
Note: the dependencies dialog box displays object name,object type,list of dependent objects and their
properties

1.Can Null values be compared?No

2.How Null values are stored in Aggregate transformation? 1.Null,2.we can configure them to treat them as
zero as well
3.What is SCD?slowly changing dimensions
4.What is not an option in Informatica?
a) Drill down^
b) Sessions
c) Dimension
d) Mapping
5)Types of Caches in Lookup.-connected,unconnected,static,dynamic,recache,persistant,shared
(Refer to the reasons in above pages...)
6) Select the Active transformation (Choose 1)
a) Aggregate^
b) Router^
c) XML Source Qualifier-i dont use this ever
d) Look up
e) Expression
7) Default Directory for storing the parameter files.$parent root directory
8) What happens when the maximum number of sessions are running and the database log file is full?
Session fails
9) Components derived from Informatica (choose 3) (updated by vijay)
a) Marts^(wrong)
b) Dimensions^
c) levels^
d) cubes^
10) Enhanced Security option (choose 3)
a) Read^
b) write^
c) Overwrite
d) Append
e) Execute^
11) To Transformation from one session to another using debugger
a) Step to Instance
b) Forward Instance
c) breakpoints^
d) Backward Instance
12) How can the performance of lookup be improved?by using cache and sorting
13) Update in Update strategy transformation is used for ? to flag the records for update
14) Performance Degradation (choose 3)
a) is null^
b) iff^
c) not null^
d) decode single condition
e) decode multiple condition
15) How can we access AEP's? AEP-advance external procedure

Table 8-1. Environment Variables

Operating System Environment Variable

Windows PATH
AIX LIBPATH
HPUX SHLIB_PATH
Linux LD_LIBRARY_PATH
Solaris LD_LIBRARY_PATH

16) How will user-defined variables be stored in a worklet?

a) static
b) dynamic
c) persistent
d) volatile
e) non-persistent
17) Which operator can be used in the look up-^all (if dynamic = is the ans)
a) =
b) >=
c) <=
d) <
e) >

18) Which will not return values in the user defined data types
a) Oracle
b) Informiz
c) Teradata
d) SQL Server
e) Sybase

19) When you update the database where it will get updated? (updated by vijay)
a) Session or Mapping
b) Mapping and session(wrong)
c) Mapping and workflow
d) Mapping and repository
20) After joiner transformation the source takes the input as?
a) content table
b) Master table
c) Detail Table
21) What will happen if the lookup cache get overloaded?^i will be stored in the file format in
the disk(over flowing data)the session will fail

1. what are not the piorts of source table.

ans:- i/p port,variable port,sorted port==== (i/p and o/p)

2. informatica is:-
ans:- ETL

3.datawarehousing is
ans:- OLAP
4.some ques like that-----on grouping --for emp id or name
ans :--------look up transform

5.diff between informatica 5.1 and 6.1

ans:-transaction control and sorter

6.what happens when cache of lookup overflows

ans:-----remaining data is written to cache files

7.
longer time duration is given for commit & log datafiles full,what happens to session
ans-----session fails

8.what operation s performed using control task

ans----stop ,abort and fails workflow

9.slowly changing dimension related question (if check box mark on manage data,manage/merge session and
manage data)
ansssss------------if radio button mark on manage/merge data

10.if many matches are present in the look up transformation

ans:-for static cache------first and last matching rows returned and error
for dynamic cache ----------the session fails

11.designer performs
ans:-----create mapping

12.where cache(index and data) is stored

ans---------cache directory

13.if stored procedure transformation is after jpiner transformation the target table is imported
ans:-----detail table

14.active transformation related ques

ans:----aggregator trans

15:--repository manager is capable of performing

ans:----manage privieleges,manage groups,manage repository

16.stored proce transformation checks for target table& disk space of target
ans:---- preload target

17. default join between tables

ans:- normal join

18.sorter trans default cache size

ans:-----8000000 bytes

19.performance can be imp by sorted input in which transformation

ans:----- aggregator

20.if u can sorted i/p ________ it takes some time

ans:------data driven

Hey Tenny, I've collected some questions from Informatica that are being asked in the exams... Please help us
in finding the right answers.

1.Can NULL values be compared (True/False)-

2.How Null values are stored in Aggregate Transformation
3.Types of caches in Lookup?(multiple answers)
( Connected
Unconnected )
Static
Dynamic, percistent and Shared caches
4.What is the default directory for storing the parameter files?

Parent root dir->Param folder

5. What happens when max number of success are running and the database logfile is full? error
6. Components derived from Informatica
Marts
Dimensions
cubes
7. Enhanced security option?
Read
write overwrite
append
execute
8. To transformation from one session to another using debugger
step to instance
forward instance
breakpoints
backward instance
9.update in update strategy transformation is used to ? flag rows for insert update delete reject
10. Performs Degradation
Is Null
iff
notnull
decode single condition
decode multiple
11. How can we access AEP?
12. How are user defined variables are stored in worklet
static
dynamic
persistant,non persistant
13. which will not return user defined values?
informix
oracle
teradata
sql server
sybase
14. when you update the database where it will get updated(updated by vijay)
session or mapping
mapping and workflow
session and mapping(wrong)
mapping and repository
15. after joiner transformation the source takes the i/p as
content table
master table
detail table
16. what will happen if lookup cache is overloaded? Session fails ,remaing details wil return to cacahe
17.which of the following are not to copy the one source to another source without connecting database
drag and drop
copy the content and paste
cannot copy
move option
create shortcut and rename it
18.what is the function of SCD?
manage data
manage workflow
manage session
19.where cache(index,data) stores
workflow logs
session logs
cache directory
informatica repository
20. how many rows can be retrieved by dynamic lookup table?
cannot retrieve
one by one semantically
only first row
all rows
21. where do you store the overflow data? In cache files
22. what is the newly added tech in 6.1 other than 5.1? Transaction controller and Sorter
23. alter sorts the data and takes the same time as before sorting the data. Why?
agg trans having nested agg
agg trans contains incremental
data driven
24.if stored procedure transformation is after joiner trans the target table is imported_________
detail table
master table
detail or master
target table
25. Already we have empid to add empname which transformation is used? : lookup
26. sorter transformation cache size?
2000000
16000
0
8000000

27.which decreases the performace

is nul
not null
IIF
decode simple condition –I Guess
decode multi condition
28. which transformation using sorter?
aggregate
joiner
lookup
29.source table does not having which ports?
i/p ports
o/p ports
variable port
meta data extension
30. in stored procedure in which mode checks the sufficient diskspace
preload source
post load sourcce
preload target
post load target

31. where you check the validity?

in workflow only
in designer only
at runtime of database
in workflow
32. how can you evaluate null values in the comparision
null values are not used in comparision
low/high
treated as null (Most comparisons between nulls and other values are by definition neither true nor false,
but unknown)
determined by database

1) Which one is not correct about filter transformation?

Explanation: Filter generally parses single condition. For multiple condition we can use router
A. Act as a 'where' condition
B. Can't passes multiple conditions
C. Act like 'Case' in pl/sql
D. If one record does not match condition, the record is blocked
2) Can we calculate in aggrigator ?
Explanation:
A. No
B. Yes
3) Which one is not a type of fact?
Explanation:
A. Semi-additive
B. Additive
C. Confirm fact
D. Not additive
4) Which one is not a type of dimension ?
Explanation:
A. Conformed dimension
B. Rapidly changing dimension
C. Junk dimension
D. Degenerated dimension
5) Which of these not correct about Code Page?
Explanation:
A. A code page contains encoding to specify characters in a set of one or more languages
B. A code page contains decoding to specify characters in a set of one or more languages
C. In this way application stores, receives, and sends character data.
D. None of these
6) What is a mapplet?
Explanation:
A. Combination of reusable transformation.
B. Combination of reusable mapping
C. Set of transformations and it allows us to reuse
D. None of these
7) What does reusable transformation mean?
Explanation:
A. It can be re-used across repositories
B. I can only be used in mapplet.
C. It can use in multiple mapping only once
D. It can use in multiple mapping multiple times
8) Which one is not an option in update strategy?
Explanation:
A. dd_reject
B. 4
C. 2
D. dd_delete
9) Can we update records without using update strategy?
Explanation:
A. Yes
B. No
10) How to select distinct records form Source Qualifier?
Explanation:
A. Choose 'non duplicate' option
B. Choose 'select distinct' option
C. Choose 'Select non duplicate'
11) What type of repository is no available in Informatica Repository Manager?
Explanation:
A. Standalone Repository
B. Local Repository
C. User Defined
D. Versioned Repository
E. Manual Repository
12) Joiner does not support flat file.
Explanation:
A. False
B. True
13) How to execute PL/SQL script from Informatica mapping?
Explanation:
A. Lookup
B. Store Procedure
C. Expression
D. None of these
14) NetSal= bassic+hra. In which transformation we can achive this?
Explanation:
A. Aggregator
B. Lookup
C. Filter
D. Expression
15) Which one is not an active transformation?
Explanation:
A. Sequence generator
B. Normalizer
C. Sql
D. Store Procedure
16) A lookup transformation is used to look up data in
Explanation:
A. flat file
B. Relational table
C. view
D. synonyms
E. All of the above
17) Which value returned by NewLookupRow port says that Integration Service does not update or insert the
row in the cache?
Explanation:
A. 3
B. 2
C. 1
D. 0
18) Which one needs a common key to join?
Explanation:
A. source qualifier
B. joiner
C. look up
19) Which one support heterogeneous join?
Explanation:
A. source qualifier
B. joiner
C. look up
20) What is the use of target loader?
Explanation:
A. Target load order is first the data is load in dimension table and then fact table.
B. Target load order is first the data is load in fact table and then dimensional table.
C. Load the data from different target at same time.
21) Which one is not tracing level?
Explanation:
A. terse
B. verbose
C. initialization
D. verbose initialization
E. terse initialization
22) Which output file is not created during session running?
Explanation:
A. Session log
B. workflow log
C. Error log
D. Bad files
E. cache files
23) Is Fact table is normalized?
Explanation:
A. yes
B. no
24) Which value returned by NewLookupRow port says that Integration Service inserts the row into the
cache?
Explanation:
A. 0
B. 1
C. 2
D. 3
25) Which transformation only works on relational source?
Explanation:
A. lookup
B. Union
C. joiner
D. Sql
26) Which are both connected and unconnected?
Explanation:
A. External Store Procedure
B. Stored Procedure
C. Lookup
D. Advanced External Procedure Transformation
27) Can we generate alpha-numeric value in sequence generator?
Explanation:
A. yes
B. no
28) Which transformation is used by COBOL source?
Explanation:
A. Advanced External Procedure Transformation
B. Cobol Transformation
C. Unstructured Data Transformation
D. Normalizer
E. 29) What is VSAM normalizer transformation?
Explanation:
A. The VSAM normalizer transformation is the source qualifier transformation for a COBOL source definition.
B. The VSAM normalizer transformation is the source qualifier transformation for a flat file source definition.
C. The VSAM normalizer transformation is the source qualifier transformation for a xml source definition.
D. None of these
30) What is VSAM normalizer transformation?
Explanation:
A. The VSAM normalizer transformation is the source qualifier transformation for a COBOL source definition.
B. The VSAM normalizer transformation is the source qualifier transformation for a flat file source definition.
C. The VSAM normalizer transformation is the source qualifier transformation for a xml source definition.
D. None of these
31) Which are lookup caches?
Explanation:
A. Persistent cache
B. Dynamic cache
C. Pre-build lookup cache
D. Shared Cache
E. None of these
32) What are the different values returned by NewLookupRow port?
Explanation:
A. 0,1,3
B. 0,1,2
C. 1,2,3
D. 2,3,4
33) Which value returned by NewLookupRow port says that Integration Service updates the row in the
cache?
Explanation:
A. 0
B. 1
C. 2
D. 4
34) What are the types of SQL queries you can specify in the SQL transformation?
Explanation:
A. strict
B. Dynamic
C. Cached
35) What is meaning of tracing level?
Explanation:
A. Data store in cache
B. Data store in database
C. Data store in log file
D. Data store in buffer
36) Which command has 60seconds time out period?
Explanation:
A. stop
B. abort
C. kill session
37) Which command is similar to 'kill' command in Unix?
Explanation:
A. stop
B. abort
C. kill session
38) Which one contains input and output transformations?
Explanation:
A. mapplet
B. reusable transformation
C. reusable mapping
39) Which one can test multiple conditions?
Explanation:
A. decode
B. else if
C. if
D. none of these
40) Which dimension is collection of random transactional codes, flags and/or text attributes ?
Explanation:
A. degenerated
B. scd
C. junk
D. confirmed
41) Which one is not a target Option for file on the Servers?
Explanation:
A. FTP
B. Loader
C. MQ
D. ERP
42) Which one is not a designer tool creating transformations?
Explanation:
A. Transformation developer
B. Mapping designer
C. Mapplet designer.
D. target designer
43) Which one is not a scheduling options to run a session?
Explanation:
A. Run only on demand
B. Run once
C. Run in six-month
D. Run every
E. Customized repeat
44) Which one manages connections to the repository from client application?
Explanation:
A. Informatica Repository
B. Informatica Server
C. Repository manager
D. All of these
45) How to Generate the Metadata Reports in Informatica?
Explanation:
From a browser on any workstation
Form repository
From Work flow manager
46) Which one is not Target Types on the Server?
Explanation:
File
Relational
ERP
vsam
47) What are the processes to do join the tables if the tables have no primary and foreign key relation and
no matching port to join?
Explanation:
Add one dummy port in two sources.
Use Joiner transformation to join the sources using dummy port
Use Union
In expression trans assign '1' to each port
48) Can start and stop single session in concurrent batch?
Explanation:
yes
no
49) Can you copy the batches?
Explanation:
yes
no
50) What are the processes that informatica runs the session?
Explanation:
DTM
Server Manager Process
Load Manager Process
Server Configuration Process
51) What is the default source option for update strategy?
Explanation:
Update or Delete
Update or Insert
Insert or Update
Date Driven
52) Which one not in the types of mapping in “getting started wizard"?
Explanation:
Slowly Growing target
Simple Pass through mapping
Simple Pass through target
None of These
53) What is default join of joiner?
Explanation:
Full Outer
Detail Outer
Normal
Master Outer
54) What are the types of joins that Joiner transformation supports ?
Explanation:
Full Outer
Master Outer
Normal
Detail Outer
55) What is the default join of Source Qualifier?
Explanation:
Left Outer join
Equi Join
Inner-equi join
Outer join
56) What are the types of batches?
Explanation:
Concurrent
Dependent
Sequential
Circular
57) What are the types of groups in Router transformation?
Explanation:
User defined group
Multiple Group
Default Group
Single Group
58) Which one of these create log files?
Explanation:
process manager
Informatica Server
Load Manager
Non of these
59) Dimension tables are denormalized in nature ? True or False.
Explanation:
true
false
60) Which of these are the types of metadata that stores in repository?
Explanation:
Reusable transformations
Source definitions
mapplet
Sessions and workflows
Target definitions
61) In the Type2 mapping we have three options to recognize the newly added rows. Which one is not
belongs to them?
Explanation:
Version number
Effective time range
Effective date Range
flag value
62) How to Generate the Metadata Reports in Informatica?
Explanation:
From a browser on any workstation
Form repository
From Work flow manager
63) How can we load time dimension?
Explanation:
Through Sql transformation
Through Dimensional Loader
Through Lookup
Through Store Procedure
64) Which of these are true about look-up cache?
Explanation:
We use dynamic cache only for connected lookup
We use dynamic cache to check whether the record already present in the target table are not
We use dynamic cache only for un-connected lookup
All of these
65) Which are the load types in Informatica session?
Explanation:
Bulk
Terse
Normal
All of these
66) In which load type in session we can't recover the session, or can't rollback.
Explanation:
bulk
terse
normal
1 and 2
67) Which load type we should use in case of less amount of data and recover session?
Explanation:
verbose
normal
bulk
All of these
68) Which of these are measure objects?
Explanation:
min
max
ltrim
avg
69) Can you start a batch within a batch?
Explanation:
yes
no
70) If you want to save the lookup cache files and reuse them the next time the informatica server, which
cache you'll use?
Explanation:
Dynamic cache
Static cache
Shared cache
Persistent cache
71) For look-up, which one is default informatica server cache?
Explanation:
Static cache
shared
dynamic
re-cache
72) If you want to insert new rows into cache and the target, you should use which cache?
Explanation:
static
dynamic
Persistent
Re-cache
73) What are the settings that you have to configure in joiner transformation?
Explanation:
Master and detail source
Condition of the join
Type of Source
Type of join
74) Which lookup cache is read-only?
Explanation:
dynamic
shared
static
Persistent cache
75) Which cache allows you to share lookup cache among multiple transactions?
Explanation:
shared
persistence
static
dynamic
76) If you want to configure the lookup transformation to rebuild the lookup cache, then which cache you
should use?
Explanation:
Dynamic
Shared
Re-cache from database
Re-cache from target
77) While importing the relational source definition from the database, which of thse are the metadata of
source that will be imported?
Explanation:
Source name
Database location
Data type
Key constraints
Column name
78) n session log file which information’s we can find?
Explanation:
Session Initialization Process
Session Completion Process
Error encounter
Load Summary
Load manager process
79) How to connect remote database?
Explanation:
By ftp
By login to remote server
By pmcmd
All of these
80) Which are the ways to update source definitions?
Explanation:
Edit the definition
Re-import the definition
connect to server
connect to repository server
81) How to generate single look-up by using multiple tables?
Explanation:
By selecting different source
By selecting dynamic cache
Write sql override
Connect to a sql transformation
82) Which one is not a property in sequence generator?
Explanation:
Start Value
re-cycle
Current Value
Number of Cached Values
83) What is proc_result in stored procedure transformation?
Explanation:
user-denied variable
mapping variable
workflow variable
system variable
84) Can you generate sequence number without using sequence generator?
Explanation: By using expression
yes
no
85) can we import source table without using source qualifier?
Explanation: For COBOL file sources we can directly use normalizer transformation without using source qualifier
yes
no
86) Can you connect ports of two output groups, from router transformation to a single target definitions?
Explanation:
yes
no
87) Session has to run Monday to Saturday not run Sunday how to schedule in informatica ?
Explanation:
Customized Report
weekly option
daily option
none of these
88) Which one of these is a repository object that generates, modifies or passes data?
Explanation:
mapping
mapplet
transformation
batch processing
89) Can we use the mapping parameters or variables, created in one mapping into another mapping?
Explanation:
no
yes
90) Which one of these transformation use cache?
Explanation:
Update Strategy
sorter
Aggregator
Rank
91) Which statements are correct?
Explanation:
In Union, we can join two tables without common ports.
Joiner support heterogeneous join only
Source Qualifier supports homogeneous join only
Without common port we can join in joiner also.
92) Which are true sentences?
Explanation:
Active transformation is the one which do changes in no of rows.
Active transformation is the one which doesn't change in no of rows.
Passive transformation is the one which do changes in no of rows.
Passive transformation is the one which doesn't change in no of rows.
93) Which of this workflow task represents the location of a user-defined event?
Explanation:
Event-Raise
Event-Wait
User_event
Decision
94) Which one is not a valid constant expression?
Explanation:
ERROR ('Null not allowed')
ABORT('Null not allowed')
SYSDATE
AVG(IN_SALARY)
95) Can you reverting to original reusable transformation?
Explanation: If you change the properties of a reusable transformation in a mapping, you can revert to the original
reusable transformation properties by clicking the Revert button. If you change the properties of a reusable
transformation in a mapping, you can revert to the original reusable transformation properties by clicking the Revert
button. If you change the properties of a reusable transformation in a mapping, you can revert to the original reusable
transformation properties by clicking the Revert button. If you change the properties of a reusable transformation in a
mapping, you can revert to the original reusable transformation properties by clicking the Revert button.
yes
no
96) Which transformation enables you to connect to an HTTP server to use its services and applications?
Explanation:
ftp
http
custom
java
97) Which function convert dates to a specific year, month, day, hour, or minute?
Explanation:
to_date
to_char
trunc
non of these
98) Which one is not a character function?
Explanation:
CHRCODE
LENGTH
lower
All are char functions
99) Which one is not date function?
Explanation:
ROUND
TO_DATE
TRUNC
ADD_TO_MONTH
100) Which one is not a data cleansing function?
Explanation:
IS_DATE
To_date
REG_MATCH
LENGTH
101) The transformation language provides two comment specifiers to let you insert comments in
expressions. Which are two ways among these?
Explanation:
/* write here*/
/ write here/
// write here
--write here
102) Which one of these is not a built-in constant?
Explanation:
Null
True
dd_delete
ltrim
false
103) Which one is not a comparison operator?
Explanation:
^=
<=
>=
==
104) Which statements are true?
Explanation:
NULL AND TRUE = NULL
NULL AND FALSE = FALSE
NULL AND TRUE = FALSE
NULL AND FALSE = NULL
105) Can sorter transformation be passive?
Explanation: If we'll not choose sorted input in sorter, then input and output will same. So then it is passive
yes
no
106) What is :EXT?
Explanation:
Required when you write an expression that includes a return value from an Expression transformation
Required when you write an expression that includes a return value from an External Procedure transformation
Required when you write an expression that includes a return value from an look up Procedure transformation
Required when you write an expression that includes a return value from an Aggregator Procedure transformation
107) Waht is :LKP?
Explanation:
Required when you create an expression that includes the return value from an unconnected Lookup transformation.
Required when you create an expression that includes the return value from an Connected Lookup transformation.
Required when you create an expression that includes the return value from an unconnected Sp transformation.
includes the return value from an connected Sp transformation.
108) Which of this is not a task that exists in workflow?
Explanation:
Session
Workflow
control
assign
109) Wat is :SP?
Explanation:
Required when you write an expression that includes the return value from an connected Look-Up transformation
Required when you write an expression that includes the return value from an unconnected Look-Up transformation
Required when you write an expression that includes the return value from an connected Stored Procedure
transformation
Required when you write an expression that includes the return value from an unconnected Stored Procedure
transformation
110) Which one is not a reserve word in informatica?
Explanation:
NOTSTARTED
STARTED
STOPPED
SUCCEEDED
KILLED
111) IIF( EMPLOYEE.NAME = 'Rex', 0, 3 )
What this expression says about?
Explanation:
If Employee name is Rex then update else delete
If Employee name is Rex then update else reject
If Employee name is Rex then insert else reject
If Employee name is Rex then update else insert
112) Which variable doesn't belongs to variable use in transaction control expression?
113) Explanation:
TC_COMMIT_BEFORE
TC_ROLLBACK_AFTER
TC_ROLLBACK_BEFORE
TC_COMMIT_AFTER
TC_CONTINUE_TRANSACTION
114) Which is not a date format string?
Explanation:
SS , SSSS
MM, MON, MONTH
MI
MM
HH, HH12, HH24
115) Which statements are correct?
Explanation:
DATE_DIFF. Subtract two dates
ADD_TO_DATE. Add or subtract a specific portion of a date
TO_DATE Change one part of a date to another date format
SET_DATE_PART. Change one part of a date
116) Which one is not a conversion function?
Explanation:
TO_MONTH
TO_DECIMAL
TO_NUMBER
TO_INTEGER
TO_DATE
117) Which one is not a numeric function?
Explanation:
TRUNC
LN
CUME
ROUND AVG
118) Can you rename the repository object?
Explanation: You can rename repository objects by clicking the Rename button in the Edit Tasks dialog box
yes
no
119) Which are the connection names, those you can configure from work flow manager?
Explanation:
relational database connections
FTP connections
external loader connections
queue connections
source and target application connections
120) Integration Service suspends the workflow, if which one of these following tasks fail?
Explanation:
Session
Command
Worklet
Email
All of these
121) Which task is used to stop, abort, or fail the top-level workflow or the parent workflow based on an
input link condition?
Explanation:
command
control
email
timer
122) Waht is :SEQ?
Explanation:
Required when you create an expression that includes a port in a Sequence Generator transformation
Required when you create an Lookup that includes a port in a Sequence Generator transformation
Required when you create an Sql Transformation that includes a port in a Sequence Generator transformation
Required when you create an UN-connected lookup Transformation that includes a port in a Sequence Generator
transformation
123) Which one is not date function?
Explanation:
ROUND
TO_DATE
TRUNC
ADD_TO_MONTH
124) If you want to run a second session only if the first session completes successfully, then which task
you should use?
Explanation:
timer
assign
decisions
link
125) Can you run part of work flow?
Explanation: To run part of the workflow, right-click the task that you want the Integration Service to run and choose
Start Workflow From Task
yes
co
126) Which tasks are re-usable?
Explanation:
Control
Command
Email
Session
127) Which task Waits for a user-defined or a predefined event to occur, once the event occurs, the
Integration Service completes the rest of the workflow?
Explanation:
Event-Raise
Event-Wait
128) If you want to copy the rejected files and paste it in other directory during the running of work-flow,
then which task you should use?
Explanation:
decisions
control
command
assignment
129) Which one is not a commit type?
Explanation:
User-defined commit
Pre-defined commit
Source-based commit
Target-based commit
130) What are the types of method to load dimensional table?
Explanation:
Conventional
Indirect
Direct
None of these
131) What is lookup table?
Explanation:
stores the update record based on lookup condition
stores the new record based on lookup condition
stores the new record or update record based on lookup condition
none of these
132) Which scd type stores one time historical data with current data?
Explanation:
type1
type2
type3
133)
Which SCD methodology overwrites old data with new data?
Explanation:
type1
type2
type3
134) Which SCD method tracks historical data by creating multiple records?
Explanation:
type1
type2
type3
135) What is hybrid SCD?
Explanation:
combination of type1 and type2
combination of type2 and type3
combination of type1 and type3
136) Which schema is normalized?
Explanation:
star
snowflake
galaxy
137) If one table contains a value that is not either measure or fact, what do we call that?
Explanation:
additive fact
junk dimension
semi-additive fact
De-generated dimension
138) Which type of wizard loads a static fact or dimension table by inserting all rows?
Explanation:
Mapping Pass Through
Simple Pass Through
Slowly Growing Target
139) INSTR( 'Samsung', 'a' ). What will be output?
Explanation:
true
false
0
2
140) INITCAP( 'mike' ) What is output?
Explanation:
Mike
mike
mIKE
None of these
141) What is output of this expression? IN( 'dog', 'cat', 'dog', 'horse', 0 )
Explanation:
0
false
1
true
142) Which statements are true about FLOOR function?
Explanation:
FLOOR( 39.9 )=40
FLOOR( 39.9 )=39
FLOOR( -39.9 )=-39
FLOOR( -39.9 )=-40
FLOOR( 39.2 )=39
143) Which one is true about DATE_COMPARE function?
Explanation:
compare two string returns an integer value
compare two dates returns an integer value
compare two numeric value returns an date value
compare two numeric value returns an string value
144) Which one is true about CHR function?
Explanation:
It’s just opposite to ASCII function
CHR returns the numeric value to corresponding to the ASCII character
CHR returns the ASCII character corresponding to the numeric value
none of these
145) CHOOSE (2, 'Abcd', 'gef', 'ijk' ), What will this function return?
Explanation:
true
false
gef
ijk
146) Which are correct statements?
Explanation:
CELI(12.39)=12
CELI(12.39)=13
CELI(-12.39)=-13
CELI(-12.39)=-12
CELI(12.56)=13
147) When you configure the Integration Service to run in ASCII mode, which one is correct about the
ASCII function returns value
Explanation:
numeric ASCII value of the first & last character of the string passed to the function
numeric ASCII value of the last character of the string passed to the function
numeric ASCII value of the all character of the string passed to the function
numeric ASCII value of the first character of the string passed to the function
148) Which date function specify the part of the date you want to change?
Explanation:
SET_DATE_PART
DATE_DIFF
GET_DATE_PART
ADD_TO_DATE
149) Which system variable returns the current date and time on the machine hosting the Integration
Service for each row passing through the transformation?
Explanation:
SYSDATE
$$$SessStartTime
SESSSTARTTIME
WORKFLOWSTARTTIME
150) Which system variable returns the current date and time value on the machine hosting the
Integration Service when the server initializes the session?
Explanation:
$$$SessStartTime
SESSSTARTTIME
SYSDATE
WORKFLOWSTARTTIME
151) Which system variable returns the initial system date value on the machine hosting the Integration
Service when the server initializes a session?
Explanation:
$$$SessStartTime
SESSSTARTTIME
SYSDATE
WORKFLOWSTARTTIME
152) Which wizard loads a slowly growing fact or dimension table by inserting new rows?
Explanation:
Slowly Growing Target
Rapidly Growing Target
Simple Pass Through
153) Which one is the correct format of ADD_TO_DATE function?
Explanation:
ADD_TO_DATE( ORDER_DATE, 1, 'MM' )
ADD_TO_DATE( ORDER_DATE, 'MM', 1 )
ADD_TO_DATE(1, ORDER_DATE, 'MM' )
ADD_TO_DATE(1,MM, ORDER_DATE )
154) Can we perform calulation in Look up?
Explanation:
yes
no
155) Which type of join keeps all rows of data from both the master and detail sources?
Explanation:
Master outer
Detail Outer
Full Outer
left Outer
156) Which are the true statement to improve session performance in joiner ?
157) Explanation:
Add transformations
Configure the sort order
Configure the Joiner transformation
Do not user master outer join
158) Which type of join join keeps all rows of data from the master source and the matching rows from
the detail source?
Explanation:
Master Outer
Detail Outer
Notmal
Equi
159) To maximize session performance what are the tips for filter transformation?
Explanation:
Use the Filter transformation early in the mapping
Use the Source Qualifier transformation to filter
Use the Expression Qualifier transformation to filter
All of these
160) Is Filter is case-sensitive?
Explanation:
yes
no
161) If two tables emp_detail and emp_payroll contain EMP_ID1 and EMP_ID2 with a row with a null value,
can joiner will match that null value?
Explanation:
yes
no
162) Which type of join keeps all rows of data from the detail source and the matching rows from the
master source?
Explanation:
Master outer
Detail Outer
Normal
Equi
163) Can you use sorted input if source data is data driven?
Explanation:
yes
no
164) To configure how the Integration Service applies the transformation logic to incoming data, which
one you can choose of the following values
Explanation:
Row
Transaction
All Input
you can choose any one of these
165) Can you use sorted input if the session uses incremental aggregation?
Explanation:
yes
no
166) Can you use sorted input if aggregate expression contains nested aggregate functions?
Explanation:
yes
no
167) Whitch guidelines are needful to optimize the performance of an Aggregator transformation?
Explanation:
Use sorted input to decrease the use of aggregate caches.
Limit connected input/output or output ports.
Filter before aggregating
None of these
168) INSTR( 'Vivek', 'a' ). What will be output?
Explanation:
null
flase
0
none of these
169) Which repository objects is not created in Workflow Manager ?
Explanation:
Database connections
Worklet
Maplet
Session
170) Which repository objects are created by repository manager?
Explanation:
Folder
Users
User groups
User type
171) Which statement is true?
Explanation:
A repository domain consists of no of global repository and any number of local repositories
A repository domain consists of a single global repository and any number of local repositories
A repository domain consists of no of global repository and one local repositories
none of these
172) Which is not a version of objects in the repository?
Explanation:
Check out and check in versioned objects
Compare objects
Track changes to an object
Update a version
173) Where you can release lock if one object is locked?
Explanation:
Work flow manager
Designer
Repository Manager
None of these
174) If you are comparing two date using date_compare function, if first date is earlier then what will be
returned?
Explanation:
date difference in number
date difference in no of day
-1
1
175) If you are comparing two date using date_compare function, if Second date is earlier then what will
be returned?
Explanation:
no of days in number
no of days in days
1
0
176) If you are comparing two date using date_compare function, if two dates are equal then what will be
returned?
Explanation:
1
-1
0
null
177) INSTR( "I am a informatica Developer', 'a', 1, 2 ) What is output?
Explanation:
3
4
5
6
178) INSTR( "informatica', 'a', -1, 2 ) What is output?
Explanation:
5
7
12
1
179) What will output? SUBSTR( "Informatica",1,INSTR( "Informatica",1,1 ))
Explanation:
I
atica
tica
Informa
180) LEAST( 12, 13, 21 ) what will output?
Explanation:
46
25
12
21
181) LPAD( 190, 5, '0') What will output?
Explanation:
00000190
19000000
00190
19000
182) LPAD( "Informatica", 16, '*..*' ) What will output?
Explanation:
*..*Informatica
*..*.Informatica
Informatica*..*.
Informatica*..*
183) LPAD( "Inform", -10, '*') What will out put?
Explanation:
Inform*****
*****Inform
Inform
null
184) What will o/p of this expression . 8 * 10 - NULL
Explanation:
80
8
10
null
185) What is the return value of 'alpha' || NULL ?
Explanation:
alphanull
null
alpha
false
186) Which variable sets the current value of a mapping variable to a value you specifyand returns the
specified value?
Explanation:
SETVARIABLE
Function Syntax Description SETCOUNTVARIABLE
Function Syntax Description SETCOURENTVARIABLE
NON OF THESE
187) Which variable counts the rows evaluated by the function and increments the current value of a
mapping based on the count?
Explanation:
SETMINVARIABLE
SETVARIABLE
SETCOUNTVARIABLE
NONE OF THESE
188) Which one is not an option in update-strategy?
Explanation:
Truncate table
Update as Insert
Update as Update
Update as Delete
189) What is the meaning of Update as Update?
Explanation:
Update each row flagged for update if it is not exists in the target table.
Update each row flagged for update if it exists in the target table.
Update each row flagged for update if it is new in the target table.
None of these
190) What is meaning of Update as Insert in update-strategy?
Explanation:
Update each row flagged for update if it exists in the target table.
Inset each row flagged for update.
Update the row if it exists. Otherwise, insert it.
None of these
191) What is meaning of Update as update else Insertin update-strategy?
Explanation:
Update each row flagged for update if it exists in the target table
Inset each row flagged for update
Update the row if it exists. Otherwise, insert it
All of these
192) Which function causes the Integration Service to skip a record and issue the specified error
message?
Explanation:
ERROR
ABORT
SKIP
ERR
193) ROUND( 112.5676, 3 ). What will output of this expression?
Explanation:
112
.567
112.568
112.6
194) What is Truncate Table option in update-strategy?
Explanation:
Truncate the target table before loading data.
load the table value to another table
delete the data of target which can roll back
none of these
195) What will o/p of this statement REPLACECHR ( 1, 'Informatica[Scenarios"]', ']["', NULL ) ?
Explanation:
[InformaticaScenarios]
"[InformaticaScenarios]"
"[Informatica[Scenarios"]"
InformaticaScenarios
196) What will return value of this expression REPLACECHR ( 1, 'RAR", 'R', 'M' )?
Explanation:
true
false
RAM
MAR
197) ROUND( 10567.90, -2 ). What is the output of this statement?
Explanation:
10567
567.90
10500
.90
198) Which of these are true?
Explanation:
Drill-down allows the users view higher level
Drill-down allows the users view lower level
drill-up allows the users to view higher level
drill-up allows the users to view lower level
199) Which is not a kind of lock on repository objects?
Explanation:
Execute lock
Fetch lock
Save lock
Read lock
Delete Lock
200) Which is not true of Cube?
Explanation:
multidimensional representation of data
used for analysis purpose
multiple level of extraction of data
multiple views of data
201) What will happen if informatica server doesn't find session parameter and variable?
Explanation:
Work flow will fail
Automatically it will created
Give a message to user to put it
none of these
202) Which of these are limitationof bulk loading of target load type in Session?
Explanation:
Less no of record
Use only Relational Database
Doesn't support flat file.
All of these
203) If you are not using group by column in Aggrigaror, what will be out put?
Explanation:
Not a problem
Only first row
Only Last Row
None of these
204) How many transformation you can use in your mapping?
Explanation:
16
16
Any number according to requirement
In Informatica 7 limited in 8 unlimited
205) Which transformation acts like CASE.. WHEN in Sql?
Explanation:
filter
router
aggrigator
look up
206) Which system is normalized?
Explanation:
OLTP
OLAP
207) Data mart is
Explanation:
Data marts are optimized for INSERT, UPDATE operations
Data marts are generally designed for different single subject area
Data marts are generally designed for a single subject area
None of these
208) Snow flake schema
Explanation:
Pointing to Dimensional tables itself are pointed by sub Fact tables.
Pointing to fact tables itself are pointed by sub dimension tables.
Pointing to Datamart itself are pointed by sub dimension tables.
All of these
209) What is Truncate Table option in update-strategy?
Explanation:
Truncate the target table before loading data.
load the table value to another table
delete the data of target which can roll back
none of these
210) Which of these is not a ETL tools in the Market?
Explanation:
Decision
DataStage
Stream
Beacon
211) Which of these is not a reporting tool?
Explanation:
DTS
Analysis service
Essbase
BO
212) Which version of informatica supports data integration for the cloud?
Explanation:
8.1
8.2
9
7.0
213) Can we use sorted input option for incremental aggregation?
Explanation:
yes
no
214) How can you handle multiple matches in lookup transformation?
Explanation:
By Using "Lookup Match" option
By Using "Lookup Policy " option
By Using " Multiple Match" option
By Using "Lookup Policy on Multiple Match" option
215) What are the processes for creating indexes after loading processes completed?
Explanation:
By using session level command task
By Scripting for creating index
By store procedure
All of these
216) Which transformation receives input values from the result of a :LKP expression
in another transformation?
Explanation:
Custom
Connected SP
Unconnected Look-up
none of these
217) How to create a custom join in Source Qualifier transformation?
Explanation: When there is no PM key FK relationship between two table, we can specify custom join by using user
defined join in properties tab of source qualifier.
By using system-defined join
By using custom-defined join
By using user-defined join
none of these
218) IIF( Avg(salary) 20000,1,0)
Can I set this statement in aggregator transformation?
Explanation:
yes
no
219) Can we use the mapping parameter or variable created in one mapping into
Other reusable transformation?
Explanation:
yes
no
220) What is nested aggregate function?
Explanation:
Takes only one output row
Returns only multiple output row
Returns only one output row
Takes multiple output row
221) Which transformations are both connected and on connected?
Explanation:
Stored Procedure
SQL
Lookup
External Procedure
222) How can you connect client to your informatica server if server is located in different place i.e not in
local client? choose correct answers
Explanation:
through pmcmd task
through ftp
ip address
vpn service
223) What is single level aggregate function?
Explanation:
Returns more than one row
Returns only one row
Take input more than one row
Take input one row
1 In a short description, the data warehouse is a collection of data that is primarily used for

Organizational Decision Making

Transaction Processing

Temporary Data Storage

Query Optimization

Application Testing

Data Marts have specific business related purposes.

May be true

FALSE

TRUE

Only at some times

I don't know

The database designed for queries on transactional data is known as

ODS

OLTP

OLAP

OLCP

DSS

This is a quantifiable value such amount of sales, budget or revenue.

Dimension

Database

Datamart

Fact

Datawarehouse

The center of Star schema consists of one or more

Fact tables

Dimension tables

Indexes

Views

Synonyms
6

The process of pulling data from various hetrogeneous source systems is known as

Loading

Transforming

Cleansing

Refreshing

Extraction

Change data capture is a part of

Incremental Extraction

Full Extraction

Online Extraction

Offline Extraction

None

which is used to store data and perform data cleansing,merging before loading into Datawarehousing

ODS

OLTP

Staging

ODS&OLTP

None

The two types of loading available in DWH are

Full Load

Direct Load

Incremental Load

Option 1 & Option 3

Option 1, Option 2 & Option 3

10

The process of converting and summarizing operational data into a consistent, business oriented format

Transformation

Extraction

Loading

None
Option 1, Option 2 & Option 3

11

The latest informatica suite is compatible of

8 Bit

16 Bit

32 Bit

64 Bit

128 Bit

12

Is both Informatica PowerCenter and PowerMart are same

Depends upon the User

NO

YES

Only at some times

I don't know

13

Flat file lookup is one newly added feature in Informatica PowerCenter 7.1version

Depends upon the User

NO

I don't know

Only at some times

YES

14

How many important client components available in Informatica

No client tools

I don't know

15

Which component is used for New server registration in informatica

Designer

Workflow Manager

2&3
Repository Manager

Repository administration console

16

Which Component of informatica is used to configure connection details

Workflow Monitor

Mapping Designer

Workflow Manager

Repository Manager

Worklet Designer

17

which tool is used for users,user groups and priviledges

Designer

Workflow Manager

2&3

Repository Manager

None

18

Where is the actual business rules will be implemented

Source qualifier

Transformation Developer

Workflow Designer

Mapping Designer

Warehouse Designer

19

Is it possible to generate a table in relational database using informatica

Yes

No

sometimes

May be possible

None

20

Which Component of informatica is used to see the performance of the workflow while running

Workflow Monitor

Mapping Designer
Workflow Manager

Repository Manager

Worklet Designer

21

The Repository Manager connects to the repository database through the Repository Server.

Depends upon the User

FALSE

TRUE

Only at some times

I don't know

22

In the Informatica Repository, where is the meta data getting stored?

Synonyms

Dimension tables

Indexes

Database tables

I don't know

23

How the repository server communicates with the repository database

Through native drivers

Third party softwares

LAN Drivers

Logical Paths

I don't know

24

The Repository Server can manage a repository residing on a database on a different machine on the network

Depends upon the User

FALSE

TRUE

Only at some times

I don't know

25

Using the repository manager, the entire repository can be backed up in the format of

Text file
Zip File

XML File

Binary File

I don't know

26

How the repository server create and update the repository tables

Through repository agent process

Through native drivers

Through LAN Drivers

Through PSTN Lines

I don't know

27

When you connecting to the repository, you need to mention the

Your local machine's IP

Your Project Name

Host name and Port no

Your Mobile no

I don't know

28

What is the default repository server connection timeout limit

60 Secs

30 Secs

15 Secs

120 Secs

I don't know

29

For executing a workflow, the PowerCenter server uses the

Designer

DLM Process

DTM Process

DLF Process

I don't know

30

The primary PowerCenter server process is known as

Workflow Manager

Load Manager

Workflow Monitor

Designer

I don't know

31

what are the servers available in informatica

Informatica Server

Workflow Server

Informatica repository Server

Option 1 & Option 3

Option 1 & Option 2

32

Is it necessary to run the Informatica server before accessing Repository

Yes

No

May be true

Sometimes

None

33

You can create and maintain folders in the

Repository Manager

Designer

Workflow Manager

Workflow Monitor

Repository Server

34

If you want to use the same object in several projects, you need to put it in a shared folder

Depends upon the User

FALSE

TRUE

Only at some times

I don't know

35
How many permission types are available for folders

36

Which privilege do you need to execute all tasks across all folders in the repository, and can perform any tasks

Administrator

Read

Write

Super User

Execute

37

For comparing two folders, what is the mandatory permission a user should have.

Read

Write

Execute

Super User

Administrator

38

Which option is need to be checked for creating shortcuts for folders

Create Shortcuts

Allow shortcut

shortcuts

None

Option 1 & Option 2

39

pmcmd is a program that you can use to communicate with

Designer

PowerCenter Server

Workflow Manager

Workflow Monitor

Repository Manager
40

How many modes are available for using pmcmd

2(interactive and commandline)

41

While using pmcmd in command line mode, each command must include the connection information of the

PowerCenter Server

Repository Manager

Workflow Manager

Workflow Monitor

Designer

42

What is the return code for a successful pmcmd command execution

1(not available--connection failed)

0(successful)

3(error)

5(internal pmcmd error)

7(invalid user)

43

What is the pmcmd command for instructing the server to execute the subsequent commands in the wait mode.

setfolder

usefolder

setnowait

setwait

showsettings

44

In which mode of pmcmd, the username, password and server information are required for each command

Interactive mode

Commandline mode

User Mode

Server mode
Wait Mode

45

which mode is used for handling the sessions and workflows

Interactive mode

Commandline mode

User Mode

Server mode

Wait Mode

46

What will be returned if the username and password are incorrect in a command

Zero Return Codes

Non Zero return Codes/7

47

which mode allows writing scripts for scheduling the workflows

Interactive mode

Commandline mode

User Mode

Server mode

Wait Mode

48

Which window in desginer is used to access the repositories.

Output

Workspace

Navigation

Mapping desginer

None

49

How many tools are available in desginer

2
6

50

is it possible to create source and target definition manually

No

Yes

sometimes

Rarely

None

51

what are the types of sources available in informatica

Cobol and XML sources

Flatfiles

Homogeneous& Heterogeneous

2&3

None

52

Minimum number of transformations required for a simple valid mapping

None/(1 atleast)

53

which tool is used to create a reusable transformation

Mapping Designer

Mapplet Desinger

Transformation Developer

Task Developer

Workflow Developer

54

How many types of Transformations available in Informatica 9.0

12

18
3

26

55

is it possible to use a transformation created in one mapping in any other mappings

Yes

No

Sometimes

Rarely

Frequently

56

Is it possible to join two flat files using source qualifier

No

Yes

Sometimes

Rarely

Frequently

57

Can the source qualifier is used to filter cobol source

No

Yes

Sometimes

Rarely

Frequently

58

How many ports are available in Expression Transformation

3(input/output/variable)

None

59

Salary of all employees in an employee table need to be added with the commission.which transformation is used ?

Source Qualifier
Expression transformation

Update strategy

Option 1 & Option 2

Aggregator

60

Which transformations can be used for proceesing the records holding deptno 10 in an employee table

Source Qualifier

only Filter Transformation

only Router Transformation

Option 2 & Option 3

1,2&3

61

Which Transformation is used to load the rejected records

Source Qualifier

only Filter Transformation

only Router Transformation

Option 2 & Option 3

1,2&3

62

Which Transformation is used to handle cobol sources

Source Qualifier

Filter Transformation

Router Transformation

Expression Transformation

Normalizer Transformation

63

What is the transformation used to convert the rows in to columns

Source Qualifier

Filter Transformation

Normalizer Transformation

Expression Transformation

Router Transformation

64

Select a transformation used to load the changed records in target table

Source Qualifier

Filter Transformation

Normalizer Transformation

Expression Transformation

Update Strategy

65

What is the session property enabled when update strategy is used in a mapping

DD_INSERT

DD_DELETE

DD_UPDATE

Data Driven

DD_REJECT

66

What are the transformation used to merge data from multiple sources

Joiner Transformation

Union Transformation

Source Qualifier

Option 1 & Option 2

Option 2 & Option 3

without removing the duplicates

67

which Transformation is used to join flat file and oracle source

Joiner Transformation

Union Transformation

Source Qualifier

Option 1 & Option 2

Option 2 & Option 3

68
Last 3 performer in a department need to loaded in a target table. Which transformation can be used?

Aggregator Transformation

Expression transformation

Rank Transformation

Update Strategy

None

69

What is the transformation used to load the distinct records in a table

Aggregator Transformation

Expression transformation

Rank Transformation

Sorter Transformation

Update Strategy

70

If a sorter transformation is used before Aggregator transformation.Will the performance degrades.

No

Yes

Sometimes

None

Rarely

71

If incremental aggregation option is checked in session properties will the new cache is created during every run

No

Yes

Sometimes

None

Rarely

72

The following is the valid call for a lookup transformation from Expression transformation

LKP.lookup_transformation_name(argument, argument, ...)

:Lookup.lookup_transformation_name(argument, argument, ...)

.LKP.lookup_transformation_name(argument, argument, ...)

:LKP.lookup_transformation_name(argument, argument, ...)

None
73

How to over ride the default order by clause in lookup query

Add required ORDER BY clause and add -- (double highphen at the end of lookup query override

Add required ORDER BY clause in lookup query override

Add required ORDER BY clause and add // (double slashes) at the end of lookup query override

Don’t add lookup condition only add lookup query override

None

74

Can sequence generator be used in Mapplet desginer

Yes

No

Rarely

Sometimes

None

75

is it possible to change the sequence generator properties

Yes

No

Rarely

Sometimes

None

76

Before you run a workflow, the informatica server needs to be registered with

Workflow Manager

Workflow Monitor

Repository Manager

Designer

Web Interface

77

Is it possible to create a worklet inside a worklet

Yes

No

Rarely

Sometimes
None

78

How many internal tools available with Workflow manager to help you develop a workflow

3(task developer,wf designer,worklet dsgn.)

79

Using session properties, can we able to override parameters established in the mapping ?

Depends upon the User

NO

YES

Only at some times

I don't know

80

In which tab of session the connection details of source and targets are configured

Mapping

Components

Properties

Metadata extensions

None

81

What the option "Fail parent if this task fails' will do in session properties

Fails the parent if the current task fails

Fails current task when the parent fails

Fails the current and parent tasks

Fails only current task

None

82

Can we have unlimited sessions in a workflow as we need

YES

NO

Depends on the privielges

Only at some times

I don't know

83

If a task is invalid, the workflow becomes invalid

YES

NO

Depends on the privielges

Only at some times

I don't know

84

Can a command task can be re-used

Depends on the privielges

NO

YES

Only at some times

I don't know

85

which task is used for running a session based on success of another session

Decision

email

event wait

command

None

86

Is it possible to send an email after completion of a workflow in workflow manager

Decision

no

event wait

command

None

87

When you create a workflow, the Workflow Designer creates which task by default

START

Command
Assignment

Email

Event

88

How many types of Workflow variables are available ?

2(pre-defined,user-defined)

89

Is it possible to run the workflow from particular task

Yes

No

Rarely

Sometimes

None

90

Can the session be recovered?

Yes

No

Rarely

Sometimes

None

91

Can we able to start and stop a workflow from workflow monitor

YES

NO

Depends on the privielges

Only at some times

I don't know

92

The Workflow Monitor displays workflows that have run

Never
Once

Twice

Thrice

I don't know

93

Which option should be enabled in session properties to see the performance of each transformation

Collect performance data

Collect data

performance data

Collect performance

None

94

which informatica client tool is used to know the run time and status of a workflow

Repository Manager

Designer

Workflow Manager

Workflow Monitor

None

95

A worklet is an object that represents a set of

Mappings

Tables

Synonyms

Tasks

Web reports

96

When the Informatica Server executes a worklet, it expands the worklet.

YES

NO

Depends on the privielges

Only at some times

I don't know

97

When a mapplet is changed, all instances of the mapplet and all shortcuts to the mapplet
will inherit the changes

will start running

will NOT inherit the changes

will be closed

I don't know

98

Like a reusable transformation, any change made to the mapplet is inherited by all instances of the mapplet.

NO

YES

Depends on the privielges

Only at some times

I don't know

99

Which component is responsible for reading the parameter file and expanding the flow variable values for the workflow

Session Thread

Mapping Thread

Load manager

DTM process manager

I don't know

100

When the Designer validates a mapping variable in a reusable transformation, it treats the variable as

Varchar Datatype

CLOB Datatype

Date Datatype

Integer Datatype

I don't know

101

To debug a mapping, you need to configure and run the Debugger from

Designer

Workflow Manager

Workflow Monitor

Repository Manager

I don't know

102
The place where debugger pauses and allows you to view and edit transformation output data is known as

Break Views

Break Points

Break Windows

Break Sessions

I don't know

103

In general, how many different types of log files are created by PowerCenter Server

3(session log,workflow log,rejectlog)

I don't know

104

With the error tracing level enabled, the Informatica Server logs each row that passes into the mapping

Normal

Terse

Verbose init

Verbose data

I don't know

105

By default, the PowerCenter Server does not save multiple logs for a single workflow.

TRUE

FALSE

Only at some times

Depends upon the User

I don't know

106

When the Server runs in recovery mode, it continues to commit data from the point of the last successful commit

Only at some times

Depends upon the user

TRUE

FALSE

I don't know
107

As a important requirement for data recovery, the source data needs to be

Sorted

Delimted

Fixed Width

Junk characters

I don't know

108

To help you determine which column caused the row to be rejected, the server adds this components to reject files

Key Ranges

Row & Column Indicator

Mapping Parameters

Mapping Variables

I don't know

109

When you configure partitioning for a mapping, which partition type distributes data evenly among all partitions.

Hash

Key Range

Round Robin

Pass Through

I don't know

110

By default, the PowerCenter Server sets the number of partitions to

I don't know

111

A block of memory for temporary storage of data likely to be used again is known as

Session

Cache

Tables

Threads
I don't know

112

If the data doesn’t fit in the memory cache, the server stores the overflow values in

Variables

Parameters

Tables

Cache Files

I don't know

113

Versioning is a concept where you can configure the repository to store multiple versions of objects

Only at some times

Depends upon the user

TRUE

FALSE

I don't know

114

When you checks out an object in the workspace, the repository obtains a

Write Intent lock

Read Intent lock

Executive Lock

Request for closing

I don't know

115

Whenever you're checking in an object, the repository version number is

Decreased

Increased

Not changed

Reset to 0

I don't know

116

If we export a mapping, session or workflow will create

DAT File

REP File

XML File
Cache File

I don't know

117

A deployment group is a versioning object that allows you to group versioned objects for deploying

Different Repository

Same Repository

Different Application

Different OS

I don't know

118

The first step in performance tuning is to identify the

Session Log

Workflow Log

Performance Bottleneck

Cache File

I don't know

119 When we finetune session performance, we can use

Test session option

Test load option

Test Log option

Test Monitor option

I don't know

120 By executing the read query directly against the source database, what can be identified

Source bottlenecks

Target bottlenecks

Mapping bottlenecks

Parameter bottlenecks

I don't know

1. Where are the sources and target information stored?

1. Folders

2. Repository Tables

3. Sessions
4. None of the above

Ans: Informatica Repository Tables

2. What are the different components in Informatica 5.x?

Ans: Informatica Designer, Server Manager and Repository Manager

3. Mention 2 differences between power mart and power centre.

Ans: Power Center - has all the functionality.

 Distributed metadata (repository).

 Global repository and can register multiple Informatica servers. One can share metadata across repositories.

 Can connect to varied sources like Peoplesoft, SAP etc.

 Has bridges which can transport meta data from other tools (like Erwin)

Power Mart – Subset of Power centre.

 One repository and can register only one Informatica server.

 Cannot connect to Varied sources like Peoplesoft, SAP etc

4. Variable ports are used for ___________________________

Ans: Temporary Values

5. What are the parts of Informatica Server?

Ans:

o Load Manager

o Data Transformation manager

o Reader

o Writer

6. List the transformation used for the following:

1. Heterogeneous Sources

2. Homogeneous Sources
3. Find the 5 highest paid employees within a dept.

4. Create a Summary table

5. Generate surrogate keys

Ans:

1. Joiner

2. Source Qualifier

3. Rank

4. Aggregator

5. Sequence Generator

7. What is the difference between sequential batch and concurrent batch?

Ans:

In sequential batch one session will end then the other will begin. Where as in the concurrent. Batch the sessions will
run simultaneously depending on the CPU availability.

Which is recommended – sequential batch or concurrent batch?

Ans: If beginning of one session is dependent on the completion of another session then Sequential is to be adopted,
otherwise concurrent can be used. Concurrent utilizes the CPU resources efficiently.

8. Designer is used for ____________________

1. Importing/creating your Source and Target Definitions

2. Creating Mappings, mapplets and reusable transformations

3. Creating Sessions

4. Create Folders and set privileges

5. None of the above

Ans: a) and b)
9. Repository Manager is used for __________________

Ans:

 Creating/Adding/Backing up/Restoring/Copying Repository

 User Administration and Privileges

 Creating Folders

 Folder Privileges

10. Server Manager is used for ______________________

Ans:

 Configuring the Server

 Creating Source and Target data Sources

 Configuring and monitoring the Session and its properties.

 Starting/Stopping the Session.

 Scheduling

 Error Handling

11. How do you implement scheduling in Informatica?

Ans:

In the session properties choose scheduling option.

12. What is the meaning of upgradation of repository?

Ans:

Upgrade Repository to the new version of Informatica.

13. How can you run a session without using server manager?

Ans: By typing pmcmd …. From command prompt

14. Give examples for pre and post session Commands?

Ans:

Pre session: for disabling the constraints on the target table (fact table) for bulk loading alter constraint pk_fact
disable

Post session: for enabling the constraints on the target table (fact table) after loading is complete.

15. Consider two cases:

1. Power Center Server and Client on the same machine

2. Power Center Sever and Client on the different machines

Which is recommended?

Ans: Option 2

16. The connect strings for source and target databases are to be created in the

1. Informatica Server Workstation

2. Client machine

3. Any of the above

4. Both

Ans: d)

17. When you connect to repository for the first time it asks you for user name & password of repository and
database both. But subsequent times it asks only repository password. Why?

Ans:

It stores the information in Cache or in the Repository tables.

18. What is a test load?

Ans:

Test load option can be chosen to test whether load would take place or not .We do not need to run the session with
all the rows of the source side .It is for Normal Loading. No of rows to test can be specified in Target options in
Session property.
19. How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator
transformation also.

Ans:

Oracle sequence can be used in a Pl/Sql stored procedure, which in turn can be used with stored procedure
transformation of Informatica.

20. What is a mapplet?

Ans:

Mapplet is a reusable component, which we can plug and play into different mapping. It uses transformations, input
port, and output port. Developed in Mapplet designer

21. What is a reusable transformation?

Ans:

Reusable transformation: Developed in transformation developer. It can be invoked from more than one mapping or
Mapplet.

22. Dimension Object created in Oracle can be imported in Designer ( T/ F)

Ans: False

23. Cubes contain measures ( T / F )

Ans: True

24. COM components can be used in Informatica ( T / F )

Ans: True
25. Lookup is an Active Transformation (T/F)

Ans: False; Can be true also if sql override is used.

26. What is the advantage of Lookup persistent cache?

Ans:

When Lookup cache is saved in Look up Transformation It is called persistent cache. The first time session runs it is
saved on the disk and utilized in subsequent running of the Session. It is used when the look up table is Static i.e.
doesn’t change frequently.

27. When will you use SQL override in a lookup transformation?

Ans:

Use Sql override when

 you have more than one look up table

 To use where condition to reduce records in cache.

28. Two different admin users created for repository are ______ and_______

Ans: Administrator and database user of repository schema

29. Two Default User groups created in the repository are ____ and ______

Ans: Administrator and Public

30. A mapping contains

 Source Table S_Time ( Start_Year, End_Year )

 Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

Stored procedure transformation: A procedure has two input parameters I_Start_Year, I_End_Year and output
parameter as O_Date, Day, Month, Year, and Quarter. If this session is running, how many rows will be available in
the target and why?

Ans:

Only one row the last date of the End_Year. All the subsequent rows are overriding the previous rows.

31. A mapping contains

 Source Table S_Time ( Start_Year, End_Year )

 Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

 Lookup transformation LKP_TIM_DIM has two input ports IN_Year and IN_Qtr

How many rows will the Lookup return?

Ans:

Only one row

32. What is the difference between connected lookup and unconnected lookup?

Ans:

Connected Look Up is part of Mapping Data flow. It gives multiple output values on a condition. Support Default
values

Unconnected Look Up is not a part of Mapping Data flow. It is called form other transformations e.g. Expression
Transformation. It has a return port which returns one value generally a flag. Does not Support Default values

33. What is the difference between lookup cache and lookup index.

Ans:

Look up Cache contains Index cache and data cache

Index cache: Contains columns used in condition

34. Look up is created to ______________________________

Ans:

To get a value from another table based on certain condition

35. Mention any four performance issues in Informatica?

Ans:

 Source tuning

 Target tuning

 Repository tuning

 Session performance tuning

 Incremental Change identification in source side.

 Software, hardware (Use multiple servers) and network tuning.

 Bulk Loading

Use the appropriate transformation.

44. Where can you monitor the performance?

 Set performance detail criteria

 Enable performance monitoring

 Monitor session at runtime &/ or Check the performance monitor file.

45. List two approaches for updation of target table in Informatica and

Ans:

 Update strategy transformation:

Normal insert/ update /delete

46. You have created a lookup transformation for a certain condition which if true

returns multiple rows .When you go to the target and see only one row has come.

How it can be handled to return multiple rows?

Ans:
Look up Transformation will return either the first, last match or an error in case of multiple matches. Use Joiner
Transformation for this.

46. Where is the log file generally stored? Can you change the path of the file?

What can the path be?

Ans:

($PMSessionLogDir) by default .Yes

47. Where is the cache (lookup, index) created and how can you see it.

Ans:

The cache is created in the server. Some default memory is allocated for it.

Once that memory is exceeded than these files can be seen in the Cache directory in the Sever.

49. Which is more convenient to join in the database or in Informatica?

Ans:

Source Qualifier query itself, rather than using Joiner transformation

50. How does the recovery mode work in Informatica?

Ans:

In case of load failure an entry is made in OPB_SERV_ENTRY (?) table from where the extent of loading can be
determined

51. What parameters can be tweaked to get better performance from a session?

Ans:

DTM shared memory, Index cache memory, Data cache memory, by indexing, using persistent cache, increasing
commit interval etc

52. How do you measure session performance?

Ans:

By checking "Collect performance Data" check box

54. How many sources at the most can be joined using one joiner transformation?

Ans: Two.

55. What would you do to join more than two sources for example 4 sources?

Ans: Use 3 joiner Transformations.

56. For n source joins how much joiner transformation would one need

Ans: n-1

57. Why is a joiner transformation hamper performance?

Ans: It uses Informatica memory to perform joins.

58. In what way can the performance be enhanced?

Ans: If possible join in the source qualifier itself.

59. How many join types are there in Informatica, explain

Ans: 4 viz.Normal, Master Outer, Detail Outer, Full Outer.

60. In Master Detail join which one should be treated as a Master, why? (For better performance
reasons)

Ans: The source with less number of records should be taken up as Master because with a smaller master source, the
data cache is smaller, and the search time is shorter.

61. What restrictions do you impose on the Source Qualifier to account for large datasets?
Ans: We can put maximum filter/joins conditions in Source qualifier and analyze and tune the query. We can write
the custom query for each and every partition’s source qualifier when we do the session partition.

62. How do you manage incremental loading for large datasets?

Ans: Incremental loading option at the session level can be used. However Incremental loading technique is
preferred as it gives more control to handle the case.

69. Can you name the mechanism in which Informatica collects Information about the performance of a mapping?

Ans: You can view session performance details through the Server Manager or by locating and opening the
performance details file The Informatica Server names the file session_name.PERF, and stores it in the same
directory as session log.

72. Limitations of the use of batches

Ans: We can’t create batch as a reusable in Informatica 5.x but we can reuse set of session as worklet in Informatica
6.x

INFORMATICA QUESTIONNAIRE

DESIGNER – L1

1. Informatica was founded in the year

a) 1994 b) 1993

c) 1993 d) 1997

Ans) b

2. The Mapping designer displays the source instances in _____ mode?

a) Read only mode b) write only mode

c) Read and write d) all

Ans) a
3. The designer displays validation messages in, which window?

a) Navigator window b) output window

c) Workspace window d) none

ans) b

4. Designer is used for ____________________

a) Importing/creating your Source and Target Definitions

b) Creating Mappings, mapplets and reusable transformations

c) Creating Sessions

d) Create Folders and set privileges

e) None of the above

ans) a & b

5. The Designer marks a mapping valid for 3 reasons, two of them is:

a) Object Validation b) Class Validation

c) Filter Validation d) Expression Validation

e) Both a & d f) Both b & c

ans) e

6. We cannot use _________ sources with the mapping wizards.

a) Flat file b) Relational

c) Application d) XML

Ans) d

7. How many partitions can be created in the partition pipeline of a mapping?

a) 8 b) 4

c) 16 d) 20

ans) c

8. …… is the jump from one transformation to any other transformation using the debugger?
a) Step to instance b) Next instance

c) Break points d) none

ans) a

9. Is there is need to re-import the flat file definition if the source definition changes significantly (T/F)

Ans: T

10. We can use ________________ instead of a database lookup.

Ans: Mapping Parameter

11. Default location of the Parameter file is

a) $PMSessionLogDir b) $PMCacheDir

c) $PMSessionLogCount d) $PMSessionLogFile

ans) a

12. Can more than one user can debug the same mapping at the same time

Ans: Yes

13. Conceptually, the Informatica Server holds two different values for a mapping variable during a session run:

a) Start value and end value of a mapping variable

b) Start value and Current value of a mapping variable

c) Current value and end value of a mapping variable

d) It does not hold any values

Ans) b

14. Can we use mapping parameters and variables interchangeably between a mapplet and a mapping?

Ans: No

15. Sources contain _____ type of ports?

a) Input ports b) outports

c) input/output port d) none

Ans) a

16. What is the default join that source qualifier provides?

a) Inner Join b) Outer Join

c) Inner Equi Join d) None

Ans) c

17. What is the default join in the Joiner Transformation?

a) Normal b) Outer

c) Inner d) None

Ans) a

18. Which port you can take as Group by port in Aggregator transformation?

a) Input b) Output

c) Variable d) All

ans) d

19. By default how the informatica server treats Null values in Aggregator functions?

a) ZERO b) Null

c) ONE d) NONE

ans) b

20. Which one is correct for the following example?

The total commission of employees who exceeds their quarterly quota?

a) Sum (commission, commission>quota)

b) Sum (commission, commission>=quota)

c) Sum (commission, commission<quota=)

d) None

ans) a

21. Can we use sorted input option with the Incremental aggregation?

Ans. No
22. Can each separate group (one row) is released as soon as the last row in the group is aggregated in the
aggregator transformation

Ans: Yes

23. The Default cache value for reusable sequence generator

a) 0 b) 10000

c) 1000 d) depends on target table

ans) c

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

a) Start from initial value b) does not effect the session

c) Session fails d) none

ans) c

25. The current value of the Sequence Generator is stored in

a) Repository b) database

c) Memory d) cache

ans) a

26. Can we call a stored procedure or lookup table from a default value expression

Ans: No

27. Where we set the update strategy transformation?

a) With in session b) With in mapping

c) With in repository d) Both A and B

Ans. A

28. What is numeric value for DD_DELETE?

a) 1 b) 2

c) 3 d) 0
ans) b

29. If you do not choose Data Driven when a mapping contains an Update Strategy transformation then Informatica
Server does not follow instructions in the Update Strategy transformation in the mapping.

(True/False)

Ans. True

30. Update the row if it exists. Otherwise, insert it which option is suitable for this one?

a) Update as update b) Update as Insert

c) Delete d) None

Ans. D

31. Which property is not belongs to Update strategy transformation in the mapping?

a) Update strategy expression b) Forward rejected rows

c) Data driven d) Tracing

ans) c

32. 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

a) IIF ((ENTRY_DATE >= APPLY_DATE), DD_REJECT, DD_UPDATE)

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

c) IIF ((ENTRY_DATE > APPLY_DATE), DD_REJECT, DD_UPDATE)

d) None

ans) c

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

a) Static b) Index

c) Persistent d) All

ans) c

34. If Lookup transformation uses dynamic cache which operator we can use in Lookup condition?
a) = b) >=

c) <= d) None

ans) a

35. What type of caches available in Filter transformation?

a) Index b) Data

c) Both a & b d) None

ans) d

36. Can the reject rows forwarded through the mapping?

Ans: Yes

37. Default Sorter Transformation cache size is

a) 2 mb b) 4 mb

c) 8 mb d) 16 mb

ans) c

38. Aggregator functions returns summary values for non-null data in selected ports (T/F)

Ans: T

39. Joiner transformation can be used in which of the following cases:

a. Both input pipelines originate from the same Normalizer transformation.

b. Two instances of the same XML sources

c. Two relational tables existing in separate database

d. All of the above

ans) b & c

40. We use the Update Strategy Transformation before or after the lookup, to flag rows for ……… to the target

a) Insert b) Update

c) Insert & Update d) Update & Reject

ans) c

41. … Means the row will not have SQL written for it

a) DD_INSERT b) DD_REJECT

C) DD_UPDATE d) DD_DELETE

ans) b

42. How many tabs do the session property consists

a) 7 b) 9

c) 8 d) 6

ans) b

43. Config object tab in a session properties includes ….. Settings

a) Commit b) load

c) Commit & load d) none

ans) c

44. Can we run multiple stored procedures that use the same database connection

Ans: Yes

45. When the stored procedure transformation is after the joiner transformation, the informatica server uses the
database connection for the

a) Detail table b) master table

c) Target table d) source table

ans) b

46. Call text is used to call the stored procedure only when the stored procedure type is Normal (T/F)

Ans: F

47. All rows of data from the detail source and the matching rows from the master source this type of join called as?

a) Master-outer b) Normal
c) Detail-outer d) Full-outer

ans) a

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

a) Source pre-load b) target pre-load

c) Source post-load d) target post-load

ans) b

49. Can we run same instance of stored procedure in both connected and unconnected mode in the mapping

Ans: No

50. If the source is the relational synonyms, can we extract that into the source analyzer?

Ans: Yes

51. Targets within the same folder that reference the target through a foreign key relationship. b) Global and local
shortcuts to the target. c) Mappings using the target

d) Mapplets using the targets

ans) d

INFORMATICA QUESTIONNAIRE

DESIGNER (L2)

1. Worklet variables are used for

a) Reference values b) record information

c) Both a & b d) None of the above

ans) c

2. To override a worklet variable initial values we assign ………….. Variables

a) Mapping variable b) Mapping Parameter

c) Workflow variable d) User defined variable

ans) c

3. Workflow manager displays a ………. Invalid icon if the worklet instance in the workflow is invalid

a) Red b) Blue

c) Yellow d) Green

Ans: b

4. Multiple Active mapplets or Active and Passive Mapplets can populate the same target instance (T/F)

Ans: F

5. By enabling the Enhanced security option it gives ……. permissions

a) Read & Write b) Read, Execute & Write

c) Execute & Write d) No Permissions

Ans: b

6. User defined worklet variable can be ……..

a) Persistent b) Non-Persistent

c) Both a&b d) None

Ans: c

7. Thumb rule for the System Variables are

a) $ b) $$

c) $$$ d) None

8. From the below which transformation cannot make reusable

a) ERP Source Qualifier b) Rank

c) Sequence Generator d) None

Ans: a

9. ……… allows a row to know about the handling of a previous row

a) Static cache b) Dynamic Lookup Cache

c) Persistent Cache d) Shared Cache

Ans: b

10. What tracing level of Informatica Server logs initialization information as well as error message and notification of
rejected data?

a) Normal b) Verbose Init

c) Verbose Data d) Terse

Ans: d

11. The number of threads depends on the ______________ information for each pipeline.

a) Partition b) Expression

c) CPU bandwidth d) none of the above

Ans: a

12. Where will the Informatica server stores data until it completes aggregate calculations?

a) Memory b) Repository

c) Database c) Cache

Ans) c

13. Sequential Snapshot in the update strategy means

a) New records Insert b) target truncated

c) Incremental with update d) both a & b

Ans: a

14. Where you enable the Incremental Aggregation?

a) Mappings b) Mapplets

c) Sessions d) All

Ans: C

15. Where do you configure the Index and Data caches of Aggregator transformation?

a) Session properties b) Aggregator transformation

c) Both a & B d) None

Ans. C

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

a) Aggregator expression contains nested aggregate functions

b) Source uses Incremental aggregation

c) Source data is Data-driven

d) All

Ans. D

17. I used a Sequence Generator in mapping and I have done some testing on this particular mapping, after the
testing I want to migrate the said mapping in to the production, in this particular scenario, how can I set the
Sequence Generator to its Initial Value?

a) Set the current value to 1

b) Remove from mapping and recreate it

c) Both a & b

d) None

Ans. C

18. Assume that we have a large input file which has been separated into three parallel running sessions, if we are
using an non-reusable Sequence Generator then what job that the informatica server does?

a) Generates unique values

b) Might generate duplicate values

c) None

Ans. B

19. Edit mode allows users with folders ………… permissions to change or create transformation ports and properties

a) Read b) write

c) Execute d) None

Ans: b

20. Variable ports are not visible in ……… view

a) Normal b) Iconized

c) Edit d) None

Ans: a

21. Which database has limitation on No. of lookup/output ports?

a) Informix b) SQL server

c) Sybase d) Oracle

Ans. C

22. In general when we get multiple matches in lookup transformation?

a) Lookup condition is not based on Unique key

b) Lookup table is normalized

c) Both the above

d) None

Ans: a

23. What happens if the Lookup transformation uses dynamic cache and multiple matches?

a) Fails session b) Takes first value

c) Takes last value d) both b&c

Ans. A

24. Can we specify worklet events in the Event task in the parent workflow

(T/F)

Ans: F

25. The workflow that contains the worklet is called the ………….. Workflow

Ans: Parent

26. Which database does not support user-defined return values

a) Sybase b) Oracle

c) Informix d) Post gray SQL

Ans: c

27. For performance wise which source we will take as master source in joiner transformation?

a) Source with smaller no of records

b) Source with larger no of records

c) Does not depend on records

d) None

Ans. A

28. Where can you set the collect performance details?

a) Transformation b) Mappings

c) Mapplets d) Sessions

Ans. D

29. What is the order of identifying performance bottleneck?

a) Source -> Target->Mapping->Session->System

b) Target->Source->Mapping->Session->System

c) System->source->Target->Mapping->Session

d).Mapping->Session->System->Source->Target

Ans. B

30. To increase the performance of target the target load type must be

a) External load b) Normal load

c) Decrease Checkpoint intervals d) Build indexes

Ans. A

31. If the session reads from a relational source what we have to do to improve session performance?

a) Use conditional filters

b) Connect to Oracle databases using IPC protocol

c) Optimize Query

d) All
Ans. D

32. In which situations conditional filter may use?

a) Multiple targets

b) Multiple sessions reads from same source

c) Multiple sessions reads from different sources

d) None

Ans. B

33. Single-pass reading allows you to populate multiple targets with multiple source qualifiers. (T/F)

Ans. True

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

a) Decimal b) Double

c) Integer d) All

Ans. C

35. External stored procedure transformation object resides at

a) Informatica repository b) Informatica server

c) Repository server d) Informatica Client Applications

Ans: a

36. Informatica Server uses …… environment variables defined on the server plat form to locate the dynamic link
library or shared object on window operating system

a) PATH b) LD_LIBRARY_PATH

c) SHLIB_PATH d) LIBPATH

Ans: a

37. Can we perform a test load on sessions using XML sources (T/F)
Ans: F

38. Can we enable test load option and truncate target table option in the session properties (T/F)

Ans: F

39. Can we use a Normalizer transformation with relational sources (T/F)

Ans: T

40. Suppose in the customer table the zip code is in the form of 9854-230 if we convert the zip code data type into
integer data type how the lookup database stores that zip code?

a) 9-8-5-4-2-3-0 b) 9/8/5/4/2/3/0

c) 9854230 d) None

Ans. C

41. To reduce the amount of time spent writing to the session log file which tracing level is better to set

a) Verbose data b) Verbose init

c) Terse d) Normal

Ans. C

42. To use the reject load utility which tracing level we have to use?

a) Verbose data b) Verbose init

c) Terse d) Normal

Ans. D

43. In lookup transformation which cache we have to use to improve session performance?

a) Shared cache b) Persistent cache

c) Recache from database d) both a & b

Ans. D

44. For cached lookups we can improve performance by indexing the columns in the lookup by using ORDER BY
clause (T/F)

Ans. True
45. There three lookup cache counters having numbers 2000, 4000, 10000 from this identify which one has benefit
for performance tuning?

a) 2000 b) 10000

c) 4000 d) All

Ans. B

46. When you want to look up a small set of unchanging values which informatica function may improve session
performance?

a) IIF b) ISNULL

c) DECODE d) None

Ans. C

47. Using which counters we have to identify session bottleneck in aggregator, joiner and rank transformations a)
Read from disk b) Write to disk

c) Both a & b d) none

Ans: c

48. The Informatica Server reads expressions written with operators slower than expressions with functions. (T/F)

Ans. False

49. What happens to the session performance if the bufferinput_efficency, bufferoutput_efficency shows low
numbers?

a) High b) Low

c) No effect d) none

Ans: b

50. Disabling of high precision the numeric data converted to which data type?

a) Integer b) Decimal

c) Character d) Double

Ans: d
51. The column size in the lookup condition is 16 and having no of records 20000 what might be the index cache
size?

a) < 40000 b) Between 20000 & 40000

c) Between 64000 & 128000 d) > 128000

Ans: c

52. Which is not effect on performance tuning of mapping?

a) Reducing the no. of cached rows

b) Optimizing lookup condition

c) Indexing lookup table

d) None

Ans: d

53. In The lookup table has Item_id and promotion_id columns item_id in lookup condition no of rows in the lookup
table is 30000 and both the columns have column size 16 what might be the data cache size?

a) 54000 b) 60000

c) 72000 d) 48000

Ans: c

54. Characters in the Parameter file must be a subset of

a) Repository server code page b) Informatica Server Code page

c) Repository Agent code page d) Informatica client code page

Ans: b

55. To improve the session performance increase data cache size more than index cache size (T/F)

Ans: T

56. To improve the session performance which one has to be done?

a) Increase the no. of partitions

b) Remove reduce tracing errors

c) Staging Area

d) Above all
Ans: d

57. When do you use SQL override in look up transformation?

a) More than one lookup table

b) To use where condition reducing no of records in cache

c) Both A and B

d) None

Ans: c

58. We use the Normalizer transformation with COBOL sources, which are often stored in

a) Denormalized b) Normalized

c) Hierarchial d) none

Ans: a

59. Can we handle multiple level of denormalization in the same record by using a single normalizer transformation?
(T/F)

Ans: T

60. Advanced External Procedures supports

a) COM procedures b) Informatica Procedures

c) COM and Informatica Procedures d) Oracle Procedures

Ans: b

Document Title: Definition of Competency Grading

Competency Code: INF

Competency: INFORMATICA

Version: 5.x/6.x

Objective: This document lists out the various roles based on which candidates can take up the certification and
grade them at various levels based on their expertise.
Sno Roles Levels Subject Prerequisite Code
Areas/Topics

1 Designer L1 Informatica Basics, Beginners INF_DES_L1

(DES) who have
Designer
attended
Components, the
Mappings, Informatica
Training at
Transformations, Satyam
Session Creation,
Debugging a
Session, Test the
Load

L2 Mapplets, Level 1 (L1) INF_DES_L2

candidates
Reusable with 6
transformations, months
Normalizer, Project
experience
Lookup in
Transformation Informatica
Tuning,

Performance
Tuning

L3 Advanced Mapping Candidates INF_DES_L3

Techniques and with > 1
year Project
Performance experience
Tuning in
Informatica

2 Administrator L1 Repository INF_ADM_L1

Manager,
(ADM)
Server
Manager/Workflow
Manager

L2 Advanced INF_ADM_L2
Techniques for
Repository

3 Consultant L1 INF_CON_L1
(CON)

L2 INF_CON_L2

L3 INF_CON_L3

NOTE:

 Questionnaire can be Role Based - Level based i.e. 3 sets of questionnaire for Designer(Level 1,2,3), 2 sets for
administrator(Level 1,2) and 3 sets for Consultant (Level 1,2,3)

 Training Materials can be in the form of sessions so that Level 1 (L1) candidates may or may not take up all the
sessions

 Training Materials will be in the form of PPT (Slides),Lab Exercises, Case Studies

 Case Studies should be detailed enough that it addresses the Level 1,2 and 3 candidates

INFORMATICA QUESTIONNAIRE

INFORMATICA DESIGNER (L1 & L2)

1. The Mapping designer displays the source instances in _____ mode?

a) read only mode b) write only mode

c) read and write d) all

ANS) A

2. The designer displays validation messages in, which window?

a) navigator window b) output window

c) workspace window d) none

Ans: b

3. Designer is used for ____________________

a) Importing/creating your Source and Target Definitions

b) Creating Mappings, mapplets and reusable transformations

c) Creating Sessions

d) Create Folders and set privileges

e) None of the above

Ans: a & b

4. The Designer marks a mapping valid for 3 reasons, two of them is:

a) Object Validation b) Class Validation

c) Filter Validation d) Expression Validation

e) Both a & d f) Both b & c

Ans) a & d

5. We cannot use _________ sources with the mapping wizards.

a) Flat file b) Relational

c) Application d) XML

Ans) d

6. How many partitions can be created in the partition pipeline of a mapping?

a) 8 b) 4

c) 16 d) 20

Ans: c

7. …… is the jump from one transformation to any other transformation using the debugger?

a) Step to instance b) Next instance

c) Break points d) none

Ans: a

8. Is there is need to re-import the flat file definition if the source definition changes significantly (T/F)

Ans: T

9. We can use ________________ instead of a database lookup.

Ans: Mapping Parameter

10. Default location of the Parameter file is

a) $PMSessionLogDir b) $PMCacheDir

c) $PMSessionLogCount d) $PMSessionLogFile

Ans: a

11. Can more than one user can debug the same mapping at the same time (T/F)

Ans: T

12. Conceptually, the Informatica Server holds two different values for a mapping variable during a session run:

a) Start value and end value of a mapping variable

b) Start value and Current value of a mapping variable

c) Current value and end value of a mapping variable

d) It does not hold any values

Ans: b

13. Can we use mapping parameters and variables interchangeably between a mapplet and a mapping? ( T/F)

Ans: False

14. Sources contain _____ type of ports?

a) input ports b) outports

c) input/output port d) none

ANS) A

15. What is the default join that source qualifier provides?

a) Inner Join b) Outer Join

c) Inner Equi Join d) None

Ans: c

16. What is the default join in the Joiner Transformation?

a) Normal b) Outer
c) Inner d) None

Ans: a

17. Where you enable the Incremental Aggregation? (l2)

a) Mappings b) Mapplets

c) Sessions d) All

Ans: C

18. Which port you can take as Group by port in Aggregator transformation?

a) Input b) Output

c) Variable d) All

Ans. D

19. Where do you configure the Index and Data caches of Aggregator transformation?l2

a) Session properties b) Aggregator transformation

c) Both a & B d) None

Ans. C

20. By default how the informatica server treats Null values in Aggregator functions?

a) ZERO b) Null

c) ONE d) NONE

Ans. B

21. Which one is correct for the following example?

The total commission of employees who exceeds their quarterly quota?

a) Sum (commission, commission>quota)

b) Sum (commission, commission>=quota)

c) Sum (commission, commission<quota=)

d) None

Ans. A
22. Can we use sorted input option with the Incremental aggregation? (T/F)
Ans. False

23. In our Mapping Filter and Aggregator transformation are there for better performance where do you put the
Filter transformation? L2

a) Before Aggregator b) After Aggregator

c) Does not effect d) none

Ans. A

24. I selected sorted input option but workflow takes same amount of time as before .What is the reason for this?l2

a) Aggregator expression contains nested aggregate functions

b) Source uses Incremental aggregation

c) Source data is Data-driven

d) All

Ans. D

25. Can each separate group (one row) is released as soon as the last row in the group is aggregated in the
aggregator transformation (T/F)

Ans: T

26. Transformation errors are written in the l2-n

a) Session log file b) Workflow log file

c) Bad file d) none

Ans: a

27. The Default cache value for reusable sequence generator

a) 0 b) 10000

c) 1000 d) depends on target table

Ans. C
28. I used a Sequence Generator in mapping and I have done some testing on this particular mapping, after the
testing I want to migrate the said mapping in to the production, in this particular scenario, how can I set the
Sequence Generator to its Initial Value? L2

a) Set the current value to 1

b) Remove from mapping and recreate it

c) Both a & b

d) None

Ans. C

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

a) Start from initial value b) does not effect the session

c) Session fails d) none

Ans. C

30. Assume that we have a large input file which has been separated into three parallel running sessions, if we are
using an non-reusable Sequence Generator then what job that the informatica server does? L2

a) generates unique values

b) Might generate duplicate values

c) None

Ans. B

31. Edit mode allows users with folders ………… permissions to change or create transformation ports and properties
l2

a) Read b) write

c) Execute d) None

Ans: b

32. Variable ports are not visible in ……… view l2

a) Normal b) Iconized

c) Edit d) None

Ans: a
33. Can we call a stored procedure or lookup table from a default value expression (T/F)

Ans: F

34. Where we set the update strategy transformation?

a) With in session b) With in mapping

c) With in repository d) Both A and B

Ans. D

35. In the update strategy transformation if you do not select Forward Rejected Rows where the Informatica Server
stores the rejected rows? L2-n

a) Session reject file b) Session log

c) Both A and B d) None

Ans. B

36. What is numeric value for DD_DELETE ?

a) 1 b) 2

c) 3 d) 0

Ans. B

37. If you do not choose Data Driven when a mapping contains an Update Strategy transformation then Informatica
Server does not follow instructions in the Update Strategy transformation in the mapping. (True/False)

Ans. True

38. Update the row if it exists. Otherwise, insert it which option is suitable for this one?

a) Update as update b) Update as Insert

c) Delete d).None

Ans. D

39. When can you select the option Truncate Table? L2-n

a) Before extract the source b) After loading

c) Before loading d) After Extracting

Ans. C

40. Which property is not belongs to Update strategy transformation in the mapping?

a) Update strategy expression b) Forward rejected rows

c) Data driven d) Tracing

Ans. C

41. 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

a) IIF ((ENTRY_DATE >= APPLY_DATE), DD_REJECT, DD_UPDATE)

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

c) IIF ((ENTRY_DATE > APPLY_DATE), DD_REJECT, DD_UPDATE)

d) None

Ans. C

42. Which database has limitation on No.of lookup/output ports? L2

a) Informix b) SQL server

c) Sybase d) Oracle

Ans. C

43. In general when we get multiple matches in lookup transformation? L2

a) Lookup condition is not based on Unique key

b) Lookup table is normalized

c) Both the above

d) None

Ans: a

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

a) Static b) Index

c) Persistent d) All

Ans. C
45. If Lookup transformation uses dynamic cache which operator we can use in Lookup condition?

a) = b) >=

c) <= d) None

Ans. A

46. What happens if the Lookup transformation uses dynamic cache and multiple matches? L2

a) Fails session b) Takes first value

c) Takes last value d) Both B&c

Ans. A

47. What type of caches available in Filter transformation?

a) Index b) Data

c) Both of the above d).None

Ans: d

48. Aggregator functions returns summary values for non-null data in selected ports (T/F)

Ans: T

49. Default Sorter Transformation cache size is

a) 2 mb b) 4 mb

c) 8 mb d) 16 mb

Ans: c

50. Can the reject rows forwarded through the mapping (T/F)

Ans: T

51. From the below which transformation cannot make reusable l2

a) ERP Source Qualifier b) Rank

c) Sequence Generator d) None

Ans: a
52. ……… allows a row to know about the handling of a previous row l2

a) Static cache b) Dynamic Lookup Cache

c) Persistent Cache d) Shared Cache

Ans: b

53. What tracing level of Informatica Server logs initialization information as well as error message and notification of
rejected data? L2

a) Normal b) Verbose Init

c) Verbose Data d) Terse

Ans: d

54. The number of threads depends on the ______________ information for each pipeline. L2

a) Partition b) Expression

c) CPU bandwidth d) none of the above

Ans: a

55. Where will the Informatica server stores data until it completes aggregate calculations? L2

a) Memory b) Repository

c) Database c) Cache

Ans) c

56. Joiner transformation can be used in which of the following cases:

a. Both input pipelines originate from the same Normalizer transformation.

b. Two instances of the same XML sources

c. Two relational tables existing in separate database

d. All of the above

Ans) b & c

57. We use the Update Strategy Transformation before or after the lookup, to flag rows for ……… to the target

a) Insert b) Update
c) Insert & Update d) Update & Reject

Ans: c

58 ……. Means the row will not have SQL written for it

a) DD_INSERT b) DD_REJECT

C) DD_UPDATE d) DD_DELETE

59. Sequential Snapshot in the update strategy means l2

a) New records Insert b) target truncated

c) Incremental with update d) both a & b

Ans: a

60. Can the system variable SESSSTARTTIME used in the SQL override (T/F)

Ans: F

61. Mapplets contains ____ type of ports?

a) input ports b) output ports

c) input/output port d) none

62. Multiple Active mapplets or Active and Passive Mapplets can populate the same target instance (T/F)

Ans: F

63. Worklet variables are used for

a) Reference values b) record information

c) Both a & b d) None of the above

Ans: c

64. To override a worklet variable initial values we assign ………….. Variables

a) Mapping variable b) Mapping Parameter

c) Workflow variable d) User defined variable

Ans: c
65. Can we specify worklet events in the Event task in the parent workflow (T/F)

Ans: F

66. Workflow manager displays a ………. Invalid icon if the worklet instance in the workflow is invalid

a) Red b) Blue

c) Yellow d) Green

Ans: Blue

67. The workflow that contains the worklet is called the ………….. Workflow

Ans: Parent

68. By enabling the Enhanced security option it gives ……. permissions

a) Read & Write b) Read, Execute & Write

c) Execute & Write d) No Permissions

Ans: b

69. Multiple Passive mapplets can populate the same target instance (T/F)

Ans: T

70. User defined worklet variable can be ……..

a) Persistent b) Non-Persistent

c) Both a&b d) None

Ans: c

71. Can worklet variables persist when we run on the same workflow (T/F)

Ans: T

72. Can we execute two instances of the same worklet concurrently across two different workflows (T/F)

73. Minimum no. of transformations required to built a mapplet

a) 3 b) 4

c) 2 d) 5

Ans: a

74. If we use a Stored Procedure transformation in a mapplet, stored procedure type should be …………..

Ans: Normal

75. If the mapplet contains SQL override, we must connect all mapplet output ports in the mapping (T/F)

Ans: T

76. Characters in the Parameter file must be a subset of

a) Repository server code page b) Informatica Server Code page

c) Repository Agent code page d) Informatica client code page

Ans: b

77. Thumb rule for the System Variables are

a) $ b) $$

c) $$$ d) None

78. Can we use breakpoints on mapplet input and output transformations (T/F)

Ans: F

79. How many tabs do the session property consists

a) 7 b) 9

c) 8 d) 6

Ans: b

80. Config object tab in a session properties includes ….. settings

a) commit b) load

c) commit & load d) None

Ans: c
81. Can we run multiple stored procedures that use the same database connection (T/F)

Ans: T

82. Call text is used to call the stored procedure only when the stored procedure type is Normal (T/F)

Ans: F

83. When the stored procedure transformation is after the joiner transformation, the informatica server uses the
database connection for the

a) detail table b) master table

c) target table d) source table

84. When you use $Source and $Target in an unconnected stored procedure transformation then

a) Session fails b) Mapping invalids

Ans: a

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

a) Source pre-load b) target pre-load

c) Source post-load d) target post-load

Ans: b

86. Which database does not support user-defined return values l2

a) Sybase b) Oracle

c) Informix d) Post gray SQL

Ans: c

87. Can we run same instance of stored procedure in both connected and unconnected mode in the mapping (T/F)

Ans: F
88. For performance wise which source we will take as master source in joiner transformation? L2

a) Source with smaller no of records

b) Source with larger no of records

c) Does not depend on records

d) None

Ans. A

89. All rows of data from the detail source and the matching rows from the master source this type of join called as?

a) Master-outer b) Normal

c) Detail-outer d) Full-outer

Ans. A

90. Where can you set the collect performance details?

a) Transformation b) Mappings

c) Mapplets d) Sessions

Ans. D

91. What is the order of identifying performance bottleneck?

a) Source -> Target->Mapping->Session->System

b) Target->Source->Mapping->Session->System

c) System->source->Target->Mapping->Session

d).Mapping->Session->System->Source->Target

Ans. B

92. To increase the performance of target the target load type must be

a) External load b) Normal load

c) Decrease Checkpoint intervals d) Build indexes

Ans. A

93. If the session reads from a relational source what we have to do to improve session performance?
a) Use conditional filters

b) Connect to Oracle databases using IPC protocol

c) Optimize Query

d) All

Ans. D

94. In which situations conditional filter may use?

a) Multiple targets

b) Multiple sessions reads from same source

c) Multiple sessions reads from different sources

d) None

Ans. B

95. Single-pass reading allows you to populate multiple targets with multiple source qualifiers. (T/F)

Ans. True

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

a) Decimal b) Double

c) Integer d) All

Ans. C

97. External stored procedure transformation object resides at

a) Informatica repository b) Informatica server

c) Repository server d) Informatica Client Applications

Ans: a

98. Informatica Server uses …… environment variables defined on the server plat form to locate the dynamic link
library or shared object on window operating system

a) PATH b) LD_LIBRARY_PATH

c) SHLIB_PATH d) LIBPATH
Ans: a

99. Can we perform a test load on sessions using XML sources (T/F)

Ans: F

100. Can we enable test load option and truncate target table option in the session properties (T/F)

Ans: F

101. Can we use a Normalizer transformation with relational sources (T/F)

Ans: T

102. Suppose in the customer table the zip code is in the form of 9854-230 if we convert the zip code data type into
integer data type how the lookup database stores that zip code?

a) 9-8-5-4-2-3-0 b) 9/8/5/4/2/3/0

c) 9854230 d) None

Ans. C

103. To reduce the amount of time spent writing to the session log file which tracing level is better to set

a) Verbose data b) Verbose init

c) Terse d) Normal

Ans. C

104. To use the reject load utility which tracing level we have to use?

a) Verbose data b) Verbose init

c) Terse d) Normal

Ans. D

105. In lookup transformation which cache we have to use to improve session performance?

a) Shared cache b) Persistent cache

c) Recache from database d) both a & b

Ans. D

106. For cached lookups we can improve performance by indexing the columns in the lookup by using ORDER BY
clause (T/F)
Ans. True

107. There three lookup cache counters having numbers 2000, 4000, 10000 from this identify which one has benefit
for performance tuning?

a) 2000 b) 10000

c) 4000 d) All

Ans. B

108. When you want to look up a small set of unchanging values which informatica function may improve session
performance?

a) IIF b) ISNULL

c) DECODE d) None

Ans. C

109. The Informatica Server reads expressions written with operators slower than expressions with functions. (T/F)

Ans. False

110. In joiner transformation to minimize memory requirements use smaller table as Detail source. (T/F)

Ans: F

111. Using which counters we have to identify session bottleneck in aggregator, joiner and rank transformations a)
Read from disk b) Write to disk c) Both a & b d) None

112. To improve the session performance increase data cache size more than index cache size (T/F)

Ans: T

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

a) Create shortcuts

b) Copy objects

c) Export and import repository objects

d) Use shortcut keys

e) All

Ans) E

114. You cannot select multiple ports or columns when editing COBOL sources in the Source Analyzer (T/F)

Ans: T
115. If the object is Target, then what are the dependencies that are not displayed?

a) Targets within the same folder that reference the target through a foreign key relationship. b) Global and local
shortcuts to the target. c) Mappings using the target d) Mapplets using the target

ANS) D

116. If the object is source, then what are the dependencies that are not displayed?

a) Sources within the same folder that reference the source through a foreign key relationship. b) Global and local
shortcuts to the source. c) Mapplets using the source. d) Mappings using the source e) none

ANS) E

117. If the source is the relational synonyms, can we extract that into the source analyzer (T/F)

Ans: T

118. If you add a column for the source definition, then the mapping is _____

a) Invalidated b) not invalidated c) Mappings may be invalidated d) none

Ans. b

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

a) Data type b) Format c) Redefines d) Occurs e) All

Ans. e

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

a) Source name b) database location c) column names d) key constraints e) all

Ans. e

JOINER

1.Which one is not regarding joiner transformation?

1. Two relational tables existing in separate databases

2. Two different ODBC sources

3. A relational table and an XML source

4. None

Ans.D
2.In which situations joiner transformation is not used?

1. Both input pipelines originate from the same Source Qualifier transformation

2. Both input pipelines originate from the same Normalizer transformation

3. Either input pipeline contains an Update Strategy transformation

4. All

Ans.D

3. The Informatica Server discards all rows of data from the master and detail source that do not match, based on
the condition this join called as?

A.Masterouter

B.Normal

C.Detailouter

D.Fullouter

Ans.B

4.All rows of data from the detail source and the matching rows from the master source this type of join called as?

A.Masterouter

B.Normal

C.Detailouter
D.Fullouter

Ans.A

5. All rows of data from the master source and the matching rows from the detail source this type of join called as?

A.Masterouter

B.Normal

C.Detailouter

D.Fullouter

Ans. C

6.Discards all rows of data from both the master and detail sources this type of join called as?

A.Masterouter

B.Normal

C.Fullouter

D.None

Ans.D
7.For performance wise which source we will take as master source in joiner transformation?

A.Source with smaller no of records

B.Source with larger no of records

C.Does not depend on records

D.None

Ans.A

LOOKUP

1.Lookup Transformation is used to lookup the data in

A. View

B. Synonym

C. Relationaltable

D. All the above

Ans.D

2.If you set the lookupcondition empty what happens to the mapping?

A.Does not effect the mapping

B.Invalidate the mapping

C.Effects the Session Performance

D.None

Ans.B
3.In Unconnected Lookup transformation if condition is met what the Informatica server returns.

A Default

B. Null

C. Zero

D. Null

Ans.B

4.How many time you can call unconnected lookup transformation in the mapping?

A.One

B.Depends on the source type

C.Any no of times

D.All the above

Ans.C

5.To Import the Lookup table what we require?

1. Informaticaserver connection

2. InformaticaClient connection

3. Both

4. None

Ans.C

6.How many Returnports available in Unconnected Lookuptransformation?

1. Any number

2. Only one

3. Depends on Lookup table

4. None

Ans.B

7.What happens if the Lookuptransformation uses dynamic cache and multiple matches?

A.Fails session

B.Takes firstvalue

C.Takes lastvalue

D.Both B&c

Ans.A

8.Which database has limitation on no of lookup/output ports?

A.Informix

B.SQl server

C.Sybase

D.Oracle

Ans.C
9.If you have more than one lookup condtion in lookup transformation for better lookup performance which
condition has to place first?

A.Condition with >

B.condition With =

C.Condition with <

D.No constraint

Ans. B

10.In general when we get multilple matches in lookup transformation?

A.Lookup condition is not based on Unique key

B.Lookup table is normalized

C.Both the above

D.None

Ans.A

11.If Lookup transformation uses dynamic cache which operator we can use in Lookup condition?

A.=
B.>=

C.<=

D.None

Ans.A

12.Which one is cache is not available in Lookup transformation?

A.Persistent cache

B.Shared cache

C.Recache from databae

D.None of the above

Ans.D

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

A.Static

B.Index

C.Persistent

D.All

Ans.C
14.You can share named cache between the transformations in different mapping.

True/False

Ans.True

15. I have two tables Customer and Company

Customer Company

ID, Name, CUST_CHK CUST_CHK, STATUS_IND etc

Then I want to lookup cust_chk exists in the company table if the row exists then I want to set staus_ind Y else N how
can we achieve this?

Ans.By using this we can achieve

iif(isnull(lkp_Cust_chk),'N','Y')

MAPPINGS

1. Mapping parameters and variables appear on the Variables tab of the Expression Editor.

2. Can we use mapping parameters and variables interchangeably between a mapplet and a mapping? Ans : No

3. Default value for a new mapping using an Integer mapping variable is

1. 1

2. 0

3. blank

4. -1
Ans: 0

4. we can use ________________ instead of a database lookup?

Ans : mapping parameter

5. Conceptually, the Informatica Server holds two different values for a mapping variable during a session run:

1. Start value and end value of a mapping variable

2. Start value and Current value of a mapping variable

3. Current value and end value of a mapping variable

4. It does not hold any values

Ans: b

6. When the session is a debug session, the Informatica Server save the final current value of a mapping variable to
the repository?

1. True

2. False

Ans : False

7. We can clear variable values for a session using the :

1. Workflow Manager

2. Workflow Monitor

3. Repository Manager

4. Designer

Ans : Workflow Manager

8. What variable functions do we use in the Rank or Aggregator transformation?

1. SetcountVariable

2. SetMaxVariable

3. SetMinVariable
4. Use different transformation for variable functions

Ans: d

9. Mappings represent the data flow between

1. Sources and targets

2. Sources and source Analyzer

3. Transformation and Targets

4. Sources and Transformation

Ans) a

10. Mapping Designer displays objects in three different views. What are they?

1. Iconized, maximized, Normal

2. Normal, Edit, Iconized

3. Edit, Minimized, Iconized

4. Maximized, Minimized, Edit

Ans) b

11. The Designer marks a mapping valid for 3 reasons, two of them is:

1. Object Validation

2. Class Validation

3. Filter Validation

4. Expression Validation

Ans ) a & d

12. We can identify the Mapping Bottlenecks using __________ transformation?

1. Filter

2. Aggregator

3. Lookup
4. Update Strategy

Ans) a

13. We cannot use _________ sources with the mapping wizards.

1. Flat file

2. Relational

3. Application

4. XML

Ans) d

14. _________________ transformation is designed to handle data read from COBOL sources.

1. Normalizer

2. Sequence Generator

3. Router

4. Advanced External Procedure

Ans) a

P3

1.Ths column size in the lookup condition is 16 and having no of records 20000 what might be the index cache size?

A.Less than 40000

B.Between 20000 and 40000

C.Between 64000 and 128000

D.Greater than 128000

Ans.C

(Index size= No of rows * (columnsize+16) *2)

2.What happens to the mapping performance if the mapping contains lookup transformation and cache is enabled?

A.Decrese the performance

B.Increase the performance

C.Not effect

D.None

Ans.B

3.Which is not effect on performance tuning of mapping?

A.Reducing the no of cached rows

B.Optimizing lookup condition

C.Indexing lookup table

D.None

Ans.D

4.What happens to performance the lookup order by columns contains indexes ?

A.Increases
B.No effect

C.Decreases

D.None

Ans.A

5.In The lookup table has Item_id and promotion_id columns item_id in lookup condition no of rows in the lookup
table is 30000 and both the columns have columnsize 16 what might be the datacache size?

A.54,000

B.60,000

C.72,000

D.48.000

Ans.C

PERFORMANCE TUENING

1. Where can you set the collect performance details?

A. Transformation

B. Mappings

C. Mapplets

D. Sessions
Ans.D

2. What is the order of identifying performance bottleneck?

A. Source -> Target->Mapping->Session->System

B. Target->Source->Mapping->Session->System

C. System->source->Target->Mapping->Session

D. Mapping->Session->System->Souce->Target

Ans. B

3. What is the Cause of Target bottleneck?

1. small check point intervals

2. small database network packet size

3. Problems during heavy load

D.All

Ans.D

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

A. Use External load

B. Use Normal load

C. Decraese Checkpoint intervals

D. Build indexes

Ans.A

5. How can identify source bottleneck?

A. Filter transformation

B. Expression

C. Lookup

D.All
Ans.A

6. If the session reads from a relational source what we have to done to improve session performance?

A. Use conditional filters

B. Connect to Oracle databases using IPC protocol

C. Optimize Query

D. All

Ans.D

7. When joining large tables on a Sybase or Microsoft SQL Server database to improve performance by creating the
tempdb as an in-memory database to allocate sufficient memory.

True/False

Ans.True

8. In which situations conditional filter may use?

A.Multiple targets

B.Multiple sessions read from same source

C. Multiple sessions reads from different sources

D.None

Ans.B

9. Where do you put the filter transformation to identify mapping bottleneck?

A.Nearer to source

B.Before the aggregator

C.Nearer to target

D.All

Ans.C
10. Single-pass reading allows you to populate multiple targets with multiple source qualifiers.

True/False

Ans.True

11.Which datatype is preferable when making comparisions using lookup and filter transformations?

A.Decimal

B.Double

C.Integer

D.All

Ans.C

12.Suppose in the customer table the zip code is like this 9854-230 if we convert the zipcode data type into integer
data type how the lookup database stores that zipcode?

A.9-8-5-4-2-3-0

B.9/8/5/4/2/3/0

C.9854230

D.None

Ans.C

13. To reduce the amount of time spent writing to the session log file which tracing level is better to set

A.Verbosedata

B.Verboseint

C.Terse

D.Normal

Ans.C

14.Touse the rejectload utility which tracing level we have to use?

A.Verbosedata

B.Verboseint

C.Terse

D.Normal

Ans.D

15.In lookup transformation which cache we have to use to improve session performance?

A.Shared cache

B.Persistent cache

C.Recache from database

D.Both A and B

Ans.D

16.For cached lookups You can improve performance by indexing the columns in the lookup ORDER BY

True/False

Ans.True

17.For uncached lookups you can imrove the performance by removing indexes those columns in lookup condition

True/False

Ans.False

18.There three lookup cache counters having numbers 2000,4000,10000 from this identify which one have benefit
from performance tuning?

A.2000

B.10000

C.4000

D.All

Ans.B
19. when you want to look up a small set of unchanging values which function may improve session performance?

A.iiF

B.IsNull

C.Decode

D.None

Ans.C

20. The Informatica Server reads expressions written with operators slower than expressions with functions.

True/False

Ans.False

21.I have a table employee I want the data only of deptno 10 using filter I am achieving this one to improve session
performance where do you put the filter transformation?

A.Nearer to target

B.After the Lookup

C.Neare to source

D.None

Ans.C

22.Which is one correct to optimize Aggregator transformation?

A. Group by simple columns.

B. Use sorted input

C. Use incremental aggregation

D.All

23.In joiner transformation to minimize memory requirements use smaller table as Detail source.

True/False
Ans.False

24.Using which counters we have to identify session bottleneck in aggregator, joiner and rank transformations

A.Read from disk

B.Write to disk

C.Both

D.None

Ans.C

25.To improve the session performance increase datacache size more than index cache size

True/False

Ans.True

26.To improve the session performance which one have to done?

A. Increase the number of partitions

B. Remove Reduce errors tracing

C. staging areas

D.All

Ans.D

27.What happens to the session performance if the bufferinput_efficency, bufferoutput_efficency shows low
numbers?

A.High

B.Low

C.Not effect

D.None

Ans.B
28.What happens to the session if the commitinterval is too high and informatica server fill the database logfile?

A.Success

B.Fail

C.Does not effect

D.None

Ans.B

29.Disabling of highprecision the numeric data converted to which datatype?

A.Integer

B.Decimal

C.Char

D.Double

Ans.D

4. Using multiple PowerCenter Servers on separate systems might decrease the session performance.

True/False

Ans.False
30. Configure the Informatica Server for EBCDIC data movement mode might decrease the session performance.

True/False

Ans.True

6.If the targetdatabase is on the server system what happens to the informatica server performance?

A.Might decrease

B.Might Increase

C.No effect

D.None

Ans.B

PERFORMANCE TUENING 1

12.Suppose in the customer table the zip code is like this 9854-230 if we convert the zipcode data type into integer
data type how the lookup database stores that zipcode?

A.9-8-5-4-2-3-0

B.9/8/5/4/2/3/0

C.9854230

D.None
Ans.C

13. To reduce the amount of time spent writing to the session log file which tracing level is better to set

A.Verbosedata

B.Verboseint

C.Terse

D.Normal

Ans.C

14. To use the reject load utility which tracing level we have to use?

A.Verbosedata

B.Verboseint

C.Terse

D.Normal

Ans.D

15.In lookup transformation which cache we have to use to improve session performance?
A. Shared cache

B.Persistent cache

C.Recache from database

D.Both A and B

Ans.D

16.For cached lookups You can improve performance by indexing the columns in the lookup ORDER BY

True/False

Ans.True

17.For uncached lookups you can imrove the performance by removing indexes those columns in lookup condition

True/False

Ans.False

18.There three lookup cache counters having numbers 2000,4000,10000 from this identify which one have benefit
from performance tuning?

A.2000

B.10000

C.4000
D.All

Ans.B

19. when you want to look up a small set of unchanging values which function may improve session performance?

A.iiF

B.IsNull

C.Decode

D.None

Ans.C

20. The Informatica Server reads expressions written with operators slower than expressions with functions.

True/False

Ans.False

21.I have a table employee I want the data only of deptno 10 using filter I am achieving this one to improve session
performance where do you put the filter transformation?

A.Nearer to target

B.After the Lookup

C.Neare to source
D.None

Ans.C

22.Which is one correct to optimize Aggregator transformation?

A. Group by simple columns.

B. Use sorted input

C. Use incremental aggregation

D.All

23.In joiner transformation to minimize memory requirements use smaller table as Detail source.

True/False

Ans.False

24.Using which counters we have to identify session bottleneck in aggregator,joiner and rank transformations

A.Read from disk

B.Write to disk

C.Both

D.None

Ans.C

25.To improve the session performance increase datacache size more than index cache size

True/False

Ans.True

26.To improve the session performance which one have to done?

A. Increase the number of partitions

B. Remove Reduce errors tracing

C. staging areas

D.All

Ans.D

PERFORMANCE TUENING
1.What happens to the session performance if the bufferinput_efficency, bufferoutput_efficency shows low
numbers?

A.High

B.Low

C.Not effect

D.None

Ans.B

2.What happens to the session if the commitinterval is too high and informatica server fill the database logfile?

A.Success

B.Fail

C.Does not effect

D.None

Ans.B

3.Disabling of highprecision the numeric data converted to which datatype?

A.Integer

B.Decimal
C.Char

D.Double

Ans.D

4. Using multiple PowerCenter Servers on separate systems might decrease the session performance.

True/False

Ans.False

5. Configure the Informatica Server for EBCDIC data movement mode might decrease the session performance.

True/False

Ans.True

6.If the targetdatabase is on the server system what happens to the informatica server performance?

A.Might decrease

B.Might Increase

C.No effect

D.None

Ans.B

REPOSITORY

1.To start the workflow you require super suer previlage

True/false

Ans. True

2 In_use lock placed on objects you want to view.

True/False

Ans.True

3.Write_intent lock place on objects you want to modify

True/False

Ans.True

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

a) create shortcuts

b)copy objects

c)export and import repository objects

d)use shortcut keys

e) all

Ans) E

2) You cannot select multiple ports or columns when editing COBOL sources in the Source Analyzer

a)TRUE

b)FALSE

ANS)A
3)If the object is Target ,then what are the dependencies that are not displayed?

a)Targets within the same folder that reference the target through a foreign key relationship.

b)Global and local shortcuts to the target.

c)Mappings using the target

d) Mapplets using the target

ANS)D

4) If the object is source ,then what are the dependencies that are not displayed?

a) Sources within the same folder that reference the source through a foreign key relationship.

b)Global and local shortcuts to the source.

c)Mapplets using the source.

d)Mappings using the source

e)None

ANS)E

5)If the source is relational synonyms can we extract that into source analyzer?

a)true

b)false

ANS)A

6)If you add a column for the source definition , then the mapping is _____

a)invalidated

b)not invalidated

c) Mappings may be invalidated

d)none

ANS)B

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

a)Datatype

b)Format

c) Redefines

d)Occurs

e)All
ANS)E

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

a)source name

b)database location

c)column names

d)key constraints

e)all

ANS)E

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

a)FD Section

b)Fields

c)OCCURS

d)REDEFINES

e)All

ANS)E

2)For populating and maintaining databases , which transformation we use?

a)update strategy

b)stored procedure

c)lookup

d)none

ANS)B

3)Which of the following repository objects is not supported by mapplet?

a)joiner transformations

b)normalizer transformations

c)target definitions

d)none

ANS)D

4) You want to use the same session to extract transaction records for each of your customers individually.Which one
is best , Instead of creating a separate mapping for each customer account?

a) create a mapping parameter to represent a single customer account

b) create a mapping variable to represent a single customer account

c)both

d)none

ANS)A

5)Can we use the mapping parameters or variables created in one mapping into another mapping?

a)yes

b)no

ANS)No

6)Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

a)Yes

b)No

ANS)Yes

7)If the Informatica server requires more space , it stores overflow values in ___ files?

a)cache files

b)database

c)local variables

d)none

ANS)A

8)In a mapping both pipelines begin with the same data source. In this case can we use the joiner transformation?

a)Yes

b)No

ANS)No

9)Which of the following type is the default in joiner transformation?

a)full outer

b)detail outer

c)master outer

d)Normal

ANS)D

10)If your source table includes employee ID, but you want to include the employee name in your target table to
make your summary data easier to read. In this case which transformation we use?

a)update strategy
b)stored procedure

c)lookup

d)none

ANS)C

11)In unconnected lookup transformation , we cannot use static cache?

a)True

b)False

ANS)False

12) In connected lookup transformation , we cannot use dynamic cache?

a)True

b)False

ANS)False

13)If we are using lookup transformation , by default the informatica server creates ______ cache.

a)static cache

b)dynamic cache

c)index cache

d)data cache

ANS)A

14)In lookup transformation , we can save the lookup cache files and reuse them the next time the informatica
server processes a lookup transformation configured to use the cache. This type of cache is called _______ ?

a)Shared cache

b)Dynamic cache

c)Persistent cache

d)Static cache

ANS)C

15) Can we share the lookup cache in lookup transformation?

a)Yes

b)No

ANS)Yes

16) _________ is a set of source and target definitions linked by transformation objects that define the rules for
transformation

a) Session
b) Mapping

c) Batch

d) None

ANS)B

17) Can we use variables or parameters created in mapplet , in another mapping or mapplet?

a)Yes

b)No

ANS)No

18) Can we include source definitions in reusable transformations?

a)Yes

b)No

ANS)No

19)Can we add sources to Mapplets?

a)Yes

b)No

ANS)No

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

a) create shortcuts

b)copy objects

c)export and import repository objects

d)use shortcut keys

e) all

Ans) E

21) You cannot select multiple ports or columns when editing COBOL sources in the Source Analyzer

a)TRUE

b)FALSE

ANS)A
23)If the object is Target ,then what are the dependencies that are not displayed?

a)Targets within the same folder that reference the target through a foreign key relationship.

b)Global and local shortcuts to the target.

c)Mappings using the target

d) Mapplets using the target

ANS)D

24) If the object is source ,then what are the dependencies that are not displayed?

a) Sources within the same folder that reference the source through a foreign key relationship.

b)Global and local shortcuts to the source.

c)Mapplets using the source.

d)Mappings using the source

e)None

ANS)E

25)If the source is relational synonyms can we extract that into source analyzer?

a)true

b)false

ANS)A

26)If you add a column for the source definition , then the mapping is _____

a)invalidated

b)not invalidated

c) Mappings may be invalidated

d)none

ANS)B

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

a)Datatype

b)Format

c) Redefines

d)Occurs

e)All
ANS)E

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

a) Source name

b) Database location

c) Column names

d) Key constraints

e) All

ANS) E

29).Variable ports are available in which of the following transformations?

a)expression

b)rank

c)aggregator

d)All

ANS)D

30)which of the following port is useful for storing temporary values?

a)variable port

b)rank port

c)output port

d)lookup port

ANS)A

31)For input ports default values are used for _______

a)to handle transformation calculation errors

b) To replace null values

c)both

d)none

ANS)B

32)I have connected two ports of which the first port datatype is string and the second port data type is char.
Whether it is valid or not?

a) it is valid

b) invalid

c)only ,if uses source qualifier it is valid

d)none

ANS)B

33) If we change the definition of the transformation , and we want to be the transformation to be inherited all
changes , then it must be ________

a) standard transformation

b)reusable transformation

c) connected to other transformation

d) not connected to any other transformation

ANS)B

34)My source is relational database. I want to load data based on the department location. I have 4 locations. If data
belongs to location A then I want to load it to Target A. If data belongs to location B, then I want to load it to Target B
and so on.. In this situation which transformation is most useful?

a) Filter transformation

b) Sequence generator

c) source qualifier

d) Router transformation

ANS)D

35)Which of the following contains a set of transformations and allows you to reuse that transformation logic in
multiple mappings.

a)mapping

b)mapplet

c)business component

d)none

ANS)B

36)

SEQENCE GENERATOR

1.We have a large input file then I am separate into three running sessions in parallel,I am using non reusable
sequencegenerator then what the informatica server done?

A.genarates unique values

B.Might generate duplicate values

C.None

Ans. B

2. If we donot set the cycle option in sequence generator what happens when it reaches maxium value ?

A.Start from initial value

B.does not effect the session

C.session fails

D.None

Ans.C

3.The Default cache value for reusable sequence generator

A.0

B.10000

C.1000

D.Depends on target table

Ans.C

4.Which one not correct regarding sequence generator?

A.Generate keys
B.Replace missing value

C.Cycle through a range of sequential numbers

D.None

Ans.D

5.I used sequence generator in the mapping and i have done some testing and I want to migrating in to production
then how can I set sequence generator to the initial value?

A. set the current value to 1

B. remove from mapping and recreate it

C.Both

D.None

Ans.C

TRANSFORMATIONS

1. Transformation can be

1. Active b) Passive

c) a & b d) None of above

Ans) C

2. _______________ limits the row set extracted from a source, while the ________ limits the row set sent to a
target

a) Source Qualifier, Lookup b) Source Qualifier, Filter

c) Filter, Source Qualifier d) Aggretator, Filter

Ans) b
3. Joiner transformation can be used in which of the following cases:

1. Both input pipelines originate from the same Normalizer transformation.

2. Two instances of the same XML sources

3. Two relational tables existing in separate database

4. All of the above

Ans) b & c

4. The Joiner transformation supports the following join types:

1. Normal b) Slave Outer

3. Full Outer d) None of the above

Ans) a & c

5. The join which keeps all rows of data from both the Master and detail sources

a) Full Outer join b) Normal

c) Master Outer Join d) None of the above

Ans) a

6. What tracing level of Informatica Server logs initialization information as well as error message and notification
of rejected data?

a) Normal b) Verbose Init

c) Verbose Data d) Terse

Ans) d

7. Mappings can contain standard and reusable transformations?

True/False

Ans) True

8. The number of thread depends on the ______________ information for each pipeline.

a) Partition b) Expression

c) CPU bandwidth d) None of the above

Ans) Partition

9. Where will the Informatica server stores data until it completes aggregate calculations?

a) Memory b) Repository

c) Database c) Cache

Ans) c

10. We can use local variables in __________ transformations.

a) Aggregator b) lookup

c) Expression d) Rank

Ans) a,c & d

UPDATE STRATEGY

1.Where we set the updatestrategy transformation?

A.With in session

B.With in mapping

C.With in repository

D.Both A and B

Ans.D

2.In updatestrategy transformation If you do not select Forward Rejected Rows where the Informatica Server stores
the rejected rows?

A.Session reject file

B.Session log

C.Both A and B

D.None

Ans.B

3.What is numeric value for DD_DELETE ?

A.1

B.2

C.3

D.0

Ans.B

4. If you do not choose Data Driven when a mapping contains an Update Strategy transformation then Informatica
Server does not follow instructions in the Update Strategy transformation in the mapping.

True/False

Ans.True

5. Update the row if it exists. Otherwise, insert it which option is suitable for this one?

A.Update as update

B.Update as Insert

C.Delete
D.None

Ans.D

(Update else Insert Correct answer)

6.When can you select the option Truncate Table?

A.Before Extraxct the source

B.After loading

C.Before loading

D.After Extracting

Ans.C

7.Which property is not belongs to Update strategy transformation in the mapping?

1. Update strategy expression

B. Forward rejected rows

C. Data driven

D. Tracing

Ans. C
8.In my source there are two fileds Entrydate and applydate I want to reject the data if the entrydate is after the
applydate for this which expression correct

A IIF( ( ENTRY_DATE >= APPLY_DATE), DD_REJECT, DD_UPDATE )

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

C IIF( ( ENTRY_DATE > APPLY_DATE), DD_REJECT, DD_UPDATE )

D.None

Ans.C