You can create a subset of production data if you need a small, targeted, and referentially intact copy of the production data to use in a nonproduction environment. A nonproduction environment might include development, test, or training environments.
For example, you might create a subset of financial data for a specific region or time period.
You can create a data subset from relational, flat file, or XSD sources.
To create a data subset, you define data subset components and add them to a plan. The components that you create depend on the type of data source and the data subset that you require.
You can generate a workflow from the plan. The workflow loads a subset of the source data into a target database.