Home » Developer & Programmer » Data Integration » Snowflake schema (oracle 10g)  () 1 Vote
Snowflake schema [message #299013] Fri, 08 February 2008 09:58 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi

This question is for all the warehouse builder guru's. I created a new starschema and now i have to attach another dimesnion table to the existing star schema ( attach to already existing dimension in the schema), but the ware house builder is not letting me do it, please any suggestions are welcome.



Thanks

Report message to a moderator

Re: Snowflake schema [message #299258 is a reply to message #299013] Mon, 11 February 2008 01:03 Go to previous messageGo to next message
sunilgond
Messages: 35
Registered: January 2008
Location: INDIA
Member
Hi aarti ,


Can you, please explian your question.


Regards,
Sunil Kumar Gond

Report message to a moderator

Re: Snowflake schema [message #299360 is a reply to message #299258] Mon, 11 February 2008 12:10 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
i have 4 dimension tables and each dimension table is again divided into 2 more dimensions , how do i add these in the oracle warehouse builder?


thnks

Report message to a moderator

Re: Snowflake schema [message #299420 is a reply to message #299360] Tue, 12 February 2008 00:28 Go to previous messageGo to next message
sunilgond
Messages: 35
Registered: January 2008
Location: INDIA
Member
Hi Arti,

How are you doing? You can create staging area for your first dimension and then create your second dimension with this staging area.I think You need the pramary key of first dimension.




Regards,

Sunil Kumar Gond
Satyam Computer Services Ltd.
+919912125600

Report message to a moderator

Re: Snowflake schema [message #299551 is a reply to message #299420] Tue, 12 February 2008 07:21 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi Satish

My question is, in the target i created a fact table and added the dimensions to it, but now when i'm trying to add another dimension to the already existing dimension table it wont let me do it. I hope i explained my problem clearly?



Thanks

Report message to a moderator

Re: Snowflake schema [message #303532 is a reply to message #299551] Fri, 29 February 2008 13:32 Go to previous messageGo to next message
julianof
Messages: 2
Registered: February 2008
Junior Member
Were you able to find an answer? I am also trying to extend the dimension (add tables) to create a snowflake. I thought that once I select the snowflake option I will see in detail view separate tables per level, but it did not happen.

Report message to a moderator

Re: Snowflake schema [message #303534 is a reply to message #303532] Fri, 29 February 2008 13:36 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Unfortunately no, but i'm following a different approach...........instead i'm using the SQL*Loader and using the "loading nested column objects" option.It works fine so far. Smile In this way we need not opt the snowflake schema.

Report message to a moderator

Re: Snowflake schema [message #303538 is a reply to message #303534] Fri, 29 February 2008 13:41 Go to previous message
julianof
Messages: 2
Registered: February 2008
Junior Member
Thanks!

Maybe somebody else has experience with it.

Report message to a moderator

Previous Topic: error loading flat file
Next Topic: working with constant
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 21:12:05 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.