Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Question regarding view
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
![]() |
![]() |