Informatica Transformations Quiz

Welcome to your Informatica Transformations Quiz
All the questions are related to Informatica Cloud Transformations

You want to load Account records to Salesforce from a CSV source file where 'BillingState'=NY and 'Annual_Revenue'>10000000. Will a simple filter work?

TRUE

FALSE

Which of the below Partitioning method is NOT supported in Informatica Cloud?

Key-Range Partitioning

Database Partitioning

Fixed Partitioning

All of the options

Router transformation has two output groups defined. The first group has condition as Sales > '5000' and the second group has condition Sales > '10000'. Now a record with Sales = '13500' is returned from which output group.

First Output Group

Second Output Group

Both First and Second Output Group

Record is not returned from any of the groups

Which of the following transformation is NOT used to remove duplicates?

Source

Sorter

Union

Aggregator

Which of the below is a Passive transformation?

Union

Expression

Transaction control

Aggregator

Which of the below statements is FALSE?

Sequence generator can be used in two different ways in Informatica cloud. One with Incoming fields disabled and the other with incoming fields not disabled.

Sequence generator with incoming fields not disabled will generate same sequence of numbers for each downstream transformation.

Sequence generator with incoming fields disabled will generate same sequence of numbers for each downstream transformation.

In Sequence generator, CURRVAL field value is always NEXTVAL+1

Hierarchy Parser transformation converts relational input into hierarchical output

TRUE

FALSE

In order to join 4 differernt sources, how many joiner transformation are required

Which of the following is a valid performance tuning method?

Use the Filter transformation as close to the source as possible in the mapping.

Use the source with less number of rows as master in Joiner transformation.

Enable sorted input option in Aggregator and Joiner transformations.

All of the options

10.

Which of the below statements is FALSE?

Unconnected look up returns only one output field.

If the lookup cache file is still present after the successful completion of the task, the lookup in the mapping is configured to have Dynamic cache.

Transaction control transformation commits or rolls back transactions during a mapping run.

Normalizer generates two default fields along with the defined Normalized fields

Leave a Comment Cancel reply