Give the two types of tables involved in producing a star
schema and the type of data theyhold.
- 2 Answers
- 6625 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
FACT TABLE: SALES
DIMENSION TABLE: GEOGRAPHY, PRODUCT, TIME
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
how can you create a user-defined lock?
how can you record information about current session?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what are the differences of where and if in SAS?
What are the commands used in dcl? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what functionality does oracle provide to secure sensitive information?
How do you trace the traffic hitting a sql server? : sql server DBA
what do you understand by flashback feature of oracle?
What authentication modes does sql server support? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
