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

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

How would you determine who has added a row to a table?

4 Answers  

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

when does an alert gets signaled?

0 Answers   Oracle,

What is dcl? : sql server DBA

0 Answers  

What is blocking and how would you troubleshoot it?

1 Answers  

How to make a replica of existing oracle server to another server?

3 Answers  

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

what is meant by gateway

1 Answers   IBM,

What is transparent data encryption? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories