InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
I Have A Table Called ‘test’ On Source And Target With Same Name, Structure And Data Type But In A Different Column Order. How Can You Setup Replication For This Table? |
|
Answer» OGG by default ASSUMES that the sources and TARGET tables are IDENTICAL. A table is said to be identical if and only if the table structure, data type and column order are the same on both the SOURCE and the target. If the tables are not identical you must use the parameter ‘SOURCEDEFS’ pointing to the source table definition and ‘COLMAP’ parameter to map the columns from source to target. OGG by default assumes that the sources and target tables are identical. A table is said to be identical if and only if the table structure, data type and column order are the same on both the source and the target. If the tables are not identical you must use the parameter ‘SOURCEDEFS’ pointing to the source table definition and ‘COLMAP’ parameter to map the columns from source to target. |
|