I have two tables in SQL Server that I need to update. One table contains Customer data, and the other contains Order data. A customer can have any number of orders, including zero. If she does have any orders, then the Order table contains her customerID, along with the orders. In other words:
CustomerID (unique, auto-insert)
Order Info, etc.
The data I need to load is denormalized, so it looks like this:
Alex More Books
. . .and so on. I can load the Customer table without issue. However, I don't know how to load the Orders table, since I need the CustomerID from the Customer table, and I don't have any way to link that back to the denormalized data to find the actual orders. Does anyone have any advice?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema