Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Question regarding view

Question regarding view

From: Mangood <marcin.sworzynski_at_gmail.com>
Date: 20 Apr 2006 01:04:52 -0700
Message-ID: <1145520292.474594.17010@z34g2000cwc.googlegroups.com>


Hi everyone
I'm building datawarehouse using classical star schema. I have dimension called sellto_dim and second dimension called shipto_dim which is identical as sellto_dim. My idea is to create only view based on sellto_table instead of creating second physical table. The question is if it's possible to add primary key constraint to view and connect it with foreign key in fact table.
Thanks in advance. Received on Thu Apr 20 2006 - 03:04:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US