Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

Give the two types of tables involved in producing a star
schema and the type of data theyhold.

Question Posted / guest

Answers were Sorted based on User's Feedback



Give the two types of tables involved in producing a star schema and the type of data theyhold...

Answer / monal

FACT TABLE: SALES
DIMENSION TABLE: GEOGRAPHY, PRODUCT, TIME

Is This Answer Correct ?    3 Yes 1 No

Give the two types of tables involved in producing a star schema and the type of data theyhold...

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

Post New Answer

More DB Administration Interview Questions

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

deleted of control file how will u recover control file?

4 Answers   CTS,

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

What purpose does the model database server? : sql server DBA

0 Answers  

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

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?

0 Answers  

How to start SQL Server in minimal configuration mode?

1 Answers  

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

For more DB Administration Interview Questions Click Here
Categories