When matching fields in a join stage configuration between two pipelines, what condition must be met?

In a join stage configuration within Workday Prism, it is essential that matching fields be of the same type. This requirement ensures that the data can be accurately compared and combined during the join operation. If the data types differ, the system would encounter difficulties or errors in processing the join, as it would not know how to align or interpret the values from each data source correctly.

Data types include various formats such as strings, integers, dates, etc. When the fields being matched do not share the same type, the join process may yield incorrect results or fail altogether, as it is fundamental for the system to understand how to handle and manipulate the data being joined.

While other conditions can be important in certain contexts—like the uniqueness of identifiers or value consistency—those do not specifically address the foundational requirement of alignment in data types during the join process. Thus, ensuring that matching fields are of the same type is crucial for successful data integration and manipulation in Workday Prism.