The Integration Service uses cache memory to create an XML target. The Integration Service stores the data and XML hierarchies in cache memory while it generates the XML target.
The Integration Service creates the following types of caches for an XML target:
Data cache.
Stores XML row data while it generates an XML target document. Stores one data cache for all groups.
Index caches.
Stores primary keys or foreign keys. Creates a primary key index cache and a foreign key index cache for each group.
