Answer Posted / vidhya
Server Ranking:
Create dense_rank() or rank() option in sql using query
in the design phase is known as server based ranking. The
reason for this is, ranking of data is decided by the
server based upon the condition.
Usage:
Performance will be good.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
What is difference between custom hierarchy and report based hierarchy?
How were the reports scheduled and how to resolve unexecuted documents?
Explain about alerts in bos, under what situation we need to use alerts?
Explain when we use aggregate awareness function in designer?
What is top business?
What are the join problems comes appart from loop,chasm & fan Traps
What is the dense rank?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
what is the difference b/w the refresh and buffered data?
What is thumbnail?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain what three things do you consider to be the most important factors for a manager?
how to create metric universe ?
What is aggregate table and aggregate fact table ... Any examples of both?