Give the two types of tables involved in producing a star
schema and the type of data theyhold.
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 process messages in order asynchronously?
Which autogrowth database setting is good? : sql server DBA
How to start SQL Server in minimal configuration mode?
what is the role of dip user in our database?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How would you extract DDL of a table without using a GUI tool?
how can you implement fine-grained auditing?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
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.
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.