Page History
- Select Manage profiling methods from the Tools menu:
...
- Right-click the required required Vendor / Version and select Copy.
...
Change
...
- the Name , Vendor and Version as required and click OK .
...
Note title Note An asterix * can be used as a wildcard for either the whole version number or the minor version number in both the Min version and max version. For
...
example , 9., and 9.0 are all valid values for Min version and Max version and match any version, any version 9 release, and only version 9.0 respectively. The method will be allowed to be used for any version between Min version and Max version (inclusive). Any User Defined Profiling methods created with a version of 3D prior to 2.4.0.0 match on the Version string returned by the RDBMS server. Leaving the version as * will allow the method to be used for any version.
...
You need to assign the new profiling method to a model version for it to be used. Leaving the version as * will allow the method to be used for any version.- The User defined methods can be edited as required—see details below.
The toolbar enables you to perform the following:Icons
Definition
...
Click to import a method from a file.
...
Click to export a method to a file.
...
Click to reset a method from last save.
...
Click to restore a method from last backup (before the last save)
...
Looking at the Profiling Method
...
for MS SQL Specifics for example; you can configure the profiling on Queries for:
- Rowcount Query
- Space used
- Inferred data type query
- General collection
- String collection
- Statistics collection
- Min/Max query
- Top 10 most frequent values query
- Top 10 least frequent values query
- In use % query
- Ref invalid % query
- Top 10 used PKs
- Top 10 unusued PKs
- Top 10 invalid FKs
...
To copy or delete a query, right-click the query as shown:
...
To add a query or copy multiple queries, right-click Queries as shown:
...
Looking again at the Profiling Method for MS SQL Specifics example; you can configure the profiling on Metrics for
- Rowcount
- Space used in MB
- Average row length
- Inferred data type
- Distinct value count
- Is unique
- Null count
- Null %
- Populated count
- Populated %
- Min value
- Max value
- Min character count
- Max character count
- Avg character count
- Max trimmed length
- Standard deviation
- Sum value
- Avg value
- Numeric range
- Top 10 most frequent values
- Top 10 least frequent values
- In use %
- Referentially invalid values %
- Top 10 used PKs
- Top 10 unused PKs
- Top 10 invalid PKs
...
To delete a metric, right-click the metric and choose Delete metric as shown:
...
To add a metric, right-click Metrics and choose Add metric as shown:
...
| Note | ||
|---|---|---|
|
...
The Rowcount |
...
metric is not actually used as a profiling metric—it enables you to customize how 3D performs a row count on each table at the start of the profiling process. You can create your own metric to do this but it MUST be |
...
named Rowcount. |