Informatica ETL | Testing | Mock Test

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