-------------------What is StarShema?
Answer / 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 |
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!
What is the difference between set functions and filter function in dimensional data?
How can create users and permissions in cognos?
-------------How you design DWH?
---------- Purpose of Factless Facttable?
wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container
What do you understand by user class in cognos?
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.
what is dimention?explain dimentable with example?
Can you define pivot?
how to merge 2 crosstabs thans