Informatica MCQs Set: 3

Informatica MCQs Set: 3

Informatica free practice questions lets you to boost your confidence on nuances of informatica techonology.A great place for you to enhance your knowledge.

Most Frequently asked Informatica Interview Questions and Answers: This article is covering the top Informatica MDM, PowerCenter, Workflow Manager, Workflow Monitor, Designer etc.

Q1)if the data does not change from session to session the cache use is

Ans.. persistant cache 

11. Which of the following is/are true?
(a) If session is valid, Mapping will be valid
(b) If Mapping is invalid, Session will be invalid
(c) If session is invalid, Mapping will be invalid
(d) If session is valid, Mapping can be invalid
 (I have no idea about this…)

12. Joiner Can
(a) Join any two heterogeneous sources
(b) Join only Sources of same database
(c) Join only Flatfiles
(d) Join only Flatfile and database

13. Which of the following is/are true for Normalizer?

(a) Converts Rows into Columns

(b) Converts Columns into Rows

(c) Normalizer is active Transformation

(d) Normalizer is passive Transformation

REASON:

            Normaliser transformation is a Active and Connected Transformation and it is generally used to create multiple rows of data from a single row. Eg:

The following source rows contain four quarters of sales by store:
Source Table

Store	Quarter1	Quarter2	Quarter3	Quarter4
Store1	100	300	500	700
Store2	250	450	650	850

The Normalizer returns a row for each store and sales combination. It also returns an index(GCID) that identifies the quarter number: 

Target Table

Store	Sales	Quarter
Store 1	100	1
Store 1	300	2
Store 1	500	3
Store 1	700	4
Store 2	250	1
Store 2	450	2
Store 2	650	3
Store 2	850	4

14. In which Order does the execution of ports take place

(a) Input Port, Output Port, Variable Port

(b) Input Port, Variable Port, Output Port

(c) Output Port, Input Port, Variable Port

(d) Output Port, Variable Port, Input Port

15. Which of the following are not possible Fan In ?

(a) Filter and Expression Widget Widgets being connected to input of another Expression Widget

(b) Expression and Sequence Generator Widgets connected to input of another Expression Widget

(c) Expression and Sorter Widgets connected to input of another Expression Widget

(d) Expression and Expression Widgets connected to input of another Expression Widget

16. Which Component gets metadata from Repository?

(a) Informatica Server

(b) Informatica Workflow Designer

(c) Informatica Designer

(d) Informatica Repository Server/service

17. Repository Manager is used to

(a) Create, edit and delete folders

(b) Create, edit and delete repository users and user groups

(c) View locks and un-lock objects, versions and folders

(d) Copy a folder within a repository or to other repository

18. How many port values can be retrieved by an unconnected lookup and connected lookup respectively

(a) Zero, One

(b) One, Unlimited

(c) One, One

(d) Unlimited, Unlimited

19. For Unconnected Lookup how many ports can be given as input values

(a) Zero

(b) One

(c) Two 

(d) Unlimited

20. For Updating Record on database table,

(a) We need Key on the Informatica target Metadata only

(b) We need key on the database only

(c) We need key on both Target Metadata and Database

(d) Keys are not required