i have a sales project interviewe asked tel me the how many
facts&dimensions used in ur project.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pooja
Multi fact models exist as well. And number of facts and
dimensions depends on the model.
Is This Answer Correct ? | 0 Yes | 0 No |
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
what is filter?give me one example that you created a report in your project?
can we create a chart without measure
How to create model and how to test model?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What is a Cube?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What is difference between informatica power mart and power center?
----------How to cretae a Template?
Types of Performance Tuning?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?