The solution that I provided in the last comment is the way to access the last page, getting the “Total number of rows in the resultset”.
Regarding the performance issues that you commented, when it comes to querying more number of rows, it will affect performance and that is the reason why there is no direct option to go to the last page in a Rest Web Service.
To be able achieve this in Denodo, the Virtual DataPort Server would need to get all rows first. That is not efficient way. The way Denodo works is returning only the needed information every time, so if you are in the first page, you will retrieve only the elements for the first page. If you need it you have the option to get the total number of rows and with that value you can easily navigate to the last page as I have mentioned in previous message.
Assuming you want to see the latest records and that is the reason you want to jump to the last page, I can give you another workaround:
You can order your results in descendant order to get the last rows in the first page. If you need, you can create a new column called rowid with function rownum() in Virtual DataPort. Then before publishing your view as a rest webservice, order by the view in descendant order, by your field or rowid. In this way you will get the latest records as your first page.
Hope this helps.