Questions and Answers
Where does data transformation and blending take place?
What must you do to refresh data in the Prism data source?
Anyone with access to the Data Catalog can create datasets.
False
Which domain provides access to view or edit Prism data source security?
Signup and view all the answers
What does Workday create when you publish a dataset?
Signup and view all the answers
When creating a custom report to import into a Prism base dataset, why is it important to include instance field types?
Signup and view all the answers
If you add new fields to a file after the first import, you must manually re-save the base dataset to accept the new schema.
Signup and view all the answers
Dataset Update Mode: Append inserts only unique rows that are not already in the base dataset.
Signup and view all the answers
Which storage type allows you to validate the imported data against the schema?
Signup and view all the answers
Which table operation allows you to only insert unique rows to a table?
Signup and view all the answers
You can add all types of transformations to base datasets or tables.
Signup and view all the answers
Using the Manage Fields stage, you can change the output type of a field to support needed downstream transformations.
Signup and view all the answers
What happens if you change a field name used in a downstream Prism calculated field definition?
Signup and view all the answers
Workday determines the value of Prism calculated fields at the time of publishing, not report runtime.
Signup and view all the answers
Which join type should you use if the desired joined result should include all rows from the primary pipeline even if no match exists in the imported pipeline?
Signup and view all the answers
A join of two datasets can result in fewer rows in the joined result, while a union of two datasets always results in an increased number of rows in the result.
Signup and view all the answers
In a join stage configuration, what must be true when matching fields between the primary pipeline rows and additional pipeline rows?
Signup and view all the answers
Selecting the If Any option when defining a basic filter is similar to using what type of operator?
Signup and view all the answers
The Group By stage returns both aggregated and detail data.
Signup and view all the answers
When adding a filter condition, you must edit all downstream transformation stages to include the change.
Signup and view all the answers
When adding fields to a dataset, you must edit all downstream Join, Union, or Manage Fields stages to include the additional fields.
Signup and view all the answers
You can only use Prism data sources in Matrix report types.
Signup and view all the answers
If you edit Prism data source security configurations after publishing, you must:
Signup and view all the answers
Study Notes
Data Transformation and Sources
- Data transformation and blending occur in the Data Catalog.
- Refreshing data in the Prism data source requires re-importing base datasets or tables and republishing the data source.
User Access and Dataset Creation
- Not everyone with access to the Data Catalog can create datasets.
- The domain “Prism Dataset: Manage Data Source” provides access to view or edit Prism data source security.
Dataset Publishing and Schema
- Publishing a dataset in Workday creates a data source for reporting.
- Including instance field types in custom reports is important for actionability when reporting on published Prism data sources.
- If new fields are added to a file after the first import, the base dataset must be manually re-saved to accept the new schema.
Data Handling Modes
- Dataset Update Mode: Append does not insert unique rows, but rather allows for repeated entries.
- Unique rows can only be inserted to a table through the Upsert operation.
Field Management and Transformations
- Not all types of transformations can be added to base datasets or tables.
- Managing fields cannot change the output type of a field for needed downstream transformations.
Calculated Fields and Runtime Values
- Changing a field name used in a downstream Prism calculated field will result in an error.
- Prism calculated fields' values are determined at the time of publishing, not during report runtime.
Joins and Dataset Operations
- Use a Left Outer Join to include all rows from the primary pipeline, regardless of matches with the imported pipeline.
- A join can result in fewer rows, while a union usually increases the number of rows in results.
Matching Fields Criteria
- When matching fields in a join configuration, they must be of the same type.
- Selecting the If Any option in a basic filter is akin to using the OR operator.
Data Aggregation and Filters
- The Group By stage returns only aggregated data, not detail data.
- Filter condition changes do not require edits to all downstream transformation stages.
Field Additions and Dataset Types
- Adding fields to a dataset necessitates editing downstream Join, Union, or Manage Fields stages to reflect the additional fields.
- Prism data sources can be used in various report types, not exclusively in Matrix report types.
Security Configurations and Changes
- After editing security configurations of a Prism data source post-publication, it is necessary to republish the data source for changes to take effect.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge on data transformation, user access, and dataset management related to the Prism system. This quiz covers essential aspects of data handling, publishing datasets, and the impact of schema changes on data sources. Prepare to enhance your understanding of managing data in a corporate environment.