RULE-FILE-STYLE

RULE-FILE-CSS

RULE-FILE-TEXT

RULE-FILE-BINARY

32 characters

64 characters

128 characters

No length restriction

Local List

Field Value

Remote List

Prompt List

Daily

Weekly

Monthly

Once in 3 months

Data Validation

Data Mining

Report Generation

Data Modeling

Validation of all negative scenarios like handling of incorrect data type

Testing the boundaries of each field to find any limitations

Job not to be aborted at any cause - all abort scenarios must be handled in the code

Cleansing of obvious data for any anomalies (even if its not specified in requirements)

None of the above

True

False

Start a Workflow

Check Session Logs

Delete Informatica Code Components

Check Workflow status

Rounding decimal values to Integers

Removing special characters from a Text field

Defining Primary Key constraint on a Table

Assigning a default value to a field.

Mapplet

Transformations

Mapping

Task

True

False

the capability to access data from any source, regardless of format or system

The ability to access data without proper authorization

The ability to store data in one source without it being accessible to other systems

The ability to manipulate data remotely

True

False

Aggregator

Expression

Normalizer

Filter

Reducing the number of transformations

Using conditional filters

Droping Indexes & Key Constraints before loading

Using Multi - pass reads from source

High performance decision support environments

Master Data Management hubs

Online Transaction processing

All the above

SAP

BO

Infommersion

All the Above

True

False

Microsoft Excel

XML databases

SOAP-based Web services

All the above

Query as a Web Service (QaaWS)

Live Office

InfoBurst-XDS

All the above