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
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
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
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
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
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.
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.
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.
Previous Topic: error loading flat file
Next Topic: working with constant
Goto Forum:
  


Current Time: Thu Mar 28 04:57:21 CDT 2024