View Source

To display the column Properties, right-click on a column in the middle pane and select Properties.

Edit any field as required and then click OK to close.

WhereScape RED does not support the following characters in Column Names:

leading and trailing white spaces
internal white spaces
symbols other than #, $ and _
If users attempt to enter any of the above characters in Column Names, the following message is displayed, advising users to review changes made by RED to correct any unsupported column name characters:

There is a variation in column Properties, depending on the object type.

For Dimension tables, refer to Dimension Column Properties
For Stage tables, refer to Stage Table Column Properties
For Data Store tables, refer to Data Store Column Properties
For EDW 3NF tables, refer to EDW 3NF Table Column Properties
For Fact tables, refer to Fact Table Column Properties