In this article, we will discuss best practices around the simple replacement/normalization task template and infer value task template. You can learn more about the simple replacement/normalization task template here, and the infer value task template here.
Key features - Simple Replacement/Normalization
Use the Simple Replacement/Normalization task template when you want to:
- Normalize values from your input data source using only one match method
- Output only one value from the reference table
- Do not need to filter your reference table
Key features - Infer Value
Use the Infer Value task template when you want to:
- Infer values from your input data source using more than one match method
- Output multiple values from the reference table
- Need to filter your reference table
- Need to make more complex relationships between your input data source and reference table
Side-by-Side Comparison
Below is a detailed comparison outlining the differences between both task templates and when to use them: