Latest Answer: In Integrated schema Design, a dimension which can be shared across multiple fact tables is called Conformed Dimension. ...
Latest Answer: SCD1-> Slowly Changing Dimension Type1This type will overwrite new records with old records without caring about the history.SCD2-> Slowly Changing Dimension Type2This type will create a duplicate records with neccessary changes without disturbing ...
Answer posted by Badri Santhosh on 2005-05-18 09:40:29: Normalization : The process of decomposing tables to eliminate data redundancy is called Normalization. 1N.F:- The table should caontain
Latest Answer: To paraphrase the oath, and help you remember, in 3rd normal form data in the table depends on the key, the whole key, and nothing but the key. ...
Answered by sunitha on 2005-04-28 21:17:53: ETL is extraction,trasformation and loading,ETL technology is used for extraction the information from the source database and loading it to the target database
Latest Answer: ETL is a process that extracts data from one database, transforms it as per the destination database and loads it into another database. In the transformation process, data is actually standardized to make it compatible with the destination database. ...
Latest Answer: Non Additive facts cannot be aggregrated along with dimenstion in the fact table. For eg. Age, weather ...
Latest Answer: Find where data for this dimension are located. Figure out how to extract this data. Determine how to maintain changes to this dimension (see more on this in the next section). Change fact table and DW population routines. ...
Latest Answer: An DW is typically used most often for intensive querying . Since the primary responsibility of an OLTP system is to faithfully record on going transactions (inserts/updates/deletes), these operations will be considerably slowed down by the heavy querying ...
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: A fact table in a data warehouse is one which contains the numeric data, can be further distributed as 'Additive Facts' and 'Non-Additive Facts'.Additive facts can be the sum of salaries.Non-Additive facts can be something ...
What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables
Latest Answer: The smallest unit of analysis is called as 'grain'. Also known as the atomic unit of analysis. Deciding the grain and then on basis of it, the aggregation level is called as the granularity of a fact table. ...
View page << Previous 6 7 8 9 [10] 11 12 Next >>
Go Top
