Informatica MCQs Set: 7

Informatica MCQs Set: 7

Informatica Assessment Quiz set 7, Top questions with answers highlighted in Red.

31 Types of Slowly Changing Dimensions (SCD)… Ans 3

32 What type of Stored procedure is used to verify the target table?

And : Target Preload

33 Disable precision to numeric it becomes………..

Ans : Integer

34 Purpose of SQL override ?

Used to write user defined SQL statements in source qualifier and look up transformations

35 Ques on Metadata (blah! Blah!)

36 in retrieving if there are Multiple Rows matches in Look up transform?

And It returns an error

37 If data is Overflowed in the load what happens?

Write to cache files

38 While importing relational source data from DB, What metadata u import?

A} Source name

B} DB location

C} Column Names

D}Datatypes

E} Key constraint

39 worklet variables are not used for………..

A}Reference

B} DB connection

C} Performance tuning

40 Performance degradation occurs due to……….

A} IS Null

B} NOT Null

C} IIF

D}abort

E}decode single

41. Non ressable transformations?

42 What is displayed when u click the “View dependencies” on any Target object.

Primary/foreign key dependencied
Global shortcut dependencies
All children
All parents
Note: the dependencies dialog box displays object name,object type,list of dependent objects and their properties.