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