Way to solve the Chasm trap
Explain how the Chasm trap is solved?
Expert
It’s detected through the visual analysis of the schema. A chasm trap is generally solved in the following way:
a) Using the Multiple SQL statements for every Measure
b) Creating the Context
c) Creating the Multiple Universes (WEBI)
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Explain briefly the term an outer join?
Can we stop and start one session in the concurrent batch?
What is meant by the User Objects? Specify some of its restrictions?
Illustrates the case statement present into stored procedure?
Briefly describe the foreign key columns in dimension table and fact table?
Briefly define and describe the term data constraints?
Describe briefly the term recursive relationship? Comprise an appropriate example?
Define the term Cognos 8 BI?
Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display
18,76,764
1943896 Asked
3,689
Active Tutors
1431701
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!