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