Question No. 1

You have coped a set of PowerCenter objects to a new folder, Many of the objects that now appear in the destination folder have a "1" appended to their names, such as 'Targetname1 instead of the expected Targetname.

How would you recommend avoiding this situation in the future"?

ADelete duplicate objects in the destination folder prior to copying.

BRename duplicate objects In the destination folder prior to copying.

CResolve duplicate conflicts with 'replace' or 'reuse.'

DResolve duplicate conflicts with 'rename' and manually provide an alternate name for the object.

Show Answer

Correct Answer: B

Question No. 2

PowerCenter Web Service Hubs use which one of the following?

AThe SOAP standard and a fixed XML data structure to receive requests and send responses to web service clients.

BThe RPC (Remote Procedure Call) standard to receive requests and send responses to web service clients.

CThe soap standard to receive requests and send responses to web service clients.

DThe rpc (Remote Procedure call) standard and a fixed XML data structure to receive requests and send ' ^responses to web service clients.

Show Answer

Correct Answer: C

http://gerardnico.com/wiki/powercenter/web_services_hub

Question No. 3

Which command line tool is used to create Informatica user accounts?

Apmcep

Binfacmd

Cinfasetup

Dpmcmd

Show Answer

Correct Answer: B

http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/createuser-group-grant-permissions-5048100

Question No. 4

In reference to relational connections created in the PowerCenter Workflow Manager, which one of the following statements is true?

AThe connection environment SQL executes when a session connects to the database.

BThe transaction environment SQL executes Just before a COMMIT against the target.

CThe transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.

DYou can use the connection environment SQL to set folder permissions in the PowerCenter repository database.

Show Answer

Correct Answer: A

http://www.info-etl.com/course-materials/tips-power-center-9

Question No. 5

Complete the following sentence A process variable root directory is associated with a _?

ANode

BIntegration service

CRepository service

DDomain

Show Answer

Correct Answer: C

Free Informatica PR000007 Exam Actual Questions

The questions for PR000007 were last updated On Jan 19, 2025