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
- 7385 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
How to write an inner join with the where clause in oracle?
How to convert a string to a date in oracle database?
What is the difference between I and G in Oracle?
How to save query output to a local file?
Difference between oracle's plus (+) notation and ansi join notation?
What is recovery manager(rman) backup in Oracle?
What is raw datatype in oracle?
How to connect to a remote server?
State and explain about oracle instance?
Explain the use of record option in exp command.
What are the different types of trigger and explain its various uses and functions?
When do I need to use a semicolon vs a slash in oracle sql?
What privilege is needed for a user to query tables in another schema?
Can you drop an index associated with a unique or primary key constraint?
What are the differences between primary key and unique key?
