ie. whether it should be Star schema or snow flake schema?
Latest Answer: Pro Star Schema:
Users find easier to query and faster query times.
Space consequences of repeated data makes little difference as Dimensional
table hold relatively fewer rows then the large Fact tables.
Pro Snowflake Schema:
DBA ...
What are the different Data Modeling software tools? Which one is considered the best among all in terms of cost, efficiency and usability ?
Latest Answer: Visio; ERwin; Rational. Rational is considered the best. ...
Manages's salary details are hidden from employees This is 1. conceptual level of data hiding 2. physical level of data hiding 3. external level of data hiding 4. either 1 or 2
Match the following in the context of data flow diagram : i. circle a. source of data ii. square b. file or data base iii. arrow c. conversion process iv. parallel line d. data flow 1. l-a, ll-b,lll-c, lv-d 2. l-c, ll-a, lll-d, lv-b 3. l-c,ll-d, lll-a, lv-b 4. l-b, ll-a, lll-d, iv-c
Data modelling is the process of constructing 1. An orderly arrangement of data elements 2. A graphic representation of data contained in an information system 3. Physical elements of the information system 4. A verbal description of the data need
Generally speaking,for a weak entity set to be meaningful it must be part of a 1. one-to-one relationship 2. one-to-many relationship 3. many-to-many relationship 4. depends on a particular situation
Latest Answer: Star schema - normalized one snow flake-denormalized ...
Latest Answer: Data sparsity is term used for how much data we have for a particular dimension/entity of the model. It affects aggregation depending on how deep the combination of members of the sparse dimension make up. If the combination is a lot and those combinations ...
What is the difference between hashed file stage and sequential file stage in relates to DataStage Server?
Latest Answer: When there are performance issues, that would be improved by denormalizing the database. ...
View page << Previous 1 [2] 3 Next >>
Go Top
