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 >> Data Warehouse >> Cognos
  2. Suggest New Category

What snowflake and Starschema?

Question Posted / vinod

Answers were Sorted based on User's Feedback



What snowflake and Starschema? ..

Answer / bhaskar.nagi

Star Schema: Star Schema contains Centrally located Fact
table sourended by Dimension Tables. So Data Base design
looks like a Start. Fact table contains the fact information
at the lowest level granularity. Fact table contains Foreign
keys and Dimension Table contains Primary key.

Snow Flake Schema: In a star schema, if a dimension table is
spleted into one or more dimension results in normalization
of dimensions. Since the database design looks like snow
flake structure.

Is This Answer Correct ?    7 Yes 0 No

What snowflake and Starschema? ..

Answer / srini madhala

Star Schema:In Star shema we have fact table sorrounded by
diemension table.Since the shape looks as a star its called
as star schema

Snow Flake Schema:

in Snow flake schema we have fact table sorrounded by
diemension table and the diemensional table have their child
diemensions.Its denormalized

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Cognos Interview Questions

What you mean by drill across and what is the difference between drill through, drill across?

0 Answers  

Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,

is cognos 7 is better than cognos 8

0 Answers   TCS,

Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?

4 Answers   IBM, Wipro,

Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

7 Answers  

Can you define query studio?

0 Answers  

What is meant by Tabular SQL in Cognos Report net

3 Answers   Infosys,

These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?

2 Answers   IBM,

if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?

3 Answers   CTS, TCS,

7. What is performance tuning?

0 Answers  

how to convert crosstab into list?

4 Answers   TCS,

what is mean by cognos powerhouse?

1 Answers   TCS,

For more Cognos Interview Questions Click Here
Categories