The following are known issues to the Data Mashup Service Engine:
When you create a join when using an Oracle data source and try to display the data in one of the tables, you can only view one page of output. If you click on the next button to view additional data, none is displayed. This is a design-time issue only, and the Data Mashup project works correctly when built and deployed as part of a composite application.
When you delete a table from an Enterprise Data Mashup file (by right-clicking the table and selecting Remove Table), the table appears to be removed; but when you save and close the file and then reopen it, the table is still there.
To work around this issue, do the following:
Right-click the table to remove and select Remove Table.
Save and close the file.
Reopen the file.
Right-click the table to remove again and select Remove Table.
Save and close the file.
Now when you reopen the file, the table has been removed.