Analysis
This topic provides a detailed examination of queries (by statement types and query constructs), entities, files, and more. Based on the pre-defined SLAs, cost, resource consumption, etc., the Analysis page shows a glimpse into the most eligible workloads for migration.
In this Topic:
DML Script
Files
This section provides a comprehensive report of the source files with information about the total number of files, complexity, and queries associated with each file.
- File Name: Displays the name of the file.
- Complexity: Displays the complexity of each file.
- Total Queries: Displays the number of queries in each file.
Browse through the required file in the table to gain more insights into queries present in each file. Here, the queries are categorized into unique text, used and unused queries.
- Unique Queries: Duplicate queries are eliminated, and solitary queries are identified.
- Used Queries: Queries that are used in both DML scripts and Execution logs.
- Unused Queries: Queries that are used in DML scripts but not in Execution logs.
- Schema Name: Name of the schema.
- Complexity: Provides the complexity of queries.
- Execution Frequency: Provides the frequency of execution.
Entities
This section displays graphical (GRAPH) and in-depth insights (LIST) into the analyzed entities. It includes information about all the available tables and views used in the queries. Entities are:
- Tables: Encapsulates information about All Tables, Used Tables, Unused Tables, and Missing Tables.
- Views: Provides information about views.
Tables
Encapsulates information about All Tables, Used Tables, Unused Tables, and Missing Tables.
- Table Name: Displays name of the table.
- Table Type: Displays type of the table.
- Data Source: Displays details of the data source.
- Data Volume: Displays the quantity of data.
- Materialized View: These are queries used to store data in the physical tables where you can define to update the table automatically when changes are made in the source tables or execute a command to update the tables.
- Frequency of Use: Displays the frequency of table used.
- Primary Key: To identify unique row in the table. It will not accept NULL values.
- Unique Key: To identify records in a 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.
- Primary Index: Indexes based on the primary key.
- Unique Primary Index: Contains unique values in the column of the index table.
- Index: Indexes are lookup tables that help to quickly retrieve data from the database.
- Queries Executed: Number of queries that are executed.
- Transactional: Displays the number of data flow components that are used to perform sorting, merging, data cleansing and so on.
- Where: Displays number of Where clause.
- Join: Displays number of Joins.
- Blocks: Displays number of blocks.
- Files: Displays the name of the associated file.
Views
Provides information about views.
- View Name: Name of the view.
- Number of Used Tables: Displays the number of used tables.
- Number of Used Views: Displays the number of used views.
- Database Name: Provides the name of the database.
- CHILD_VIEWS: Provides details of the child views.
- CHILD_TABLES: Provides details of the child tables.
The GRAPH view provides a visual representation of a comprehensive analysis of the entities after considering different SLAs. In this visual summary, you can see the distribution of tables, views, and entities, as well as information about Permanent, Temporary, or Intermediate table types.
Artifacts
This section gives details about artifacts including:
- 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.
- Unparsed Artifacts: Unparsed artifacts are artifacts that are unable to be parsed by the engine.
Missing Artifacts
This section provides the details of all the missing artifacts. Additionally, it categorizes them into missing files and entities.
- Artifact Name: Displays name of the artifact.
- Type: Provides the artifact type such as a file, table, view etc.
- Linkage: Provides the linked or associated file names.
Additional Artifacts
This section provides the details of all the artifacts that appear additionally. It also categorizes the additional artifacts into files and entities.
- Artifact Name: Displays name of the artifact.
- Type: Provides the artifact type such as a file, table, view etc.
- Linkage: Provides the linked or associated file names.
Unparsed Artifacts
This section provides the details of all the artifacts that could not be parsed completely due to some error.
- File Name: Displays name of the file on which the unparsed query is present.
- Type: Displays type of the file.
- Error on Line Number: Displays the line number that contains the error.
Queries
This page displays graphical (GRAPH) and in-depth insights (LIST) into the queries after considering different SLAs. Moreover, it presents details about the unique query text, unique query patterns, and analyzed and not analyzed queries.
Unique (Text)
This section displays a list of all the unique queries. Additionally, it shows the total number of unique queries, and the number of queries segregated by the statement type. In Unique (Text), the duplicate queries are eliminated, and solitary queries are identified.
- 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.
- Execution Frequency: Provides the frequency of execution.
- Complexity: Displays the query complexity.
Unique (Pattern)
This section displays a list of queries with unique patterns. Additionally, it shows the total number of unique pattern queries, and the number of queries segregated by the statement type. Unique pattern queries identify the distinct query structures, but the query structure’s values may change.
Analyzed
This section displays a list of queries that meet the analysis criteria. Additionally, it shows the total number of analyzed queries and the number of queries segregated by 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.
- Execution Frequency: Provides the frequency of execution.
- Complexity: Displays the query complexity.
Not Analyzed
This section displays a list of queries that did not meet the analysis criteria. Additionally, it shows the total number of not analyzed queries as well as the number of queries segregated by 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.
- Execution Frequency: Provides the frequency of execution.
- Complexity: Displays the query complexity.
The GRAPH section illustrates a detailed analysis of all queries. It demonstrates query distributions based on unique text, unique pattern, analyzed and non-analyzed queries, etc.
Leaplogic