Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, the Data Change task is used to load data from a source file into a table, and it supports flexible field type mapping to accommodate differences between source and target field types. According to the official Workday Prism Analytics study path documents, when the source file has a Numeric field type and the target table has a Text field type, you can map the Numeric field to the Text field in the Data Change task. Workday Prism Analytics automatically handles the conversion of Numeric values to Text during the data loading process, as Text fields can store Numeric values as strings without data loss.
The other options are not necessary or appropriate:
A. Use a different source file, as the field types are incompatible: The field types are not incompatible; Prism supports mapping Numeric to Text, making a new source file unnecessary.
C. Change the field type in the parsing stage from Numeric to Text: The parsing stage defines how the source file is interpreted, but changing the source field type is not required since the mapping handles the conversion.
D. Change the connection type for the data change task: The connection type (e.g., file upload or Workday report) is unrelated to field type compatibility and does not address the issue.
By mapping the Numeric field to the Text field in the Data Change task, the data can be successfully loaded, leveraging Prism’s built-in type conversion capabilities to ensure compatibility.
[References:, Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Field Type Mapping in Data Change Tasks, Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Handling Field Type Conversions in Data Loading, ]
Submit