Latest Answer: Diff b.w OLTP and OLAP :------------------------OLTP Schema :* Normalized * More no.of trans* Less time for queries execution* More no.of users* Have Insert,delete and update trans. OLAP (DWH) Schema :* De Normalized * Less no.of trans* ...
Latest Answer: By far, the best ETL tool on the market is Hummingbird Genio.Hummingbird is a division of OpenText, they make, among other things, connectivity and ETL software. ...
Latest Answer: Dimensional modelling consist of 3 stages1.conceptual Requirementshere business architect should be clear with facts and levels (data for Dimension table)2.Logical requirementshere he has to design dimension table with levels, and c=fact table with facts ...
Answered by Kiran on 2005-05-06 20:12:19: The perception of what constitutes a VLDB continues to grow. A one terabyte database would normally be considered to be a VLDB.
Latest Answer: Very Large Database (VLDB)it is sometimes used to describe databases occupying magnetic storage in the terabyte range and containing billions of table rows. Typically, these are decision support systems or transaction processing applications serving large ...
Latest Answer: Real time Data warehousing means combination of hetrogenious databases and query and analysis purpose and Decisionmaking and reporting purpose. ...
Latest Answer: When you design a DB you always use identification numbers to define objects instead of the actual name or description and store the description in a lookup table.that makes any later update or insertion of any name or description ...
Latest Answer: A sheduling tool is a tool which is used to shedule the datawarehouse jobs...All the jobs which does some process are sheduled using this tool, which eliminates the manual intervension. ...
Answered by on 2005-03-23 01:45:54: bitmap index
Latest Answer: Hash Index - If we know that the hashing will result in uniform distribution and doesn't create hotspots (spikes-chaining).Bitmap Index -
If the degree of cardinality is high for the attribute, means that there are more unique number of values for ...
Latest Answer: Raid 0 - Make several physical hard drives look like one hard drive. No redundancy but very fast. May use for temporary spaces where loss of the files will not result in loss of committed data. Raid 1- Mirroring. Each hard drive in the ...
Data Warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated....This makes it much
Latest Answer: Data warehouse is Subject oriented,Integrated Non volatile, Time variant collection of data. unlike transactional systems. Its a Denormalized huge database.Used for Querying and Reporting Analytics. ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 Next >>
Go Top
