Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, a Manage Fields stage is used to control the fields in a dataset by renaming, hiding, or changing field types, among other actions. According to the official Workday Prism Analytics study path documents, to ensure the correct set of fields is brought into a derived dataset (DDS), the Manage Fields stage should be applied at the beginning of the Primary Pipeline of the derived dataset (option C). Placing the Manage Fields stage early in the pipeline—right after the initial import stage (Stage 1)—allows you to define the field structure upfront, ensuring that subsequent transformationstages (e.g., Join, Filter, Calculate Field) operate on the desired set of fields. This approach helps maintain consistency and avoids unnecessary processing of fields that are not needed in later stages.
The other options are not optimal:
A. After the dataset is published: You cannot add transformation stages like Manage Fields after a dataset is published; transformations must be applied during the dataset’s creation or editing.
B. At the end of the Primary Pipeline of a published dataset: Similar to option A, you cannot modify a published dataset’s pipeline, and placing Manage Fields at the end would not prevent unnecessary fields from being processed in earlier stages.
D. At the beginning of the primary pipeline of the Base Dataset: A Base Dataset does not have a transformation pipeline; it is a direct import of a table, so Manage Fields stages can only be applied in a Derived Dataset.
Applying the Manage Fields stage at the beginning of the derived dataset’s Primary Pipeline ensures efficient data preparation and transformation.
[References:, Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Using Manage Fields in Derived Datasets, Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Best Practices for Field Management in Pipelines, ]
