Give the two types of tables involved in producing a star
schema and the type of data theyhold.
Answer Posted / jeshani
Fact tables and dimension tables.
A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how can you record information about current session?
what are the types of connection load-balancing?
who owns the operating system files created by the utl_file package?
how can you enable flashback feature?
What the different components in replication and what is their use? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What is fill factor? : sql server DBA
what is asm?
What are the operating modes in which database mirroring runs? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
internal architecture
What are statistics, under what circumstances they go out of date, how do you update them?