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 |
What is InformaticaPowerCenter?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Why union transformation is an active transformation?
what is the use of Data Mart?
How do you use reject loader.
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
Router T/R is active but some people are saying it is also passive which is exactly right?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the databases that informatica can connect to windows?
why union is active transformation?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna