don't know
Latest Answer: And it is derived from primary key. ...
Latest Answer: It is logical design techniques and visual techinques it can be contain aggregate table, dimension table, fact table ...
Answered by swetha on 2005-03-30 12:00:33: OLTP Current data Short database transactions Online update/insert/delete Normalization is promoted High volume transactions Transaction
Latest Answer: Thanks Jyothsna....... ...
Data Mart is a segment of a data warehouse that can provide data for reporting and analysis on a section, unit, department or operation in the company, e.g. sales, payroll, production. Data marts are sometimes
Latest Answer: A Data Mart is the subset of the data warehouse that caters the needs of a specific functional domain.examples of functional domains can be given as Sales, Finance, Maketing, HR etc. ...
Latest Answer: There are four methods in which one can build a datawarehouse.1. Top-Down (Emphasizes the DW. )2. Bottom-Up (Emphasizes data marts.)3. Hybrid (Emphasizes DW and data marts; blends “top-down” and “bottom-up” methods.)4. Federated (Emphasizes the need to ...
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 Warehousing is Relational Database which is specially designed for analysis processing rather then for querying and transactional processing. ...
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. ...
Answer posted by Chintan on 2005-05-22 18:46:03: A table in a data warehouse whose entries describe data in a fact table. Dimension tables contain the data from which dimensions are created.
Latest Answer: Fact table is the one which contains measures of interest at most granular level.These values are numeric.Ex:sales amount would be a measure .Each dimension table has a single-part primary which exactly corresponds to one of the components of multiparty ...
Latest Answer: ODS means Operational Data store. ODS & Staging layer are the two layers between the source and the target datbases in the data warehouse..ODS is used to store the recent data. ...
Latest Answer: A dimension which can be shared with multiple fact tables such dimensions are know as conformed dimension. ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
