I have a scenario where I have to load a table called 'Client' many times like 'Client', 'Agency', 'Contact'.
I realised I can use 'Resident' load. But quite not sure how to create keys that are relevent to the meaning of the table so that it will join to associated table.
The associated table 'Orders' has got the keys 'CLIENT_ID', 'AGENCY_ID', 'CONTACT_ID'.
And the 'Client' table has got the key is 'CL_ID'. This is joined to the above keys.
I have loaded the tables seperately without using 'Resident' and can see the data model. Reloaded successfully and data is visible.
But what is the best practice ? Can any one help me to achieve this please?
You would probably need to rename fields of your Client table other than CL_ID also to avoid a synthetic key / circular reference.
If you are loading the Client table from a QVD, I would assume that it is even better to load CLIENT, AGENCY, CONTACT directly from the QVD (and using RENAME FIELDS or AS) than doing a resident table LOAD.
