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
Is there any other repository domains rather than universe, security, document?
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?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain difference between zabo and webi?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
How to restrict password to a user while sending a document in .pdf format
How to create Index to the table in the universe designer and how it improves the Query performence
How to execute the plsql procedure from the report by clicking with mouse?
what is universe null
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Explain the difference between union and group?
How would you format some text using css to be verdana and bold?
What are all difference between business objects 6.5 and xi r2?