Dirk Moolman said:
> 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 ?

Just loading the data will be faster than looking up the code, but I'd
rather look up the code. Just have to handle what happens if you can't
match the city. ;o)

--
Bye now,
Obnoxio

Information within this post contains forward looking statements within
the meaning of Section 27A of the Securities Act of 1933 and Section 21B
of the S E C Act of 1934. Statements that involve discussions with respect
to projections of future events are not statements of historical fact and
may be forward looking statements. Don't rely on them to make a decision.

The poster is not a reporting company registered under the Exchange Act of
1934.

I have received a life peerage from Her Majesty, who is not an officer,
minister or affiliate Labour party member.

I intend to recover my loan now, which could cause the parliamentary
majority to go down, resulting in losses for you. Today's Labour party
has: an accumulated deficit and a reliance on loans from officers and
affiliates to pay expenses. It is not an operating political party. The
party is going to need financing to continue as a going concern. A failure
to finance could cause the party to go out of business. This report shall
not be construed as any kind of investment advice or solicitation. You can
lose all your money by investing in this party.