Informatica MCQs Set: 6

Informatica MCQs Set: 6

21 Which of following is Passive Transformation………

A} Router

B} Rank

C} Source Qualifier

D} Aggregate

E} Séquence generator

REASON : Refer to the table mentioned in start of the page.

22 Log initialisation, Error message and Notification of related data.

A} terse

B} Normal

C} Verbose init

D} Verbose Data
REASON: Tracing level in the case of informatica specifies the level of detail of information that can be recorded in the session log file while executing the workflow.

4 types of tracing levels supported
1.Normal: Integration Service logs initialization and status information
errors encountered and skipped rows due to transformation row errors.
Summarizes session results but not at the level of individual rows.

2.Terse: Integration Service logs initialization information and error
messages and notification of rejected data.

3. Verbose Initialization: In addition to normal tracing Integration Service
logs additional initialization details names of index and data files used and
detailed transformation statistics.

4.Verbose Data: In addition to verbose initialization tracing Integration
Service logs each row that passes into the mapping. Also notes where the
Integration Service truncates string data to fit the precision of a column and
provides detailed transformation statistics.

23.DW  -------  Ans : OLAP

24 Which of the following is Active

Aggregator

Lookup

Expression

Router

25. …….. Converts from Source to Target by using the Transformation.

Ans: Session

26. Command,Session,e-mail are  Reusable tasks.

REASON:
The Reusable tasks are:

command task

session task

email task

27 Cobol source used by ………. Transformation.

Ans Normalizattion

28……path….. are environment variables

29 Sorting can be used in ………

Ans Aggregate transformation

30 It takes some more time when I used Sorting.What is the reason

A} Use incremental Aggregation

B} nested Aggregation

C} Less data for source data

D} Less column

E} Data is Detailed data