|
|
Line 323: |
Line 323: |
| ==SetDataAggregation== | | ==SetDataAggregation== |
| '''Optional'''. This function enables/disables all forms of aggregation and value gathering. Any statistic that cannot be determined incrementally (for example, median, population standard deviation, etc.) is determined via aggregation. This analysis is also responsible for all value tables (Frequency, Pattern, SoundEx, etc.). All iterators and data aggregation statistics are dependent on this analysis. This increase profiling time by over 90%. These statistics are usually useful enough to justify the increased profiling time. | | '''Optional'''. This function enables/disables all forms of aggregation and value gathering. Any statistic that cannot be determined incrementally (for example, median, population standard deviation, etc.) is determined via aggregation. This analysis is also responsible for all value tables (Frequency, Pattern, SoundEx, etc.). All iterators and data aggregation statistics are dependent on this analysis. This increase profiling time by over 90%. These statistics are usually useful enough to justify the increased profiling time. |
|
| |
| The default value is "true." A "false" value will disable this function and by dependency disable all iterators and data aggregation statistics. This property should be set before '''[[#InitializeDataFiles|InitializeDataFiles]]''' is called.
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=DataAggregationVale
| |
| |Data Type=Int
| |
| |Description=0-False, 1-True. This Sets the aggregation on or off.
| |
| }}
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetDataAggregation(int);
| |
| |C=mdProfilerSetDataAggregation(profiler, dataAggregationValue);
| |
| |.Net=profiler.SetDataAggregation(dataAggregationValue);
| |
| }}
| |
|
| |
| ==InitializeDataFiles==
| |
| This function opens the required data files and prepares the profiler for use. You ''must'' call the '''[[#SetLicenseString|SetLicenseString]]''' function if you don’t have the MD_LICENSE environmental variable set prior to calling '''InitializeDataFiles'''.
| |
|
| |
| If the '''InitializeDataFiles''' function returns a code other than zero, you can call the '''[[#GetInitializeErrorString|GetInitializeErrorString]]''' function to display a string describing the error.
| |
|
| |
| ===Required Functions===
| |
| You must successfully call '''[[#SetPathToProfilerDataFiles|SetPathToProfilerDataFiles]]''' and '''[[#SetFileName functions|SetFileName functions]]'''.
| |
|
| |
| The '''InitializeDataFiles''' function returns a value of the enumerated type '''ProgramStatus'''.
| |
|
| |
|
| |
| {|class="alternate01" cellspacing="0"
| |
| !Value
| |
| !Name
| |
| !Description
| |
| |-
| |
| |0
| |
| |ErrorNone
| |
| |No error - initialization was successful.
| |
| |-
| |
| |1
| |
| |ErrorConfigFile
| |
| |Error in Configuration file
| |
| |-
| |
| |2
| |
| |ErrorDatabaseExpired
| |
| |Database file expired
| |
| |-
| |
| |3
| |
| |ErrorLicenseExpired
| |
| |License expired.
| |
| |-
| |
| |4
| |
| |ErrorProfileFile
| |
| |Error in Profile file
| |
| |-
| |
| |5
| |
| |ErrorUnknown
| |
| |Unknown error.
| |
| |}
| |
|
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->InitializeDataFiles();
| |
| |C=ProgramStatus = mdProfilerInitializeDataFiles(profiler);
| |
| |.Net=ProgramStatus = profiler.InitializeDataFiles();
| |
| }}
| |
|
| |
| ==GetInitializeErrorString==
| |
| This function returns a descriptive string to describe an error from the '''[[#InitializeDataFiles|InitializeDataFiles]]''' function. This can be used to output a message to the user.
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->InitializeErrorString();
| |
| |C=string = mdProfilerGetInitializeErrorString(profiler);
| |
| |.Net=string = profiler.InitializeDataFiles();
| |
| }}
| |
|
| |
|
| |
| [[Category:Profiler Object]]
| |
|
| |
| [[Profiler Object:Reference|← Profiler Object Reference]]
| |
|
| |
| {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
| |
| ! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Object Interface Navigation'''
| |
| |-
| |
| | style="padding-right:220px;"|
| |
| |-
| |
| |[[Profiler Object:Initialization|Initialization]]
| |
| |-
| |
| |[[Profiler Object:Object Information|Object Information]]
| |
| |-
| |
| |[[Profiler Object:Enumeration Listing and Parsing|Enumeration Listing and Parsing]]
| |
| |-
| |
| |[[Profiler Object:Column Specification|Column Specification]]
| |
| |-
| |
| |[[Profiler Object:Initiate Profiling|Initiate Profiling]]
| |
| |-
| |
| |[[Profiler Object:Data Input|Data Input]]
| |
| |-
| |
| |[[Profiler Object:Profiling|Profiling]]
| |
| |-
| |
| |[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
| |
| |-
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black; text-align:left;"|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based String Statistics|Column-Based String Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Numeric Statistics|Column-Based Numeric Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Date/Time Statistics|Column-Based Date/Time Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Name Statistics|Column-Based Name Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based State/Province Statistics|Column-Based State/Province Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Zip/Postal Code Statistics|Column-Based Zip/Postal Code Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Country Statistics|Column-Based Country Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Email Statistics|Column-Based Email Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Phone Statistics|Column-Based Phone Statistics]]
| |
| |-
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black; text-align:left;"|[[Profiler Object:Iterators|Iterators]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Frequency Table Iteration|Column-Based Value Frequency Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Length Frequency Table Iteration|Column-Based Value Length Frequency Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Pattern Table Iteration|Column-Based Value Pattern Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Date/Time Table Iteration|Column-Based Value Date/Time Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value SoundEx Table Iteration|Column-Based Value SoundEx Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Word Table Iteration|Column-Based Word Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Word Length Table Iteration|Column-Based Word Length Table Iteration]]
| |
| |-
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black; text-align:left;"|[[Profiler Object:Result Codes|Result Codes]]
| |
| |-
| |
| |[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]]
| |
| |-
| |
| |[[Result Codes]]
| |
| |}
| |
| |}
| |
|
| |
|
| |
| <div class="toclimit-2">{{CustomTOC}}</div>
| |
|
| |
| The following functions set the paths to the necessary data files, the license, and initialize the Profiler Interface:
| |
|
| |
| ==SetLicenseString==
| |
| This function sets the license string required to enable Profiler Object’s complete functionality.
| |
|
| |
| The License String is a software key that unlocks the full functionality of the component. Without the License String, the object will only function in DEMO mode
| |
|
| |
| The license string is normally set using an environment variable, either MD_LICENSE or MD_LICENSE_DEMO. Calling '''SetLicenseString''' is an alternative method for setting the license string, but applications developed for a production environment should only use the environment variable. When using an environment variable, it is not necessary to call the '''SetLicenseString''' function. For more information on setting the environment variable, see [[Profiler Object:Licensing|Licensing]].
| |
|
| |
| This function accepts one parameter.
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=LicenseString
| |
| |Data Type=String
| |
| |Description=A string value representing the software license key.
| |
| }}
| |
| ===Return Value===
| |
| The '''SetLicenseString''' function returns value of 0 or 1. A value of 0 means that the provided License String is incorrect.
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetLicenseString(StringValue);
| |
| |C=integer = mdProfilerSetLicenseString(profiler, LicenseString);
| |
| |.Net=integer = profiler.SetLicenseString(LicenseString);
| |
| }}
| |
|
| |
| ==SetPathToProfilerDataFiles==
| |
| This function sets the the path to the data files required for profiling.
| |
|
| |
| The required data files are
| |
| *mdProfiler.dat
| |
| *mdProfiler.mc
| |
|
| |
| This function accepts one Parameter.
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=LocationString
| |
| |Data Type=String
| |
| |Description=A string value representing the location of the Profiler data files.
| |
| }}
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetPathToProfilerDataFiles(StringValue);
| |
| |C=mdProfilerSetPathToProfilerDataFiles (profiler, LocationString);
| |
| |.Net=profiler.SetPathToProfilerDataFiles(LocationString);
| |
| }}
| |
|
| |
| ==SetFileName==
| |
| '''Optional'''. This function sets the path/file name of profiling output file. The processing results will be stored in the output file.
| |
|
| |
| This function accepts one parameter
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=FileNameString
| |
| |Data Type=String
| |
| |Description=A string value representing the name of the file.
| |
| }}
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetFileName(StringValue);
| |
| |C=mdProfilerSetFileName(profiler, FileNameString);
| |
| |.Net=profiler.SetFileName(FileNameString);
| |
| }}
| |
|
| |
| ==SetAppendMode==
| |
| '''Optional'''. This function sets the mode for how the output file needs to be handled. The default is overwrite mode if this function is not called.
| |
|
| |
| If a Profiler file is opened in append mode certain statistics will not be accurate, as some results cannot be carried over from run to run. Specifically: TableExactMatch, TableContactMatch, TableHouseholdMatch,TableAddressMatch, ColumnInferredDataType, ColumnSortation, and ColumnSortationPercent.
| |
|
| |
| If you intend to open the file in Append mode, you will want to call '''[[#SetSortAnalysis|SetSortAnalysis]]''', '''[[#SetMatchUpAnalysis|SetMatchUpAnalysis]]''' and '''[[#SetRightFielderAnalysis|SetRightFielderAnalysis]]''' appropriately.
| |
|
| |
| The '''SetAppendMode''' function takes a value of the enumerated type '''AppendMode'''.
| |
|
| |
| {|class="alternate01" cellspacing="0"
| |
| !Value
| |
| !Name
| |
| !Description
| |
| |-
| |
| |0
| |
| |Append
| |
| |Add new profiling information to any existing information.
| |
| |-
| |
| |1
| |
| |Report
| |
| |Open the profile table so that reporting may be done. No new records can be appended to the profile run.
| |
| |-
| |
| |2
| |
| |Overwrite
| |
| |Overwrite existing output profile table.
| |
| |-
| |
| |3
| |
| |MustNotExist
| |
| |Output profile table must not exist.
| |
| |}
| |
|
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=appendMode
| |
| |Data Type=AppedMode
| |
| |Description=This sets the append mode for the output file.
| |
| }}
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetAppendMode(AppendModeValue);
| |
| |C=mdProfilerSetAppendMode (profiler, appendMode);
| |
| |.Net=profiler.SetAppendMode(appendMode);
| |
| }}
| |
|
| |
| ==SetUserName==
| |
| '''Optional'''. This function sets the user name for a particular run.
| |
|
| |
| This function accepts one parameter.
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=UserNameString
| |
| |Data Type=String
| |
| |Description=A string value representing the user name.
| |
| }}
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetUserName(userNameString);
| |
| |C=mdProfilerSetUserName (profiler, UserNameString);
| |
| |.Net=profiler.SetUserName(userNameString);
| |
| }}
| |
|
| |
| ==SetTableName==
| |
| This function sets the name of the table.
| |
|
| |
| This function accepts one parameter
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=TableNameString
| |
| |Data Type=String
| |
| |Description=A string value representing the table name.
| |
| }}
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetTableName(tableNameString);
| |
| |C=mdProfilerSetTableName(profiler, TableNameString);
| |
| |.Net=profiler.SetTableName(TableNameString);
| |
| }}
| |
|
| |
| ==SetJobName==
| |
| '''Optional'''. This function sets the job name for a particular run.
| |
|
| |
| This fuction accepts one parameter
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=JobNameString
| |
| |Data Type=String
| |
| |Description=A string value representing the Job name.
| |
| }}
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetJobName(jobNameString);
| |
| |C=mdProfilerSetJobName (profiler, JobNameString);
| |
| |.Net=profiler.SetJobName(JobNameString);
| |
| }}
| |
|
| |
| ==SetJobDescription==
| |
| '''Optional'''. This function sets the job description for a particular run.
| |
|
| |
| This function accepts one parameter.
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=JobDesciptionString
| |
| |Data Type=String
| |
| |Description=A string value representing the job description.
| |
| }}
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetJobDescription(jobDescriptionString);
| |
| |C=mdProfilerSetJobDescription (profiler, JobDesciptionString);
| |
| |.Net=profiler.SetJobDescription(JobDesciptionString);
| |
| }}
| |
|
| |
| ==SetSortAnalysis==
| |
| '''Optional'''. This function enables/disables the sortation analysis, which can increase '''[[Profiler Object:Data Input#AddRecord|AddRecord]]''' profiling time. This time penalty grows geometrically as more records are added. If you are not interested in this statistic, disable it to decrease your profiling time.
| |
|
| |
| The default value is "true." A "false" value will disable this function. This property should be set before '''[[#InitializeDataFiles|InitializeDataFiles]]''' is called.
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=SortAnalysisValue
| |
| |Data Type=Int
| |
| |Description=0-False, 1-True. This Sets the analysis on or off.
| |
| }}
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetSortAnalysis(int);
| |
| |C=mdProfilerSetSortAnalysis(profiler, SortAnalysisValue);
| |
| |.Net=profiler.SetJobSortAnalysis(SortAnalysisValue);
| |
| }}
| |
|
| |
| ==SetMatchUpAnalysis==
| |
| '''Optional'''. This function enables/disables duplicate record detection. Duplicate analysis increases the '''[[Profiler Object:Data Input#AddRecord|AddRecord]]''' profiling time by under 5% and '''[[Profiler Object:Profiling#ProfileData|ProfileData]]''' profiling time by about 30%. These time increases often outweigh the usefulness of having these statistics.
| |
|
| |
| The default value is "true." A "false" value will disable this function. This property should be set before '''[[#InitializeDataFiles|InitializeDataFiles]]''' is called.
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=MatchUpAnalysisValue
| |
| |Data Type=Int
| |
| |Description=0-False, 1-True. This Sets the analysis on or off.
| |
| }}
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetMatchUpAnalysis(int);
| |
| |C=mdProfilerSetMatchUpAnalysis(profiler, MatchUpAnalysisValue);
| |
| |.Net=profiler.SetMatchUpAnalysis(MatchUpAnalysisValue);
| |
| }}
| |
|
| |
| ==SetRightFielderAnalysis==
| |
| '''Optional'''. This function enables/disables inferred data type analysis. This analysis is responsible for the '''Inconsistent Data''' and '''Inferred Data Type''' statistics. This increases the '''[[Profiler Object:Data Input#AddRecord|AddRecord]]''' profiling time by under 10%. It is usually good to keep these useful analysis, even with the increased profiling time.
| |
|
| |
| The default value is "true." A "false" value will disable this function. This property should be set before '''[[#InitializeDataFiles|InitializeDataFiles]]''' is called.
| |
|
| |
| ===Parameters===
| |
| {{Object Parameters
| |
| |Name=RightFielderAnalysisValue
| |
| |Data Type=Int
| |
| |Description=0-False, 1-True. This Sets the analysis on or Off
| |
| }}
| |
|
| |
| {{ Object Syntax
| |
| |Syntax=profiler->SetRightFielderAnalysis(int);
| |
| |C=mdProfilerSetRightFielderAnalysis(profiler, RightFielderAnalysisValue);
| |
| |.Net=profiler.SetRightFielderAnalysis(RightFielderAnalysisValue);
| |
| }}
| |
|
| |
| ==SetDataAggregation==
| |
| '''Optional'''. This function enables/disables all forms of aggregation and value gathering. Any statistic that cannot be determined incrementally (for example, median, population standard deviation, etc.) is determined via aggregation. This analysis is also responsible for all value tables (Frequency, Pattern, SoundEx, etc.). All iterators and data aggregation statistics are dependent on these analysis. This increase profiling time by over 90%. These statistics are usually useful enough to justify the increased profiling time.
| |
|
| |
|
| The default value is "true." A "false" value will disable this function and by dependency disable all iterators and data aggregation statistics. This property should be set before '''[[#InitializeDataFiles|InitializeDataFiles]]''' is called. | | The default value is "true." A "false" value will disable this function and by dependency disable all iterators and data aggregation statistics. This property should be set before '''[[#InitializeDataFiles|InitializeDataFiles]]''' is called. |
← Profiler Object Reference
The following functions set the paths to the necessary data files, the license, and initialize the Profiler Interface:
SetLicenseString
This function sets the license string required to enable Profiler Object’s complete functionality.
The License String is a software key that unlocks the full functionality of the component. Without the License String, the object will only function in DEMO mode
The license string is normally set using an environment variable, either MD_LICENSE or MD_LICENSE_DEMO. Calling SetLicenseString is an alternative method for setting the license string, but applications developed for a production environment should only use the environment variable. When using an environment variable, it is not necessary to call the SetLicenseString function. For more information on setting the environment variable, see Licensing.
This function accepts one parameter.
Parameters
Name
|
Data Type
|
Description
|
LicenseString
|
String
|
A string value representing the software license key.
|
Return Value
The SetLicenseString function returns value of 0 or 1. A value of 0 means that the provided License String is incorrect.
Syntax
|
profiler->SetLicenseString(StringValue);
|
C
|
integer = mdProfilerSetLicenseString(profiler, LicenseString);
|
.Net
|
integer = profiler.SetLicenseString(LicenseString);
|
SetPathToProfilerDataFiles
This function sets the the path to the data files required for profiling.
The required data files are
- mdProfiler.dat
- mdProfiler.mc
This function accepts one Parameter.
Parameters
Name
|
Data Type
|
Description
|
LocationString
|
String
|
A string value representing the location of the Profiler data files.
|
Syntax
|
profiler->SetPathToProfilerDataFiles(StringValue);
|
C
|
mdProfilerSetPathToProfilerDataFiles (profiler, LocationString);
|
.Net
|
profiler.SetPathToProfilerDataFiles(LocationString);
|
SetFileName
Optional. This function sets the path/file name of profiling output file. The processing results will be stored in the output file.
This function accepts one parameter
Parameters
Name
|
Data Type
|
Description
|
FileNameString
|
String
|
A string value representing the name of the file.
|
Syntax
|
profiler->SetFileName(StringValue);
|
C
|
mdProfilerSetFileName(profiler, FileNameString);
|
.Net
|
profiler.SetFileName(FileNameString);
|
SetAppendMode
Optional. This function sets the mode for how the output file needs to be handled. The default is overwrite mode if this function is not called.
If a Profiler file is opened in append mode certain statistics will not be accurate, as some results cannot be carried over from run to run. Specifically: TableExactMatch, TableContactMatch, TableHouseholdMatch,TableAddressMatch, ColumnInferredDataType, ColumnSortation, and ColumnSortationPercent.
If you intend to open the file in Append mode, you will want to call SetSortAnalysis, SetMatchUpAnalysis and SetRightFielderAnalysis appropriately.
The SetAppendMode function takes a value of the enumerated type AppendMode.
Value
|
Name
|
Description
|
0
|
Append
|
Add new profiling information to any existing information.
|
1
|
Report
|
Open the profile table so that reporting may be done. No new records can be appended to the profile run.
|
2
|
Overwrite
|
Overwrite existing output profile table.
|
3
|
MustNotExist
|
Output profile table must not exist.
|
Parameters
Name
|
Data Type
|
Description
|
appendMode
|
AppedMode
|
This sets the append mode for the output file.
|
Syntax
|
profiler->SetAppendMode(AppendModeValue);
|
C
|
mdProfilerSetAppendMode (profiler, appendMode);
|
.Net
|
profiler.SetAppendMode(appendMode);
|
SetUserName
Optional. This function sets the user name for a particular run.
This function accepts one parameter.
Parameters
Name
|
Data Type
|
Description
|
UserNameString
|
String
|
A string value representing the user name.
|
Syntax
|
profiler->SetUserName(userNameString);
|
C
|
mdProfilerSetUserName (profiler, UserNameString);
|
.Net
|
profiler.SetUserName(userNameString);
|
SetTableName
This function sets the name of the table.
This function accepts one parameter
Parameters
Name
|
Data Type
|
Description
|
TableNameString
|
String
|
A string value representing the table name.
|
Syntax
|
profiler->SetTableName(tableNameString);
|
C
|
mdProfilerSetTableName(profiler, TableNameString);
|
.Net
|
profiler.SetTableName(TableNameString);
|
SetJobName
Optional. This function sets the job name for a particular run.
This fuction accepts one parameter
Parameters
Name
|
Data Type
|
Description
|
JobNameString
|
String
|
A string value representing the Job name.
|
Syntax
|
profiler->SetJobName(jobNameString);
|
C
|
mdProfilerSetJobName (profiler, JobNameString);
|
.Net
|
profiler.SetJobName(JobNameString);
|
SetJobDescription
Optional. This function sets the job description for a particular run.
This function accepts one parameter.
Parameters
Name
|
Data Type
|
Description
|
JobDesciptionString
|
String
|
A string value representing the job description.
|
Syntax
|
profiler->SetJobDescription(jobDescriptionString);
|
C
|
mdProfilerSetJobDescription (profiler, JobDesciptionString);
|
.Net
|
profiler.SetJobDescription(JobDesciptionString);
|
SetSortAnalysis
Optional. This function enables/disables the sortation analysis, which can increase AddRecord profiling time. This time penalty grows geometrically as more records are added. If you are not interested in this statistic, disable it to decrease your profiling time.
The default value is "true." A "false" value will disable this function. This property should be set before InitializeDataFiles is called.
Parameters
Name
|
Data Type
|
Description
|
SortAnalysisValue
|
Int
|
0-False, 1-True. This Sets the analysis on or off.
|
Syntax
|
profiler->SetSortAnalysis(int);
|
C
|
mdProfilerSetSortAnalysis(profiler, SortAnalysisValue);
|
.Net
|
profiler.SetJobSortAnalysis(SortAnalysisValue);
|
SetMatchUpAnalysis
Optional. This function enables/disables duplicate record detection. Duplicate analysis increases the AddRecord profiling time by under 5% and ProfileData profiling time by about 30%. These time increases often outweigh the usefulness of having these statistics.
The default value is "true." A "false" value will disable this function. This property should be set before InitializeDataFiles is called.
Parameters
Name
|
Data Type
|
Description
|
MatchUpAnalysisValue
|
Int
|
0-False, 1-True. This Sets the analysis on or off.
|
Syntax
|
profiler->SetMatchUpAnalysis(int);
|
C
|
mdProfilerSetMatchUpAnalysis(profiler, MatchUpAnalysisValue);
|
.Net
|
profiler.SetMatchUpAnalysis(MatchUpAnalysisValue);
|
SetRightFielderAnalysis
Optional. This function enables/disables inferred data type analysis. This analysis is responsible for the Inconsistent Data and Inferred Data Type statistics. This increases the AddRecord profiling time by under 10%. It is usually good to keep these useful analysis, even with the increased profiling time.
The default value is "true." A "false" value will disable this function. This property should be set before InitializeDataFiles is called.
Parameters
Name
|
Data Type
|
Description
|
RightFielderAnalysisValue
|
Int
|
0-False, 1-True. This Sets the analysis on or Off
|
Syntax
|
profiler->SetRightFielderAnalysis(int);
|
C
|
mdProfilerSetRightFielderAnalysis(profiler, RightFielderAnalysisValue);
|
.Net
|
profiler.SetRightFielderAnalysis(RightFielderAnalysisValue);
|
SetDataAggregation
Optional. This function enables/disables all forms of aggregation and value gathering. Any statistic that cannot be determined incrementally (for example, median, population standard deviation, etc.) is determined via aggregation. This analysis is also responsible for all value tables (Frequency, Pattern, SoundEx, etc.). All iterators and data aggregation statistics are dependent on this analysis. This increase profiling time by over 90%. These statistics are usually useful enough to justify the increased profiling time.
The default value is "true." A "false" value will disable this function and by dependency disable all iterators and data aggregation statistics. This property should be set before InitializeDataFiles is called.
Parameters
Name
|
Data Type
|
Description
|
DataAggregationVale
|
Int
|
0-False, 1-True. This Sets the aggregation on or off.
|
Syntax
|
profiler->SetDataAggregation(int);
|
C
|
mdProfilerSetDataAggregation(profiler, dataAggregationValue);
|
.Net
|
profiler.SetDataAggregation(dataAggregationValue);
|
InitializeDataFiles
This function opens the required data files and prepares the profiler for use. You must call the SetLicenseString function if you don’t have the MD_LICENSE environmental variable set prior to calling InitializeDataFiles.
If the InitializeDataFiles function returns a code other than zero, you can call the GetInitializeErrorString function to display a string describing the error.
Required Functions
You must successfully call SetPathToProfilerDataFiles and SetFileName functions.
The InitializeDataFiles function returns a value of the enumerated type ProgramStatus.
Value
|
Name
|
Description
|
0
|
ErrorNone
|
No error - initialization was successful.
|
1
|
ErrorConfigFile
|
Error in Configuration file
|
2
|
ErrorDatabaseExpired
|
Database file expired
|
3
|
ErrorLicenseExpired
|
License expired.
|
4
|
ErrorProfileFile
|
Error in Profile file
|
5
|
ErrorUnknown
|
Unknown error.
|
Syntax
|
profiler->InitializeDataFiles();
|
C
|
ProgramStatus = mdProfilerInitializeDataFiles(profiler);
|
.Net
|
ProgramStatus = profiler.InitializeDataFiles();
|
GetInitializeErrorString
This function returns a descriptive string to describe an error from the InitializeDataFiles function. This can be used to output a message to the user.
Syntax
|
profiler->InitializeErrorString();
|
C
|
string = mdProfilerGetInitializeErrorString(profiler);
|
.Net
|
string = profiler.InitializeDataFiles();
|