Informatica Quiz

User defined join is possible in source qualifier when

• sources are flat files

• sources are relational database

• All of the above.

• None of the above

Target override can be used to override the update strategy

• true

• false

SQL override cannot be overwritten in the session

• true

• false

Can we compare two repository objects of the same type to identify differences between the objects?

• yes

• no

• not possible

• none of the above

Only first error information can be viewed from session run properties.

• true

• false

In a workflow where is the information service assigned?

• command task

• session

• worklet

• workflow

Repository services can be shutdown or startup repository manager console

• true

• false

Informatica requires at least following databases up and running to start up the informatica services.

• Domain database

• Repository database

• Source database

• All of the above

Aggregator transformation can be used to

• Filter the records with multiple conditions

• Perform aggregate calculations

• Define a custom query that replaces the default query.

• None of the above

Which type of architecture followed in informatica 8.x onwards?

• Server-client

• Service oriented architecture

• 2 tier architecture

• None of the above