Analysis
This topic provides a detailed examination of source files, entities, and artifacts.
In This Topic:
Files
This section provides a list of all the files. Here, the files are categorized into parsed and unparsed files.
- File Name: Displays the name of the file.
- File Type: Displays the file type as Parsed if the file is parsed, otherwise it displays Unparsed.
- Automation (%): Automation refers to the extent of automated transformation possible for the given source files.
- Queries: Displays the number of queries in the source file.
- Procedures: Displays the number of procedures in the source file.
- Functions: Displays the number of functions in the source file.
Click the preferred File Name row to gain more insights into the queries, procedures, and functions present in each file.
Queries
Displays a list of queries along with the statement type and query complexity.
Procedures
Displays a list of procedures which includes details about its content such as condition, cursor, loop, and more.
Functions
Displays a list of functions in the file.
Queries
This page provides information about queries in the entire source file. Here, the queries are categorized into analyzed and not analyzed queries.
Queries
Displays all queries segregated by input type, analyzed status, statement type, complexity, and so on.
- Status: Displays the query analysis status as Analyzed or Not Analyzed.
- Analyzed: Indicates the query is analyzed.
- Not Analyzed: Indicates the query is not analyzed due to some impediments. If the query status is not analyzed, then it displays the reason for failure.
- Statement Type: Displays the statement type of the query.
- Procedure/Function Block: Displays the procedure or function block information.
- Complexity: Displays the query complexity.
Analyzed
This section displays a list of all analyzed queries. Additionally, it shows the total number of analyzed queries and the number of queries segregated by the statement type.
- Status: Displays the query analysis status as Analyzed or Not Analyzed.
- Analyzed: Indicates the query is analyzed.
- Not Analyzed: Indicates the query is not analyzed due to some impediments. If the query status is not analyzed, then it displays the reason for failure.
- Statement Type: Displays the statement type of the query.
- Procedure/Function Block: Displays the Procedure or function block information.
- Complexity: Displays the query complexity.
Not Analyzed
This section displays a list of all not analyzed queries. Additionally, it shows the total number of queries that are not analyzed, and the number of queries segregated by the statement type.
Entities
This section displays a detailed analysis for the analyzed entities comprising of used and unused tables, operations performed on the table, frequency of use, procedures, etc.
- Table Name: Name of the table.
- Data Source: Displays details of the data source.
- Frequency of Use: Displays the frequency of table used.
- Procedures: Displays the details of procedures.
- Files: Displays the file name which contains the table.
- No. of Create: Displays number of CREATE queries in the table.
- No. of Delete: Displays number of DELETE queries in the table.
- No. of Insert: Displays number of INSERT queries in the table.
- No. of Read: Displays number of READ queries in the table.
- No. of Update: Displays number of UPDATE queries in the table.
- No. of Rows: Displays number of rows in the table.
Artifacts
This section gives details about artifacts, including unparsed, missing, and additional artifacts.
- Unparsed Artifacts: Unparsed artifacts are artifacts that cannot be parsed by the engine.
- Missing Artifacts: When artifacts are absent or not recognized in a configured assessment, or a dependency cannot be recognized, they are considered missing artifacts.
- Additional Artifacts: Artifacts that do not have a reference in the input artifacts are referred to as additional artifacts.
- Artifact Name: Name of the artifact.
- Type: Provides the artifact type such as a file, table, view etc.
- Linkage: Provides the linked or associated file names.
Leaplogic