PowerCenter

Effective in version 10.2, you can generate audit logs when you import an .xml file into the PowerCenter repository. When you import one or more repository objects, you can generate audit logs. You can enable Security Audit Trail configuration option in the PowerCenter Repository Service properties in the Administrator tool to generate audit logs when you import an .xml file into the PowerCenter repository. The user activity logs captures all the audit messages.

The audit logs contain the following information about the file, such as the file name and size, the number of objects imported, and the time of the import operation.

For more information, see the "pmrep Command Reference" chapter in the Informatica 10.2 Command Reference, the Informatica 10.2 Application Service Guide, and the Informatica 10.2 Administrator Guide.

Effective in version 10.2, when you upsert data into SAP HANA targets, you can configure the EnableArrayUpsert custom property to upsert data in bulk and improve the session performance. You can configure the EnableArrayUpsert custom property at the session level or at the PowerCenter Integration Service level, and set its value to yes.

For more information, see the "Working with Targets" chapter in the Informatica 10.2 PowerCenter Designer Guide.

Effective in version 10.2, you can create and delete object queries with the pmrep commands.

For more information, see the "pmrep Command Reference" chapter in the Informatica 10.2 Command Reference.

Effective in version 10.2, you can create or update a connection with a parameter in password with the pmrep commands.

You can also update a connection with or without a parameter in password with the pmrep command.

For more information, see the "pmrep Command Reference" chapter in the Informatica 10.2 Command Reference.