How to pass filters like $top = 1000 to servicerooturi in informatica cloud while using odata connector?
You can try this with JDBC connector enabled for OData.
The OData URL can be appended with the options like top and skip to paginate
Sample URL would look like:
You can refer below video for more information.
How to create a JDBC Connection
OData (data-as-a-service) and Pagination using JDBC Connection
Retrieving data ...