Informatica Quiz

1

Instructions For Quiz

This Mock Test has 10 Questions
Each Question is of 1 marks so total 10 marks
Multiple Choice Questions(MCQ) with only ONE valid answer

2

1) _________ server governs the implementation of various processes among the factors of server’s database repository.* This field is required.

Repository server

Temp server

Powerhouse server

Domain server

3

2) Can one use mapping parameter or variables created in one mapping into any other reusable transformation?* This field is required.

YES

NO

4

3) Which type is NOT used in metadata stored in repository?* This field is required.

Source Definition

Mappings

Mapplet

Applete

5

4) Can you validate all mappings in the repository simultaneously?* This field is required.

YES

NO

6

5) Which transformation is used to combine data from different sources?* This field is required.

Joiner transformation

Lookup transformation

Union Transformation

Expression transformation

7

6) Which transformation is used numerous times in mapping?* This field is required.

Reusable transformation

Union Transformation

Lookup transformation

Expression transformation

8

7) Which task is used anywhere in the workflow to run the shell commands?* This field is required.

Command Task

Session Task

Standalone Command Task

email Task

9

8) OLAP stands for?* This field is required.

On-Line Analysis Processing

On-Line Analytical Processing

On-Line Access Processing

On-Line Application processing

10

9) Which process is used for online analytical processing?* This field is required.

Data mart

Database

Data warehouse

Data

11

10) In joiner transformation we override the query?* This field is required.

YES

NO