-------------------What is StarShema?

Answer Posted / amp mohan

StarSchema: It is a logical database implement physically
in the datawarehouse with centralized fact table
normalized, depends on the denormalized dimension
table.Advantages of starschema is slicing down,performance
increase and easy to understand the data.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of using cognos sql?

657


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1483


What is the difference between a cascading report and drill through the report?

731


how u will design the report if the objects are available

2323


What are the two types of framework manager?

679






7. What is performance tuning?

1568


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1516


What is the difference between set functions and filter function in dimensional data?

2510


what are the names of the reports that you prepared?

622


What are the types of hierarchies?

556


What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2148


Can you explain a cognos controller?

597


What is a Cube?

686


what is hints in cognos and where we use it.

1988


Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

1660