NiC IT Academy

Informatica Quiz – 1

By Mr.Chandra

Loading

1) To connect to another server from Informatica server, which connection can be used?

2) All rows of data from the detail source and the matching rows from the master source are selected. This type of join called ____?

3) Which component can be used for creating a Repository?

4) When you configure partitioning for a mapping, which partition type distributes data evenly among all partitions?

5) Change data capture is a part of

6) Which utility is invoked to run the workflow?

7) Which transformation can be used to read directly from the website?

8) When a mapplet is changed, all instances of the mapplet and all shortcuts to the mapplet?

9) If the data doesn't fit in the memory cache, the server stores the overflow values in

10) Which type of Data Warehouse schema normalizes dimensions to eliminate redundancy?

11) What is Type-1 SCD?

12) Which of the following are supported file types, from which, an XML definition can be imported?

13) Which of the following Is NOT true of Aggregate functions?

14) Which of following statements is valid for Dynamic lookups?

15) The HTTP Transformation supports which HTTP Methods?

16) Which of these statements is correct concerning a Lookup transformation's persistent cache?

17) An Unconnected Stored Procedure can run in the following fashions.

18) Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace?

19) Subqueries can be used in the SQL override for uncached lookup transformations.

20) Which transformation is used to combine data from the Same structured sources?

Login with your email & password

Sign up with your email & password

Signup/Registration Form

Registred Email:

- Not Updated -

Set/Update Password