Give the two types of tables involved in producing a star
schema and the type of data theyhold.
Answers were Sorted based on User's Feedback
Answer / monal
FACT TABLE: SALES
DIMENSION TABLE: GEOGRAPHY, PRODUCT, TIME
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
What is the difference between the SQL Loader and IMPORT utilities?
how can you create a user-defined lock?
How do you add a data file to a tablespace?
one datafile is lost in standy side how can you recover that??
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
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How would you determine who has added a row to a table?
How can you rebuild an index?
What the different topologies in which replication can be configured? : sql server DBA
How do you resize a data file?
How can you control the amount of free space in your index pages? : sql server DBA
Where in the Oracle directory tree structure are audit traces placed?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)