Can a Data Warehouse also be used for Transaction Database? If Yes Why, If No Why not?
Latest Answer: No, a data warehouse cannot by definition be used as a transaction database. A data warehouse is "read only" data that does not change once it has been loaded and used for information purposes. Data is loaded into a data warehouse ...
How does the usage of Dataset improve the performance during lookups?
What are Staging and Operational Data Stores and what is their difference?
Why does one need staging and why does one need ODS? What will happen if they are not there? Who and how is it decided that a
Latest Answer: Staging area is also called 'Operational Data Store'™ (ODS). It is a data holding place where the data which is extracted from all the data sources are stored. From the Staging area, data is loaded to the data warehouse. Data cleansing takes place ...
What are the various OLAP & MOLAP operations?
Explain why database design is important?
When is the need to do OOAD (Object oriented analysis & design)
How you differentiate between SOA & Web Services?
If you take a print out of your model in ERWIN tool, What all you will be able to see?
Latest Answer: According to the selection of print we can view in the print out. we will be able to view all the tables with their feild name, primary key, datatype, relation between the tables and their flow. ...
Why do we use Surrogate Key?
Latest Answer: Surrogate keys are system generated keys. They are integers.Surrogate keys are extremely useful when having type 2 data ( i.e. storing historical information)For ex: Consider one has a table in which a person and his location are stored. Now when his ...
How anyone define the pracical difference between Kimball & Inmon?
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
