You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

  1. Select Manage profiling methods from the Tools menu:

REPLACE WITH THIS IMAGE: Images/Profiling/profilemethodmanager.png

  1. Right-click the required Vendor / Version and select Copy.

REPLACE WITH THIS IMAGE: Images/Profiling/wherescapeprofilemgr.png
Change the Name, Vendor and Version as required and click OK.
REPLACE WITH THIS IMAGE: Images/Profiling/copyvendorversion.png

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.
REPLACE WITH THIS IMAGE: Images/Profiling/copyvendorversion2.png
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.
  1. The User defined methods can be edited as required—see details below.

The toolbar enables you to perform the following:

Icons

Definition

REPLACE WITH THIS IMAGE: Images/Common_Icons/import.png

Click to import a method from a file.

REPLACE WITH THIS IMAGE: Images/Common_Icons/saveicon.png

Click to export a method to a file.

REPLACE WITH THIS IMAGE: Images/Common_Icons/undo.png

Click to reset a method from last save.

REPLACE WITH THIS IMAGE: Images/Common_Icons/restore-from-file.png

Click to restore a method from last backup (before the last save)

REPLACE WITH THIS IMAGE: Images/Profiling/profilemethodmgr5.png
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

REPLACE WITH THIS IMAGE: Images/Profiling/profilemethodmgr6.png
To copy or delete a query, right-click the query as shown:
REPLACE WITH THIS IMAGE: Images/Profiling/profilemethodmgr7.png
To add a query or copy multiple queries, right-click Queries as shown:
REPLACE WITH THIS IMAGE: Images/Profiling/profilemethodmgr8.png
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

REPLACE WITH THIS IMAGE: Images/Profiling/profilemethodmgr9.png
To delete a metric, right-click the metric and choose Delete metric as shown:
REPLACE WITH THIS IMAGE: Images/Profiling/profilemethodmgr10.png
To add a metric, right-click Metrics and choose Add metric as shown:
REPLACE WITH THIS IMAGE: Images/Profiling/profilemethodmgr11.png

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.
  • No labels