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.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables