PR000041 practice question 8 of 15

Which statement on workflows is correct?

Full set: 69 questions
Answer options
A: In a default configuration, a workflow must contain at least one session task
B: A workflow can contain multiple start points
C: In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions Correct answer
D: Another workflow cannot be executed from within a workflow
Correct Answer:
C. In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions
Explanation

A parameter file specified at the workflow level provides a centralized mechanism to define values for parameters and variables used by all tasks within that workflow. These values override the initial or default values configured within the individual mappings and sessions. While a parameter file defined at the session level has higher precedence for that specific session, the workflow-level file serves as the default for any session that does not have its own file specified, thus overriding the pre-configured initial values.

Why Incorrect

A. In a default configuration, a workflow must contain at least one session task A workflow is a container for various task types, such as Command, Email, or Timer tasks, and can be valid and functional without any Session tasks.
B. A workflow can contain multiple start points A fundamental rule of workflow design in Informatica is that each workflow must have exactly one Start task, which serves as the single entry point for execution.
D. Another workflow cannot be executed from within a workflow Informatica supports modular design; a workflow can execute another workflow by using a reusable Worklet task or by executing a pmcmd startworkflow command within a Command task.

References

1. Informatica PowerCenter 10.5 - Workflow Administration Guide, Chapter 10: Parameters and Variables, "Parameter File Precedence", p. 178. This section details the hierarchy of parameter files. It clarifies that the Integration Service uses the workflow parameter file if a session-specific one is not defined. The values in the parameter file override the initial values of parameters and variables.

2. Informatica PowerCenter 10.5 - Workflow Basics Guide, Chapter 1: Workflow Basics, "Workflows", p. 10. This section states, "All workflows must have a Start task. The Start task is the entry point into the workflow." This confirms that a workflow has a single start point.

3. Informatica PowerCenter 10.5 - Workflow Administration Guide, Chapter 1: Workflow and Task Basics, "Tasks", p. 12. This page lists the different types of tasks that can be added to a workflow, including Command, Email, and Timer, demonstrating that a Session task is not mandatory.

4. Informatica PowerCenter 10.5 - Workflow Administration Guide, Chapter 8: Worklets, "Worklet Task", p. 138. This chapter explains how a Worklet task can be used to run another workflow, directly refuting option D.

Question breakdown

Tests
Understand workflow structure and parameter file precedence
Difficulty
Medium

Key idea: When a parameter file is defined at both the workflow level and the session level, the Integration Service uses the workflow-level file by default.

How to reach the answer

  1. Test each statement against the basic workflow rules.
  2. A workflow can hold only Command, Email, or other non-session tasks, so a session is not required; A is false.
  3. Every workflow has exactly one Start task, so B is false.
  4. A Command task can run pmcmd startworkflow to launch another workflow, so D is false.
  5. By default, the workflow parameter file takes precedence over session parameter files, so C is correct.

Each option

  • AIncorrect. A workflow is valid with only non-session tasks, such as Command or Email tasks.
  • BIncorrect. A workflow has exactly one Start task as its entry point, although links can branch after it.
  • CCorrect. By default, a parameter file set in the workflow properties overrides parameter files set in the session properties.
  • DIncorrect. A Command task running pmcmd startworkflow can trigger another workflow, so this is possible.

Common trap: Many people assume the more specific session-level file wins, as with typical override logic, but PowerCenter gives the workflow-level parameter file precedence.

In practice: Teams often keep one workflow-level parameter file per environment to drive every session in a load. Knowing it wins over session files prevents confusion when a session-level value seems to be ignored.

Remember: The workflow parameter file beats the session parameter file, and every workflow has exactly one Start task.

Drafted with AI assistance and checked against the answer key.

Keep practicing

Take the free PR000041 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test

More questions

Other PR000041 practice questions

Scroll to Top