When I design tables, I normalise to the 3rd degree .... using lookup
tables for entities with large text fields, eg.

City:
Code integer
Name char(60)


Question:
When it comes to loading batches received from clients, and they supply
the city name in the batch file - do you denormalise and just stick the
city name into the table, or do you load into a temp table, do a lookup
on the code, and insert the code into the target table ?

What is best for overall performance in this case ?







Dirk Moolman
Database and Unix Administrator
Digicare Technologies (HealthCorp)



The other day I was trapped on an escalator for hours....the power went
out!!!


>
The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way.
>
No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty)Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.
>