During this first example, we'll be moving data from a Customer System database into a data mart. To keep things simple for this stage, we'll deal with just one source table and one target table, and they're both hosted in Oracle databases. However, the structures and formats of these two tables are different, so we'll have to perform some transformations and enrichments along the way. Having accurate and enriched customer data moving from our source Customer System into the data mart will be a key foundational element of being able to process orders within the Purchase Order (PO) processing solution.
It just so happens that in our example environment, both tables are held in schemas managed by the same Oracle server instance and we could probably achieve our integration task with a single SQL statement. However, we're going to simulate having these schemas held on different servers, because in a production system that's far more likely to be the case.
Also, we...