Is data, transient or periodic in data mart? Explain
Latest Answer: Data marts are part of OLAP system. Data in datamarts cannot be trasient. Data will be updated in datamarts on a periodic or daily basis depending on the design of the data warehouse.-Ashish ...
Can a Data Warehouse also be used for Transaction Database? If Yes Why, If No Why not?
Latest Answer: As the definaton of Datawarehouse say it is repository of historial data which is used by Busines users to run some reports on his/her area of interests.Data is not loaded everyhour or every mtes in Data warehouse. so cannot be used as transaction. But ...
How does the usage of Dataset improve the performance during lookups?
Latest Answer: Correct me if i misunderstood your question. I think you want to know whether the usage data will improve the graph performance. I think definitely the usage of data will definitely improve the graph perfomance. If you data set in lookup is minimal and ...
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 and Operational Data Store What are Staging and Operational Data Stores and what is their difference?An operational data store (or "ODS") is a database designed to integrate data from multiple sources to make analysis and reporting easier.Staging ...
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 ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>

Go Top