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
- 8337 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 commit the current transaction in oracle?
How to get last row id?
what are the default admin accounts in Oracle 10g ?
what is the difference between substr and instr function in oracle?
How to sort output in descending order in oracle?
what is the scenario where you take the database to NoArchivelog mode?
What happens to the current transaction if a ddl statement is executed?
material view and view disadvantages?
What is the difference between Delete, Truncate and Drop in Oracle?
What is the difference between formal parameters and actual parameters?
What is a snapshot log?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Is there a combination of "like" and "in" in sql?
Please explain compound trigger in oracle?
How to create tables for odbc connection testing?
