Dimension tables is de-normalized in the nature
Clarify briefly why dimension tables is de-normalized in the nature?
Expert
Since in the Data warehousing past data must be maintained, to uphold past data means assume one employee details such as where previously he worked, and currently where he is working, all details must be maintain in the single table, if you maintain primary key it won't let the duplicate records with similar employee id. So to maintain past data we are all going for concept data warehousing by using surrogate keys we can achieve the historical data (by using oracle sequence for critical column). So all the dimensions is marinating past data, they are de-normalized, due to duplicate entry means not accurately duplicate record with similar employee number another record is maintaining in table.
Describe in brief regarding the features of the Sybase IQ?
You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must be done to convert the one--to-one STUDENT -COMPUT
What is Relational Algebra?
Explain the term queue in data structure? Answer: In data structure a queue is a sequential organization of data. It is a first in first out i.e. FIFO type of data s
Illustrates all databases should be in third normal form or not?
Describe the meaning of each of the transaction stages supported by SQL Server?
Briefly explains the three kinds of SQL commands?
Explain the linked universes?
Illustrate the use and application of the DB Miner.
Explain the function of metadata for the three-layer architecture?
18,76,764
1951512 Asked
3,689
Active Tutors
1438603
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!