Create and run a column profile to determine the data source column characteristics, such as a list of values, data patterns, and value ranges. Create a column profile, and extrapolate the profile results to generate test data.
Select the columns on which you want to run a profile and configure data sampling options when you create a column profile.
After you configure and run a column profile, TDM analyzes column data and infers rules based on the data. You can view the profile results for the columns. You can manually assign the inferred rules to the columns in the profile results or apply the inferred rules that TDM provides.
You can run column profiles on Oracle and Microsoft SQL Server databases.