Interested to Buy Any Domain ? << Click Here >> for more details...
These are few Interview questions i faced.I hope to get
help here.
1.Can we convert a Crosstab to List?
2.How do you approach and who tells you what exactly the
way report has to be developed so that i meets the client
requirements?
3.Can we link the List and Chart thats created in the same
report?
4.Where do you edit sql in cognos8 ?
5.What is the difference between native sql and oracle sql?
6.What is the difference between MOLAP and ROLAP?
7.What is the use of BI in datwarehousing?
8.What are set functions?
9.How do you test a report?
10.What are the variables you find in toolbox?
11.How many types of filters are there in cognos8?
All the answers r welcomed .U can reach me at
vinod.davala@gmail.com
- 4 Answers
- 10505 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / raja
06.
MOLAP ROLAP HOLAP
MOLAP (multidimensional OLAP) tools utilize a pre-
calculated data set, commonly referred to as a data cube,
that contains all the possible answers to a given range of
questions. MOLAP tools feature very fast response, and the
ability to quickly write back data into the data set
(budgeting and forecasting are common applications).
Primary downsides of MOLAP tools are limited scalability
(the cubes get very big, very fast when you start to add
dimensions and more detailed data), inability to contain
detailed data (you are forced to use summary data unless
your data set is very small), and load time of the cubes.
The most common examples of MOLAP tools are Hyperion
(Arbor) Essbase and Oracle (IRI) Express. MOLAP tools are
best used for users who have "bounded" problem sets (they
want to ask the same range questions every day/week/month
on an updated cube, e.g. finance).
ROLAP (relational OLAP) tools do not use pre-calculated
data cubes. Instead, they intercept the query and pose the
question to the standard relational database and its tables
in order to bring back the data required to answer the
question. ROLAP tools feature the ability to ask any
question (you are not limited to the contents of a cube)
and the ability to drill down to the lowest level of detail
in the database. Primary downsides of ROLAP tools are slow
response and some limitations on scalability (depending on
the technology architecture that is utilized). The most
common examples of ROLAP tools are MicroStrategy and
Sterling (Information Advantage). ROLAP tools are best used
for users who have "unbounded" problem set (they don't have
any idea what they want to ask from day to day; e.g.,
marketing). It is very important to pay close attention to
the underlying architecture of ROLAP tools, as some tools
are very "scalability challenged."
HOLAP (hybrid OLAP) addresses the shortcomings of both of
these technologies by combining the capabilities of both
approaches. HOLAP tools can utilize both pre-calculated
cubes and relational data sources. The most common example
of HOLAP architecture is OLAP services in Microsoft SQL
Server 7.0. OLAP vendors of all stripes are working to make
their products marketable as "hybrid" as quickly as
possible. It is critically important to closely examine the
architectures of these "repackaged/repositioned" offerings,
as their "HOLAP" claims may be more marketing hype than
architectural reality.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
how to merge 2 crosstabs thans
Explain the characteristics of cognos?
Can you define slice?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
Which studio is used to create reports?
5. Which type of report you build more, list, crosstab or chart and why?
How can you link a query to a data container manually in Report Studio?
what are the dimensions that you have in your current project?list them?
Why cognos decision stream is used?
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?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
What is difference between primary key and unique key constraints?
What is drill down and slicing and dicing whats the difference between them?
