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

Why would you call update statistics? : sql server DBA

0 Answers  

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,

what is the differnce between process and thread ?

1 Answers   IBM,

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

Hot backup procedure?

2 Answers  

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

Name a tablespace automatically created when you create a database.

5 Answers  

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

How to determine the service pack currently installed on SQL Server?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories