Same Column Name with Different Cases
- Chiang Tan
Query name | Same Column Name with Different Cases |
|---|---|
Server Asset Type | Job, Shared Containers |
Analysis Type | Remediation |
Description | Identifies Jobs containing link metadata and/or stage variable with that has the column/stage variable names but different cases e.g.
|
Issue
Selected stage types of Server Job allows same column name with different cases on the same output link.
Parallel does not allow that, Stages using same column name with different cases will prevent the job from compiling.
Server Transformer stage allows same stage variable name with different cases.
Parallel does not allow that, transformer stage using same stage variable name with different cases will prevent the job from compiling.
Actions
Rename the offending column and/or stage variable so that it does not contain same column and/or stage variable with different case on the same output link.
© 2015-2024 Data Migrators Pty Ltd.