[Data Prep and Transformation]
A Prism data administrator needs to add an Explode stage to a derived dataset to create a new single-instance type field. What is the only field type you can select in the Explode stage?
[Data Prep and Transformation]
In a Prism project, you have a dataset containing customer purchase transactions, including the customer ID, purchase amount, and purchase date. You want to analyze the total purchase amount for each customer over the entire period. What transformation stage should you apply to calculate the total purchase amount for each customer?
[Data Prep and Transformation]
You are adding a Join stage and choose Join type of Left Outer Join, causing Workday to search for a matching row in the imported pipeline. What happens if no matching rows exist?
[Data Prep and Transformation]
A Prism data writer has two pipelines of data that need to be joined together:
* The primary pipeline includes point of sale data by sales agent.
* The secondary pipeline includes performance rating by sales agent.
The requirement is to keep all of the point of sale data from the primary pipeline and blend in performance rating data for the agents from the secondary pipeline where it exists. What Join type should be used to blend the data together?
[Data Prep and Transformation]
You want to apply a Filter stage to your derived dataset to show only expense reports submitted in the current month and where the expense report total amount is higher than 2000 USD. What should you do?
[Integrating Prism with Workday Reports]
You want to use a custom report containing prompts as a source connection for a table. What must you ensure to make this possible?
