Free Informatica Quiz Online

Which one is not correct about filter transformation?

Act as a 'where' condition

Can't passes multiple conditions

Act like 'Case' in pl/sql

If one record does not match condition, the record is blocked

Can we calculate in aggrigator ?

Yes

Which one is not a type of fact?

Semi-aditive

Additive

Confirm fact

Not additive

Which one is not a type of dimension ?

Conformed dimension

Rapidly changing dimension

Junk dimension

Degenerated dimension

Which of these not correct about Code Page?

A code page contains encoding to specify characters in a set of one or more languages

A code page contains decoding to specify characters in a set of one or more languages

In this way application stores, receives, and sends character data.

Non of these

What is a mapplet?

Combination of reusable transformation.

Combination of reusable mapping

Set of transformations and it allows us to reuse

Non of these

What does reusable transformation mean?

It can be re-used across repositories

I can only be used in mapplet.

It can use in multiple mapping only once

It can use in multiple mapping multiple times

Which one is not an option in update strategy?

dd_reject

dd_delete

Can we update records without using update strategy?

Yes

How to select distinct records form Source Qualifier?

Choose 'non duplicate' option

Choose 'select distinct' option

Choose 'Select non duplicate'

What type of repository is no available in Informatica Repository Manager?

Standalone Repository

Local Repository

User Defined

Versioned Repository

Manual Repository

Joiner does not support flat file.

False

True

How to execute PL/SQL script from Informatica mapping?

Lookup

Store Procdure

Expression

Non of these

NetSal= bassic+hra. In which transformation we can achive this?

Aggrigator

Lookup

Filter

Expression

Which one is not an active transformation?

Sequence generator

Normalizer

Sql

Store Procedure