While the usage of the consumer transformation is quite popular, one of the feature that PowerCenter offers, which is rather less used, is the "webservice consumer source". The video demonstrates how webservice consumer source is used in PowerCenter with the pro and cons of the same.
Converting and adding of a self signed certificate to use a Webservice Consumer transformation
How to unassign services from an expired key and assign them to a valid key in 9.1.0 and 9.5.1
How to find in which host the Repository Integration service is running in a multi node domain