i have a sales project interviewe asked tel me the how many
facts&dimensions used in ur project.
- 2 Answers
- 4624 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sathish
Hi,
Dimensions table is something that is called by the fact
table, so if you take the star schema for example the fact
is the center of the star schema and dimensions are like
the wings like of things,
so fact are usually the only one, the dimensions might vary
depending upon the requirements and needs'
feel free to contact any queries,
sathishcnpt.938@gmail.com
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What are all the advantages of Cognos?
What is difference between data mart and data warehouse?
how you provide security to reports? How you provide security to packages ?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
How to create model and how to test model?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What is difference between primary key and unique key constraints?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
Is it possible to join multiple Databases in a Catalog?
Write some methods to apply securities in framework manager model?
Explain informatica architecture?
What is called a slice?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
