Informatica ETL | Testing | Mock Test

1
Different Tools in Workflow Manager
a. Repository manager
b. Maplet designer
c. Workflow Designer
d. Additive
Show Answer

2
Different types of Facts in DWH
a. Confirmed
b. Semi additive
c. Junk
d. Advanced
Show Answer
3
Different Ways to filter the records in Informatica?
a. Sequence Generator Transformation
b. Sorter Tranformation
c. Router transformation
d. Additive
Show Answer
4
How do we debug the data in Informatica tool
a. Repository manager
b. Meta data manager
c. Debugger
d. No Limit
Show Answer
5
How do we load the data using Informatica?
a. Workflow Designer
b. Repository manager
c. Mapping designer
d. Log Generator
Show Answer
6
How many number of sessions that you can create in a batch?
a. 10
b. 50
c. 100
d. No limit
Show Answer
7
How to determine whether the incoming record already exists in the target table?
a. Using Router Transformation
b. Using Lookup Transformation
c. Using Aggregate Transformation
d. Writing a select query on toad
Show Answer
8
How to execute informatica jobs from OS
a. Server Manager
b. PMCMD
c. A and B
d. Information Analyzer
Show Answer
9
How to join two tables without using the Joiner Transformation?
a. Using source qualifier
b. Using expression transformation
c. Using router transformation
d. Filter Transformation
Show Answer
10
informatica designer window consists of
a. Navigator
b. Log Generator
c. Debugger
d. pmcmd
Show Answer