In realtime which one is better star schema or snowflake star schemathe surrogate will be linked to which columns in the dimension table.thanks in advance

Questions by kiran_stealth@yahoo.com

Showing Answers 1 - 5 of 5 Answers

reddy312

  • May 5th, 2006
 

surrogate keys are added to critical columns in

  Was this answer useful?  Yes

shaik

  • Jun 27th, 2006
 

In real time only star schema will implement because it will take less time and surrogate key will there in each and every dimension table in star schema and this surrogate key will assign as foreign key in fact table.

  Was this answer useful?  Yes

naga

  • May 24th, 2007
 

In realtime star schema is the better one. Surrogate key is linked to the lowest level. For example country, state, city, area in this surrogate key is with 'AREA'

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions