Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Explain about scorecarding?
What are the considerations regarding performance kept in mind while setting up cognos?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What are all the types of gateway used in Cognos?
is cognos 7 is better than cognos 8
Can you explain the advantage of using shortcuts?
what is catalog and types of catalogs in cagnos and which is better?
What is a Query Subject?
Name the types of gateway?
------------ Diff b/w MemberCaption and MemberDescription?
Explain the difference between powerplay transformer and power play reports?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
