Merge Logical Table Sources

Special rules govern how to merge column mappings in logical table source objects. Each column mapping is merged individually.

For each column, if the mapping has changed in either the modified or current repository, the change is kept. If the mapping has changed in both repositories, the Oracle BI Server attempts to merge the mappings automatically.

The deletion of a column isn't considered to be a change in its mapping. If a column isn't present in the modified repository, then the mapping in the current repository is used instead.

If there are differences in aggregation content, then the aggregation content specified by level has priority. In other words, if the aggregation content in one repository is by level and the aggregation content in another repository is by column, then the aggregation content by level is retained.