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
What is dbcc? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What is fill factor? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
How to start SQL Server in minimal configuration mode?
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.
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you schedule a job in database?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what are the types of connection load-balancing?
how can you communicate with operating system files from oracle?
What would you do with an "in-doubt" distributed transaction?