Tag: technology

1

2

3

4

The aggregate expression contains nested aggregate functions

The session uses incremental aggregation

Source data is data-driven

All of the above

The mapping gets invalidated

The Workflow Manager displays a warning

The Informatica Server does not follow instructions in the Update Strategy transformation in the mapping to determine how to flag rows.

The Informatica Server does follow instructions in the Update Strategy transformation in the mapping to determine how to flag rows

Sorter transform increases the number of rows

Sorter transform returns the same number of rows

Sorter transformation decreases the number of rows

None of the above

Keep the Filter transformation as close as possible to the sources in the mapping

Keep the Filter transformation as close as possible to the Targets in the mapping

Either of the options a.) and b.)

None of the above

IIF( SKU_ID = 100000, DD_UPDATE, DD_DELETE)

IIF( SKU_ID = 100000, DD_INSERT, DD_UPDATE)

IIF( SKU_ID = 100000, DD_DELETE, DD_REJECT)

IIF( SKU_ID = 100000, TRUE, FALSE)

A target definition with no data flowing into it.

Two ports with different datatypes connected together

Two active transofrmations connected to the same downstream transformation

A source qualifier with port names that do not match the field names in the source definition.

NEXTVAL+1

NEXTVAL+Increment by

NEXTVAL-Increment by

NEXTVAL+Start value

Persistent Cache

Dynamic Cache

Unnamed Cache

Shared Cache

ERROR

NPARK

DECCAN

NULL