Document toolboxDocument toolbox

Same Column Name with Different Cases

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.

  • column1 vs Column1

  • stageVar vs STAGEVAR

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.