Latest Answer: It is designed to support Operational Monitoring. It is subject oriented,integrated database which holds the current,detailed data.data here is volatile ...
Latest Answer: A snowflake schema is a way to handle problems that do not fit within the star schema. It consists of outrigger tables which relate to dimensions rather than to the fact table.The amount of space taken up by dimensions is so small compared to the ...
Latest Answer: Yes right said both model are designed for different purpose , I think star schema is very informative for business users unlike snowflake which is bit complicated with lot of small , small tables. If there is lot of information in one dimension table(it ...
Latest Answer: Business rule is nothging the transformation requirement which will convert the raw data into business users required presentation so that business users can query and do the analysis on the Data. ...
Latest Answer: This depends upon how the ETL is done:If we are loading data using Informatica, the workflow jobs can be scheduled using Autosys or any other scheduler, in which the scripts could check for the conditions. When using Oracle SQL Loader or Oracle External ...
Latest Answer: When data modeling, we are structuring and organizing data. These data structures are then typically implemented in a database management system. In addition to defining and organizing the data, data modeling will impose (implicitly or explicitly) constraints ...
Latest Answer: ER modelling is the first step for any Database project like Oracle, DB2.1. Conceptual Modelling2. Logical Modelling3. Physical Modelling ...
Latest Answer: Late arriving Fact table:Â Â Â Â Â Â Â This is rarely happens in practice. For example there was a credit card of HDFC transaction happened on 25th Mar 2005, but this record we received on 14th Aug 2007. During this period there is a possibility of change ...
What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?
Factable having aggregated calculations like sum, avg, sum(sal)+sum(comm),these are Aggregated FactableCheersPadhu
Latest Answer: An aggregate fact table stores information that has been aggregated, or summarized from a detail fact table. Aggregate fact table ares useful in improving query performance. Often an aggregate fact table can be maintained through the use of ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
