I have a extract with 10 tables.
The head table is:
SOURCE: tbClient [cliendID=1,name=Kate] then I have tables like tbAddress, tbAccount, tbInvoice, etc.
TARGET: tbClient [clientID=50,name=Perry]
I have to copy all data (from all tables in subset) from '1-Kate' on source to '50-Perry' on target.
I have the list of corresponding ID's on target. About 15 clients.
So, how do I point the data from 1-Kate on source to 50-Perry on target?