Home » Developer & Programmer » Data Integration » Create FACT and DIMENSION table commands
Create FACT and DIMENSION table commands [message #92853] Wed, 07 November 2001 08:33 Go to next message
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?

----------------------------------------------------------------------
Re: Create FACT and DIMENSION table commands [message #92855 is a reply to message #92853] Wed, 07 November 2001 21:35 Go to previous messageGo to next message
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

----------------------------------------------------------------------
Re: Create FACT and DIMENSION table commands [message #92862 is a reply to message #92853] Tue, 20 November 2001 02:45 Go to previous messageGo to next message
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.



----------------------------------------------------------------------
Re: Create FACT and DIMENSION table commands [message #93448 is a reply to message #92862] Tue, 25 January 2005 18:15 Go to previous message
Mot Song Heng
Messages: 1
Registered: January 2005
Junior Member
Create FACT and DIMENSION table commands
Previous Topic: Oracle 10g Database
Next Topic: ORA-01653
Goto Forum:
  


Current Time: Fri Mar 29 04:52:36 CDT 2024