NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
In {{IMSMANG}} the CDF name is contents of a database column but in the Staging area database it will be used a column name which of cause must be according to PostgreSQL rules. The Staging Area Generator handles CDF names that do not follow the rules:
* any name longer than '''63 ''' characters will be cut off* any not supported character will be replaced with underscore (_)including trailing spaces* to facilitate working with the Staging area or using it with other applications the column name will be in '''lower ''' case. The geo part of the Staging area is creating SQL views that will be used by GIS software and here the maximum length for column names is '''31''' characters. The Staging Area Generator handles automatically duplicates by renaming them which sometimes is resulting in confusing column names. There are cases where the Staging Area Generator cannot handle the duplicates.
{| class="wikitable"
! SA column name
! SA view
! Comment
|-
| "Economic aid received - from whom (comment) "
| economic_aid_received___from_whom__comment__
| economic_aid_received___from_wh
|
|-
| Specify
| specify
| specify
| In {{IMSMANG}} the CDF name is starting with Upper case
|-
| specify
| specify
| specify
| SAG will consider Specify and specify as duplicates
|-
| Dangerous Area User Defined Field 1
| dangerous_area_user_defined_field_1
| dangerous_area_user_defined_f5
|
|-
| Dangerous Area User Defined Field 2
| dangerous_area_user_defined_field_2
| dangerous_area_user_defined_f4
|
|-
| Dangerous Area User Defined Field 20
| dangerous_area_user_defined_field_20
| dangerous_area_user_defined_fie
|
|-
| Dangerous Area User Defined Field 3
| dangerous_area_user_defined_field_3
| dangerous_area_user_defined_f3
|
|-
| Dangerous Area User Defined Field 4
| dangerous_area_user_defined_field_4
| dangerous_area_user_defined_f2
|
|-
| Dangerous Area User Defined Field 5
| dangerous_area_user_defined_field_5
| dangerous_area_user_defined_f6
|
|}
{{NavBox Business Intelligence}}
[[Category:VIE]]
