Informatica MCQs Set: 4

Informatica MCQs Set: 4

Q1.How do you know that session has heterogeneous target?
a) Check the session properties and work floe properties
b)Either workflow properties or mapping properties or session properties
c) Check session properties alone
d) Check mapping or work flow prop

Q2 which of the following is not used in Mapplet

Ans Target

REASON:The transformations that cannot be used in MAPPLET and REUSABLE TRANSFORMATION are:TARGET, NORMALISER, COBOL SOURCE, XML SOURCES, UPDATE STRATEGY, XML SOURCE, QUALIFIER, TARGET DEFINITION

Q3 .ER is ……….  Ans.Entity relationship

Q4.XML……….. Ans: Extended Markup Language

Q5 Logical model is…………… Ans: RDBMS

Q6 we want to compare objects in Filter and aggregate transformation which data type you use……..

a) Integer     

b)Double

c)String

d)Decimal

e) Char

Q7 which of the following are not the control task in workflow manager…….

A} Email notification

B} Alert notification

C} check the performance of session

Ans: A B C

REASON:The lists of tasks supported in control task of workflow manager are:

·  Fail me
·  Fail parent
·   Stop parent
·   Abort parent
·   Fail top-level workflow
·  Stop top-level workflow
·  Abort top-level workflow

8 Which of following Joins in Informatica………

1} Master outer

2 Full outer

3 Left outer

4 Outer join

REASON: The types of Joins supported in Informatica are:
Normal (Default) à only matching rows from both master and detail
Master outer à all detail rows and only matching rows from master
Detail outer à all master rows and only matching rows from detail
Full outer à all rows from both master and detail ( matching or non matching)

9 Which of following are security tasks of repository manager

A} manage Repository

B} Create folders

C} Create users

D} Create groups

(Check Box Q)

10.What are tasks can do in designer …..

A} Inport / Export registry

B} Inport / Export repository  objects

C} Create mapping

D} Creating mapplet