Home » RDBMS Server » Server Administration » star schema to demormalized table
star schema to demormalized table [message #372058] Mon, 08 January 2001 13:21
meena
Messages: 36
Registered: December 2000
Member
Hi,

I have a star schema with say, 10 tables. I have to create a denormalized table( by stretching the arms and legs of the star schema and creating horribly long rows)from this star schema. I also have to load the data from the star schema into the demormalized table.

Can anyone tell me the simplest way of doing this?
Thanks!
Meena

Report message to a moderator

Previous Topic: ORDER BY and rank
Next Topic: Re: Is JOIN a better choice over SUBQUERY ? Pl. expl.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 05:49:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.