Informatica.R@ireps
- 1.
No of transformations in informatica 6.1
- A.
13
- B.
18
- C.
12
- D.
22
Correct Answer
A. 13 -
- 2.
------------------- tools play an important role in creating the mapping and converting the Business requirements into an ETL code.
- A.
Designer
- B.
Work flow manager
- C.
Integration services
Correct Answer
A. Designer -
- 3.
No of transformations in informatica 8x _____________.
- A.
18
- B.
33
- C.
22
- D.
12
Correct Answer
A. 18 -
- 4.
The Designer consists of __________________ windows.
- A.
4
- B.
5
- C.
7
- D.
6
Correct Answer
C. 7 -
- 5.
_____________window is used to view transformation data while you run the Debugger to debug a mapping.
- A.
Instance
- B.
Navigator
- C.
Ouput
Correct Answer
A. Instance -
- 6.
Renaming of ports is done in ____________.
- A.
Designer
- B.
Workflow manager
- C.
Workflow monitor
Correct Answer
A. Designer -
- 7.
During _______________ the Informatica Server writes the transformed data to targets.
- A.
Mapping
- B.
Workflow
- C.
Session
- D.
Task
Correct Answer
C. Session -
- 8.
Non aggregate calculations can be performed by
- A.
Expression transformation.
- B.
Aggregator transformation
- C.
Filter transformation.
- D.
All of the above.
Correct Answer
A. Expression transformation. -
- 9.
we can enter multiple expressions in a single Expression transformation
- A.
True
- B.
False
Correct Answer
A. True -
- 10.
TRUE and FALSE are ________ return values from any condition you set .
- A.
Implicit
- B.
Explicit
- C.
Specify in expression
- D.
B and c
Correct Answer
A. Implicit -
- 11.
Where we Specify a Filter Condition in a Filter Transformation.
- A.
Transformation.
- B.
In expresion by specifying port as output
- C.
Ports.
- D.
Properties tab.
- E.
both b and c.
Correct Answer
D. Properties tab. -
- 12.
The input ports for the filter must come from a___________ transformation.
- A.
Single.
- B.
Multiple.
- C.
both 1 and 2.
- D.
Source qualifier.
Correct Answer
A. Single. -
- 13.
IIF (ISNULL (FIRST_NAME), FALSE, TRUE)
- A.
This condition states that if the FIRST_NAME port is NULL, the return value is FALSE and the row should be discarded. Otherwise, the row passes through to the next transformation.
- B.
This condition states that if the FIRST_NAME port is NULL, the return value is TRUE and the row passes through to the next transformation. Otherwise, the row should be discarded.
- C.
This condition states that if the FIRST_NAME port is NULL, the return value is TRUE and the row should be discarded. Otherwise, the row passes through to the next transformation.
Correct Answer(s)
A. This condition states that if the FIRST_NAME port is NULL, the return value is FALSE and the row should be discarded. Otherwise, the row passes through to the next transformation.
B. This condition states that if the FIRST_NAME port is NULL, the return value is TRUE and the row passes through to the next transformation. Otherwise, the row should be discarded. -
- 14.
The filter condition is case sensitive
- A.
True
- B.
False
Correct Answer
A. True -
- 15.
If the filter condition evaluates to NULL, the row is treated as
- A.
False
- B.
True
- C.
Null
- D.
Rows rejected
Correct Answer
A. False -
- 16.
For each row that returns FALSE, in filter transformation theIntegration Service drops and writes a message to
- A.
Session log
- B.
Debugger
- C.
Repository services
- D.
Cache
Correct Answer
A. Session log -
- 17.
Store the results of an unconnected Lookup transformation.
- A.
Variable
- B.
Mapping parameter
- C.
Port
- D.
Session parameter
Correct Answer
A. Variable -
- 18.
The _____________ transformation is used to calculate values in a single row before you write to the target.
- A.
Expression
- B.
Filter
- C.
Aggregator
- D.
Lookup
Correct Answer
A. Expression -
- 19.
Variables are used to
- A.
Temporarily store data.
- B.
Capture multiple return values from a stored procedure.
- C.
Compare values.
- D.
Nly 1 and 3
Correct Answer(s)
A. Temporarily store data.
B. Capture multiple return values from a stored procedure.
C. Compare values. -
- 20.
Any native connection is faster than odbc
- A.
True
- B.
False
Correct Answer
A. True -
- 21.
Which of the following are not stored in metadata
- A.
Log files
- B.
Session files
- C.
Cache
- D.
Source, target tables
Correct Answer
A. Log files -
- 22.
Only powercenteric services can be done by admin control in version 8
- A.
True
- B.
False
Correct Answer
A. True -
- 23.
Types of repositaries
- A.
Stand alone and global
- B.
Standalone
- C.
Global
Correct Answer
A. Stand alone and global -
- 24.
DTM process improves the performance by using the tecnique
Correct Answer
push down optimization - 25.
Transformations can be viewed in how many ways
- A.
3
- B.
2
- C.
1
- D.
4
Correct Answer
A. 3 -
- 26.
Work flow manager doesnot validate SQL statements
- A.
True
- B.
False
Correct Answer
A. True -
- 27.
Variable and output ports are seen in
- A.
Expression transformation
- B.
Aggregator transformation
- C.
Rank transformation
- D.
All of the above
Correct Answer(s)
A. Expression transformation
B. Aggregator transformation
C. Rank transformation -
- 28.
M denotes port comes from in transformation
- A.
Master source
- B.
Source table
- C.
To specify the join condition
- D.
Detail table
Correct Answer
A. Master source -
- 29.
Cache is used to store
- A.
Master table data
- B.
Detail table data
- C.
Source
- D.
Target
Correct Answer
A. Master table data -
- 30.
All aggregator functions should be in
- A.
Output port
- B.
Mixed port
- C.
Variable port
- D.
Group by port
Correct Answer
A. Output port -
- 31.
Expression editor can be seen in
- A.
Aggregator
- B.
Expression
- C.
Update strategy
- D.
Joiner
- E.
Router
Correct Answer(s)
A. Aggregator
B. Expression
C. Update strategy -
- 32.
What transformations can be unconnected
- A.
Look up
- B.
Update strategy
- C.
Stored procedure
- D.
Sequence generator
Correct Answer(s)
A. Look up
C. Stored procedure -
- 33.
SQL transformation is from version
- A.
8
- B.
7
- C.
6
- D.
9
Correct Answer
A. 8 -
- 34.
When we use unconected look up
- A.
Must be Unconnected (or “function mode”) Lookup
- B.
Lookup function used within a conditional statement
- C.
When ever expression editor is there
Correct Answer(s)
A. Must be Unconnected (or “function mode”) Lookup
B. Lookup function used within a conditional statement -
- 35.
Ther can be only one lookup port
- A.
True
- B.
False
Correct Answer
A. True -
- 36.
to cache or not cache?
- A.
Each Mapping row needs one SQL SELECT--uncached
- B.
Cached-Only one SQL SELECT is needed
- C.
Mapping rows are looked up against the cache
Correct Answer(s)
A. Each Mapping row needs one SQL SELECT--uncached
B. Cached-Only one SQL SELECT is needed
C. Mapping rows are looked up against the cache -
- 37.
Cache if
- A.
The number (and size) of records in the Lookup table is small relative to the number of mapping rows requiring lookup
- B.
large cache memory is available for Integration Service
- C.
None
Correct Answer(s)
A. The number (and size) of records in the Lookup table is small relative to the number of mapping rows requiring lookup
B. large cache memory is available for Integration Service -
- 38.
What is optional window in designer
- A.
Navigator
- B.
Work space
- C.
Status
- D.
Overview
Correct Answer
D. Overview -
- 39.
By default, Lookup caches
- A.
Not persistent
- B.
Persistent
- C.
Static
- D.
Dynamic
Correct Answer
A. Not persistent -
- 40.
When session is completed cache is
- A.
Erased
- B.
Override
- C.
Rebuilt
Correct Answer
A. Erased -
- 41.
When Session completes, the persistent cache is stored on the
- A.
machine hard disk files
- B.
Repository manager
- C.
Meta daa
Correct Answer
A. machine hard disk files -
- 42.
No input ports are allowed in
- A.
Sequence generator
- B.
Source qualifier
- C.
Filter
- D.
Expression
Correct Answer
A. Sequence generator -
- 43.
A code page must be assigned to the Integration Service process which should be compatible with the
- A.
Repository service code page
- B.
Repository server code page
- C.
Informatica server code page
Correct Answer
A. Repository service code page -
- 44.
Which transformation performs comparisions and groupings
- A.
Rank
- B.
Expression
- C.
Filter
- D.
Router
Correct Answer
A. Rank -
- 45.
Which transformation is used to convert rows into columns
- A.
Normalizer
- B.
Source qualifier
- C.
Expression
- D.
Rank
Correct Answer
A. Normalizer -
- 46.
Lookup Transformation is used in mapping to look up data in
- A.
Relational table
- B.
View
- C.
Synonym
Correct Answer(s)
A. Relational table
B. View
C. Synonym -
- 47.
How many types of tasks are available in work flow manager of informatica 6.2
- A.
7
- B.
6
- C.
5
- D.
3
Correct Answer
A. 7 -
- 48.
Which tranformation can not be used in mapplet
- A.
Normalizer
- B.
Source qualifier
- C.
Expression
- D.
Filter
Correct Answer
A. Normalizer -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Apr 06, 2012Quiz Edited by
ProProfs Editorial Team -
Apr 06, 2012Quiz Created by
Keerthim
Back to top