Interested to Buy Any Domain ? << Click Here >> for more details...
I know that i can create a table without a primary key.But
is there any significance for that table???? while creating
an application.
- 6 Answers
- 8097 Views
- I also Faced
- E-Mail Answers
Answer Posted / amit
Definitely yes.....While creating a Data Warehouse
application,we need fact tables to be created from various
dimension tables and the fact table load type is always
INSERT not INSERT/UPDATE.Just think of a real world example
where the need is to populate all the daily transactional
data to a Data Warehouse for analytical purpose such as
creating reports and all.Suppose the DW is loaded two times
a day.In the first load,whatever the data present in the
Transactional Database is loaded into the DW.Before the
second load there might be some sort of updation made to
some of the records,so those records need to be inserted
into the DW again in the second load.If there would be
primary key in the fact table(i,e;DW),it will raise an error
(unique constraint violated.....).So,fact tables should not
contain any primary key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is bulk copy or bcp in oracle?
What happens to the data files if a tablespace is dropped?
What is a sub query? Describe its types?
Explain the features of oracle?
Please explain oracle data types with examples?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How can Oracle users be audited?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is a oracle database?
State some uses of redo log files?
Explain about integrity constraint?
State and explain about oracle instance?
Explain enable novalidate constraint.
How to create a stored function in oracle?
What are the uses of Database Trigger ?
