A resource mapping does not contain a Filter transformation or a Lookup transformation to filter data for client requests. If the web service request message contains a filter query, the Data Integration Service filters the data after the mapping retrieves it. The Data Integration Service caches the data in the response message when the Result Set Caching property is enabled for the Data Integration Service in the Administrator tool. When the web service request contains filter parameters, the Data Integration Service filters rows from the cache.

When you define a resource mapping, create one of the following types of resource mappings:

Default resource mapping

A default resource mapping contains a Read transformation and an Output transformation. The mapping does not contain other transformations. The mapping returns all the rows in a data object without changing them. To create a default resource mapping, create the web service from a data object or deploy a data object as a web service.

Custom resource mapping

A custom resource mapping is any mapping that is not a default mapping. A custom resource mapping might contain a Read transformation with different columns than the Output transformation. A custom resource mapping might contain transformations between the Read transformation and the Output transformation in the mapping. The transformations can add columns or change the columns in the pipeline.

For example, the resource mapping might contain an Expression transformation that combines two columns and returns a third column. Or, the resource mapping might contain a transformation that returns multiple-occurring rows. You can create a custom resource mapping when you manually create a resource. You can also change a default mapping by changing the Read transformation or adding more transformations to the mapping.