Informatica MCQs Set: 8

Informatica MCQs Set: 8

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? No

2.How Null values are stored in Aggregate transformation? 1.Null,2.we can configure them to treat them as zero as well

3.What is SCD?slowly changing dimensions

4.What is not an option in Informatica?

a) Drill down^

b) Sessions

c) Dimension

d) Mapping

5)Types of Caches in Lookup.-connected,unconnected,static,dynamic,recache,persistant,shared

(Refer to the reasons in above pages...)

6) Select the Active transformation (Choose 1)

a) Aggregate^

b) Router^

c) XML Source Qualifier-i dont use this ever

d) Look up

e) Expression

7) Default Directory for storing the parameter files.$parent root directory

8) What happens when the maximum number of sessions are running and the database log file is full? Session fails

9) Components derived from Informatica (choose 3)

a) Marts^

b) Dimensions^

c) levels

d) cubes^

10) Enhanced Security option (choose 3)

a) Read^

b) write^

c) Overwrite

d) Append

e) Execute^

11) To Transformation from one session to another using debugger

a) Step to Instance

b) Forward Instance

c) breakpoints^

d) Backward Instance

12) How can the performance of lookup be improved?by using cache and sorting

13) Update in Update strategy transformation is used for ? to flag the records for update

14) Performance Degradation (choose 3)

a) is null^

b) iff^

c) not null^        

d) decode single condition

e) decode multiple condition

15) How can we access AEP's? AEP-advance external procedure

Table 8-1. Environment Variables
Operating System	Environment Variable
Windows	PATH
AIX	LIBPATH
HPUX	SHLIB_PATH
Linux	LD_LIBRARY_PATH
Solaris	LD_LIBRARY_PATH

16) How will user-defined variables be stored in a worklet?

a) static

b) dynamic

c) persistent

d) volatile

e) non-persistent

17) Which operator can be used in the look up-^all (if dynamic = is the ans)

a) =

b) >=

c) <=

d) <

e) >

  

18) Which will not return values in the user defined data types

a) Oracle

b) Informiz

c) Teradata

d) SQL Server

e) Sybase

   

19) When you update the database where it will get updated?

a) Session or Mapping

b) Mapping and session

 c) Mapping and workflow

d) Mapping and repository

20) After joiner transformation the source takes the input as?

a) content table

b) Master table

c) Detail Table

21) What will happen if the lookup cache get overloaded?^i will be stored in the file format in

 the disk(over flowing data)

the session will fail