PR000041 Exam Dumps - Informatica Certified Professional ICP Program Questions and Answers

If InputValue = 2, the output will be routed to Group A only

If InputValue = 2, the output will be routed to both groups A and B

If InputValue = 2, the router will fail, since rows cannot be routed to multiple groups

Any positive number values other than 1 or 2 will be routed to the Default group

When the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled

When transformation scope is set to a value of transaction, the sorter will sort on every record in the pipeline before it releases any data. The intermediate sort file will have markers for each transaction.

If the distinct check box is not checked, the sorter will produce one record per unique key

The Sorter transformation will utilize database indexes from the source database to perform the sort

A persistent cache is stored on disk, and must be named to make it useable in multiple mappings

persistent cache is stored on disk, to refresh the cache the disk files must be deleted manually

When the Integration Service cannot find the persistent cache file and the recache property is not set, the session fails

A persistent cache can only be used by one mapping

XML

XSD

DTD

DSDL

From an expression

As a Post-Session SQL command

As a Pre-Session SQL command

As the only object In the mapping

The transformation's name, one of its port's default values, the tracing level or a Metadata Extension

The transformation's name or the tracing level

The transformation's name, one of its port's default values or the tracing level

The transformation's name is the only attribute that can be changed

This picture depicts a join that will be processed within the Informatica PowerCenter engine

This picture depicts a join that will be processed in a database

This picture depicts a SQL UNION operation

This picture depicts an Informatica Homogeneous Join

Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value

Session parameter file, workflow parameter file, repository value, declared initial value

Repository value, workflow parameter file, pre-session assignment, session parameter file, default value

Repository value, declared initial value, default value

True

False

lnput

Output

Variable

Return