In one of my previous post, I described about the process of Data Subset. In this post we will focus on the implementation approaches to data sub-setting.
There are 3 broad categories in which you can implement sub-setting.
SQL Query based approach
In this approach, we will use SQL queries to fetch the subset of the production data and load them it into the target environment. Lets assume you have 2 tables in your production from which you need to create a small subset. The following shows the relationship of the tables Customers and Orders where they are related through the custid field.
The picture also shows the sample data within those tables. So we need to subset this. We find out a sample condition. Lets assume we will pull out only the customer ids which are odd numbers. A simple query will do this trick. The following will be the query for the Customers table.
