- 最后登录
- 2015-1-21
- 在线时间
- 17 小时
- 威望
- 14
- 金钱
- 39
- 注册时间
- 2012-2-22
- 阅读权限
- 10
- 帖子
- 14
- 精华
- 0
- 积分
- 14
- UID
- 252
|
1#
发表于 2012-7-19 16:35:41
Using default column mapping
If an explicit column mapping does not exist, either by using COLMATCH or COLMAP, Oracle GoldenGate maps source and target columns by default according to the following rules.
● Columns with the same name are mapped to each other if the data types are compatible.
● For databases that do not support case-sensitivity for object names, column names are changed to uppercase for name comparison. For databases that are configured for casesensitivity, Oracle GoldenGate considers the case when evaluating columns for default mapping.
● If a source column is found whose name and case exactly match those of the target column, the two are mapped. If no case match is found, then the map is created using the first eligible source column whose name matches that of the target column, regardless of case.
● Target columns that do not correspond to any source column take default values determined by the database.
file:///C:/Users/Administrator/AppData/Roaming/Tencent/Users/29719318/QQ/WinTemp/RichOle/~QS%60)TY)£%254~R)UUL%7BQ6A.jpg |
|