Latest Answer: Business Rulw is nothing but a transformation needs to be applied on the dataacoording to the user requirement. e.g. in trading system notional value willbe multiplication of(fund price* shares) ...
Latest Answer: Dimensional Modelling is the Analysis of the Transactional Data (Facts) based on Master Data (Dimensions).Data Modeling is the process of creating a data model by applying a data model theory to create a data model instance.Regards,Sridhar Tirukovela ...
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 ...
Latest Answer: The only way to connect two fact tables is by using conformed dimension. ...
(NOT AS A RELATIONAL,MULTI, HYBRID?)
Latest Answer: The FUNCTIONAL difference between these is how they information is stored. In all cases, the users see the data as a cube of dimensions and facts.ROLAP - detailed data is stored in a relational database in 3NF, star, or snowflake form. Queries ...
Latest Answer: STRAGEGY & PROJECT PLANNINGDefinition of scope, goals, objectives & purpose, and expectationsEstablishment of implementation strategyPreliminary identification of project resourcesAssembling of project teamEstimation of project scheduleREQUIREMENTS ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
