OraFAQ Forum: Data Integration » Create FACT and DIMENSION table commands

Home » Developer & Programmer » Data Integration » Create FACT and DIMENSION table commands

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create FACT and DIMENSION table commands [message #92853]

Wed, 07 November 2001 08:33

Joel Esteva
Messages: 1
Registered: November 2001

Junior Member

Other than the CREATE TABLE command in ORACLE, are there any other CREATE commands specifically for FACT or DIMENSION tables?

----------------------------------------------------------------------

Report message to a moderator

Re: Create FACT and DIMENSION table commands [message #92855 is a reply to message #92853]

Wed, 07 November 2001 21:35

sagar
Messages: 11
Registered: December 2000

Junior Member

We have create dimension command in which we can specify the hierarchies and attributes within the dimension table. We do not have create fact command. More information can be available at the following site

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76994/toc.htm

Sagar

----------------------------------------------------------------------

Report message to a moderator

Re: Create FACT and DIMENSION table commands [message #92862 is a reply to message #92853]

Tue, 20 November 2001 02:45

jpn
Messages: 2
Registered: November 2001

Junior Member

Hi,

Through oracle warehouse builder you can create dimension and fact tables(which the owb internally creates the ddl for that once u specify)

With the dimension table creation wizard you can create the respective attributes and hierarchy.

----------------------------------------------------------------------

Report message to a moderator

Re: Create FACT and DIMENSION table commands [message #93448 is a reply to message #92862]

Tue, 25 January 2005 18:15

Mot Song Heng
Messages: 1
Registered: January 2005

Junior Member

Create FACT and DIMENSION table commands

Report message to a moderator

Previous Topic:	Oracle 10g Database
Next Topic:	ORA-01653

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 04:47:33 CST 2024