why dimenstion tables are denormalized in nature ?
Answers were Sorted based on User's Feedback
Answer / siddu
For fast retrieval(to Perform a SELECT Operation)
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ankit kansal
As a denormalized table structures for a database the number
of joins to fetch the data turns out to be less and hence selection to the data becomes faster.
selecting data from one table is always better than selecting the same data from multiple tables.
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 1 Yes | 0 No |
how to improve performence by using sorted input in aggrigator t/r.
how may sources can be used in a mapping at a time?(limit)
what is the purpose of surrogate key and diff between primary key&surrogate key
How to open an older version of an object in the workspace?
What is difference between stored procedure transformation and external procedure transformation?
In target table how to display the system time
What is meant by LDAP users?
What is a pre-defined event and user-defined event?
How we can create indexes after completing the loan process?
what is unique constraint error ?
What are junk dimensions?
How to load last n records of file into target table - informatica