Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Star Schema
Hi there,
I have a few questions for implementing star schema in Oracle. Please help. I am going to build a DW for my project where with 4 dimension and one fact table where the definition of the tables are as follows :
A_DIM (A_ID, A_DESC) B_DIM (B_ID, B_DESC) C_DIM (C_ID, C_DESC) D_DIM (D_ID, D_DESC)
select amount, a_desc, b_desc, c_desc, d_desc from
a_dim, b_dim c_dim, d_dim,
and b_dim.b_id = 2 and a_dim.a_id = this_fact.a_id and b_dim.b_id = this_fact.b_id and c_dim.c_id = this_fact.c_id and d_dim.d_id = this_fact.d_id;
Ken Received on Sat May 20 2000 - 00:00:00 CDT