sql server data warehouse: if you were me, how you do? -- sql server data warehouse

Re: if you were me, how you do?

toddack NO[at]SPAM hotmail.com
2/11/2004 4:37:59 AM

sql server data warehouse: U-
You need to consider is this for a transactional system, which it
sounds like or is the purpose of this for Data Warehousing and the
system already exists.

What you need to do is create your transaction system which is going
to be a normalized architected system. Where you might have a Vendor
table, Location Table, City Table, State, exhibit, etc.

If history of a vendor is required, you will have no choice but to
create new records for the vendor with some sort of time stamp on it
to identify when the modification was made.

This question might be in the wrong forum and this should get you on
your way.

HTH
-todd

[quoted text, click to view]

if you were me, how you do?

Utada P.W. SIU
2/11/2004 10:59:37 AM

I am writting a online exhibitor management system.

My client can allow to modify their exhibitor's information, however, they
will like to create ne record instead of overwrite the current exhibitor's
information (exhibitor version control)

if you were me, when the client update one of exhibitor's information, you
will save the whole data and than create a set duplicated data, or just
create new record for that exhibitor?

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data warehouse group.