Informatica MCQs Set: 10

Informatica MCQs Set: 10

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.

1.Can NULL values be compared (True/False).

2.How Null values are stored in Aggregate Transformation

3.Types of caches in Lookup?(multiple answers)

(Connected

Unconnected )

Static

Dynamic, percistent and Shared caches

4.What is the default directory for storing the parameter files?

Parent root dir->Param folder

5. What happens when max number of success are running and the database logfile is full? error

6. Components derived from Informatica

Marts

Dimensions

cubes

7. Enhanced security option?

Read

write overwrite

append

execute

8. To transformation from one session to another using debugger

step to instance

forward instance

breakpoints

backward instance

9.update in update strategy transformation is used to ? flag rows for insert update delete reject

10. Performs Degradation

Is Null

iff

notnull

decode single condition

decode multiple

11. How can we access AEP?

12. How are user defined variables are stored in worklet

static

dynamic

persistant,non persistant

13. which will not return user defined values?

informix

oracle

teradata

sql server

sybase

14. when you update the database where it will get updated

session or mapping

mapping and workflow

session and mapping

mapping and repository

15. after joiner transformation the source takes the i/p as

content table

master table

detail table

16. what will happen if lookup cache is overloaded? Session fails ,remaing details wil return to cacahe

17.which of the following are not to copy the one source to another source without connecting database 

drag and drop

copy the content and paste

cannot copy

move option

create shortcut and rename it

18.what is the function of SCD?

manage data

manage workflow

manage session

19.where cache(index,data) stores

workflow logs

session logs

cache directory

informatica repository

20. how many rows can be retrieved by dynamic lookup table?

cannot retrieve

one by one semantically

only first row

all rows