A data warehousing configuration is a many-to-one configuration. Multiple source databases send data to one target warehouse database. Oracle GoldenGate supports homegeneous and heterogeneous transfer of data, with capabilities for filtering and conversion on any system in the configuration although the support varies by database platform.

If data is being consolidated into a single target database, it is often necessary to track the lineage of that data. Using Oracle GoldenGate Tokens (link), additional metadata can be written to the target records. This would include the source database information on where this record originated, or when it was committed on the source database.

Oracle GoldenGate transformation routines can be used to further enhance the data as it is applied to the target database or data target.