Trend Nxt Informatica ETL | Testing | Question and Answers


Informatica ETL | Testing | Mock Test

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

Answer : Workflow Designer
2
Different types of Facts in DWH
a. Confirmed
b. Semi additive
c. Junk
d. Advanced
Answer : Semi additive
3
Different Ways to filter the records in Informatica?
a. Sequence Generator Transformation
b. Sorter Tranformation
c. Router transformation
d. Additive
Answer : Router transformation
4
How do we debug the data in Informatica tool
a. Repository manager
b. Meta data manager
c. Debugger
d. No Limit
Answer : Debugger
5
How do we load the data using Informatica?
a. Workflow Designer
b. Repository manager
c. Mapping designer
d. Log Generator
Answer : Workflow Designer
6
How many number of sessions that you can create in a batch?
a. 10
b. 50
c. 100
d. No limit
Answer : No limit
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
Answer : Using Lookup Transformation
8
How to execute informatica jobs from OS
a. Server Manager
b. PMCMD
c. A and B
d. Information Analyzer
Answer : PMCMD
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
Answer : Using source qualifier
10
informatica designer window consists of
a. Navigator
b. Log Generator
c. Debugger
d. pmcmd
Answer : Navigator

Have any Question or Comment?

Leave a Reply

Exciting Offers

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 90 other subscribers

Exciting Offers

Exciting Offers

Exciting Offers

Close
%d bloggers like this: