Updating SQL Server tables with a foreign key relationship

Anonymous — Thu, 08 Mar 2018 18:22:17 GMT

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:

Customers

CustomerID (unique, auto-insert)

Name, etc.

Orders

CustomerID

Order Info, etc.

The data I need to load is denormalized, so it looks like this:

Name Order

Alex Books

Alex More Books

Rebecca NULL

. . .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?

Re: Updating SQL Server tables with a foreign key relationship

TRF — Thu, 08 Mar 2018 19:29:44 GMT

Hi,
I'm afraid you have to query the customer table after you have finish to insert rows. Then you'll be able to get the id to use in the order table as a foreign key.

topic Updating SQL Server tables with a foreign key relationship in Talend Studio

Updating SQL Server tables with a foreign key relationship

Re: Updating SQL Server tables with a foreign key relationship