Question - 1
Which Client component can be used for creating Repository?
Repository Manager
Designer
Workflow Manager
Repository Server Administration Console
Answer- D
Question - 2
Informatica Server uses the following environment variable defined on the server plat form to locate the dynamic link library or shared object on window operating server
PATH
LD_LIBRARY_PATH
SHLIB_PATH
LIBPATH
Answer- A
Question - 3
External Stored procedure transformation object resides at
Repository Server
Informatica Server
Repository Database
Informatica Client Machine
Answer- C
Question - 4
By default how does the Informatica server treat NULL values in aggregator functions?
Zero
null
one
none of above
Answer- B
Question - 5
Where will you set the type of Update for an Update Strategy transformation?
In session
In mapping
In repository
In workflow
Answer- B
Question - 6
If the lookup table is not changed in between sessions, which cache is better to use?
Static
index
Persistent
Dynamic
Answer- C
Question - 7
If lookup transformation uses dynamic cache which operator we can use in lookup condition?
Equal to
not equal to
greater than equal to
less than equal to
Answer- A
Question - 8
What will happen when the Informatica Server encounters multiple matches for a dynamic Lookup transformation
It returns all the results
It returns the first matching value
It returns an error
It returns the values one by one sequentially
Answer- C
Question - 9
From the below which transformation cannot be reusable?
ERP Source Qualifier
Dynamic lookup cache
Sequence Generator
Aggregator
Answer- A
Question - 10
All rows of data from the detail source and the matching rows from the master source are selected.This type of join called ____?
Master-Outer
Detail-Outern
Full-Outer
Inner-Join
Answer- A
Question - 11
What is the default Sorter Transformation Cache size
4000000 bytes
8000000 bytes
16000000 bytes
32000000 bytes
Answer- B
Question - 12
When the stored procedure transformation is after the joiner transformation, the informatica server uses the database connection of the ___ table?
Detail table
Master table
Target table
none of above
Answer- B
Question - 13
Data scrubbing is which of the following ?
A process to reject data from the data warehouse and to create the necessary indexes
A process to load the data in the data warehouse and to create the necessary indexes
A process to upgrade the quality of data after it is moved into a data warehouse
A process to upgrade the quality of data before it is moved into a data warehouse
Answer- D
Question - 14
Which database does not support user-defined return values?
SQL Server
Informix
Oracle
none of above
Answer- B
Question - 15
Characters in the parameter file must be a subset of which page?
Repository server code page
Information Server code page
Repository agent code page
Informatica client code page
Answer- C
Question - 16
Where will the Informatica server store data until it completes Aggregate calculations?
Database
File
Cache
Client Cookies
Answer- A
Question - 17
Informatica server holds two different values for a mapping Variable. What are they called as?
Start value/End value
Start Value/Current Value
Start Value/Persistent Value
Start Value/Active Value
Answer- B
Question - 18
Where is the Source and Target information stored?
Repository Database
Repository Server
Informatica Server
Files
Answer- A
Question - 19
In what version of Informatica FlatFile Lookup Is available.
Infa 5
Infa 6
Infa 7
All the above
Answer- C
Question - 20
In ASCI I mode for each character, how many bytes are required.
1 byte
4 byte
8 byte
256 byte
Answer- A
Practice more set questions
