Analysis

This topic provides a detailed examination of applications, users, 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

Related Topics:

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.

Click the preferred File Name row to gain more insights into the 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 detailed analysis (LIST) for the analyzed entities based on the frequency of use and provides 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: Contributes information about All Views, Used Views, Unused Views, and Missing Views.

Tables

Encapsulates information about All Tables, Used Tables, Unused Tables, and Missing Tables.

Table Name: Name of the table.
Table Type: 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

Contributes information about All Views, Used Views, Unused Views, and Missing Views.

View Name: Name of the view.
Data Source: Displays details of the data source.
Frequency of Use: Displays the frequency of views used.
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.
Queries Executed: Number of queries that are executed.
Where: Displays number of Where clause.
Join: Displays number of Joins.

The GRAPH View of entities displays a graphical illustration of detailed entity analysis 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. Artifact types are:

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, this section categorizes the missing artifacts into files and entities that are missing.

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.

Additional Artifacts

This section provides the details of all the artifacts that appear additionally. It also categorizes the additional artifacts into files and entities that appeared additionally.

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.

Unparsed Artifacts

This section provides the details of all the artifacts that could not be parsed completely due to some error.

File Name: Name of the file on which the unparsed query is present.
Type: Type of the file.
Error on Line Number: Displays the line number that contains the error.

Queries

This page displays graphical (GRAPH) and detailed (LIST) analysis of unique and analyzed queries from the total input queries after considering the 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. If the query status is not analyzed, then it displays the reason for failure.
Execution Frequency: Provides the frequency of execution.
Complexity: Displays the query complexity.

Unique (Pattern)

This section displays a list of all 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 all 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. If the query status is not analyzed, then it displays the reason for failure.
Execution Frequency: Provides the frequency of execution.
Complexity: Displays the query complexity.

Not Analyzed

This section displays a list of all 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. If the query status is not analyzed, then it displays the reason for failure.
Execution Frequency: Provides the frequency of execution.
Failure Message: Displays the error message.

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.