Multiple choice etl

Workflow can be executed using

  1. Repository server admin console

  2. PMCMD command

  3. Repository manager

  4. PMREP command
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

PMCMD is the Informatica command-line utility specifically designed to execute and manage workflows. The Repository Server Admin Console is for repository administration, not workflow execution. The Repository Manager is a GUI for repository management. PMREP is a command-line utility for repository object management (migrate, promote, etc.), not workflow execution. Only PMCMD can start and control workflow execution from command line or scripts.

AI explanation

To answer this question, you need to understand the different tools and commands used in executing workflows.

Option A) Repository server admin console - This option is incorrect because the repository server admin console is used for managing and administering the repository server, but it is not used for executing workflows directly.

Option B) PMCMD command - This option is correct because the PMCMD command is a command-line tool used to start, stop, and monitor PowerCenter workflows. It allows you to execute workflows and manage their execution state.

Option C) Repository manager - This option is incorrect because the repository manager is used for managing and administering the PowerCenter repository, but it is not used for executing workflows directly.

Option D) PMREP command - This option is incorrect because the PMREP command is a command-line tool used for repository administration tasks, such as importing and exporting objects, but it is not used for executing workflows directly.

The correct answer is B) PMCMD command. This option is correct because it is the command-line tool used specifically for executing PowerCenter workflows.

Keep practicing — related questions