Understanding Downloadable Reports

This topic provides information about some major downloadable reports for different sources.

Workload Category	Source	Report (Folder)	Report Name	Assessment Reports and Insights
DML	Teradata, Netezza, Oracle, Vertica, SQL Server	Source Inventory Analysis	Assessment Analysis Unique Pattern	Unique Pattern: Lists all queries with unique patterns. Additionally, it provides information about complexities, execution time ratios, I/O and CPU ratios, statement types, and a lot more.
DML	Teradata, Netezza, Oracle, Vertica, SQL Server	Source Inventory Analysis	Assessment Analysis Analyzed Queries	Analyzed Queries: Lists all the queries along with information about the time required to execute, I/O and CPU utilization ratios, the status of the query analysis and so on.
Procedure	Teradata, Netezza, Oracle, Vertica, SQL Server	Source Inventory Analysis	Procedure	Macros: Lists all the macros existing in the input source files. It also provides information about the total number of queries, and statement types such as SELECT, UPDATE, INSERT, DELETE, and so on. Unparsed Details: Provides details of all unparsed files. Query Count Summary: Provides the total number of queries existing in the procedural source files. It also includes the count of queries segregated by statement types such as SELECT, UPDATE, INSERT, DELETE, and so on. Complexity Summary: Provides complexity of queries existing in the procedural source files. Parsed Files: Lists all the parsed files along with the total number of functions, procedures, and queries. It also provides the count and percentage of auto-converted queries. Conversion Compatibility: Provides auto conversion details such as the count and percentage of auto-converted queries as well as the total number of queries in each file. Packages Procedures Functions: Lists all the existing packages, procedures, and functions in the input files. It also provides the total number of queries, and the number of queries segregated by statement types such as SELECT, UPDATE, INSERT, DELETE, and so on. Entities (Tables or Views): Lists all the entities in the input source files along with procedures, functions, blocks, and their usage types. Schemas: Lists all the existing schemas. SQLs: Lists all the SQL queries along with procedures, functions, blocks, complexities, complexity matrices, SQL statement types, and status of the auto conversion of queries. Package Cursor Queries: Lists all the cursor queries along with complexities, complexity matrices, SQL statement types, and status of the auto conversion of cursor queries. Functions in SQL: Lists all the functions such as sum, min, max, and so forth, implemented in the source files. It also provides information about the custom functions, and the category of functions such as aggregate functions, custom functions, arithmetic functions, and so on, as well as whether UDF is required or not. Entities for DDL: Lists all the entities such as tables and views existing in the DDL files. Summary: Provides the total number of functions and procedures.
Procedure	Teradata, Netezza, Oracle, Vertica, SQL Server	Source Inventory Analysis	procedure_macro_view_unparsed_details	procedure_macro_view_unparsed_details: Provides details about procedures, macros, and views existing in the source files along with its types.
ETL	Informatica	Source Inventory Analysis	InformaticaAssessment	Custom Summary: Lists all the custom data types. DB Summary: Provides information about the files available in the databases. It displays the count of workflows, mappings, source files, target files, and so on. Macro Summary: Lists all the user-defined functions. Mapping Summary: Describes the flow of data between source and target. It lists all the mappings and the count of associated transformations such as expression input columns, expression output columns, aggregators, filters, joiners, and so on. Source Info: Lists a detailed inventory of the Informatica source files. For instance, it provides information about the folder names, database types, and so on. SP Summary: Lists all the stage names and the associated procedures. Target Info: Lists all the target files along with the database types. Transformation Summary: Lists all the input source files along with the count of workflows, worklets, sessions, mappings, mapplets, and so forth available in the source files. Workflow DB Summary: Provides workflow-level details. It includes the count of mapping files, source files, target files, and so on.
ETL	Informatica	Source Inventory Analysis	queries	queries: Lists all the queries along with information about transformations and mappings.
ETL	Informatica	Source Inventory Analysis	assessment_unparsed_etl_files	assessment_unparsed_etl_files: Lists all ETL files that cannot be parsed.
ETL	DataStage	Source Inventory Analysis	Datastage Report	File Summary: Lists all the input files along with the total number of jobs, components, complexities, and analyzed percentage. It also provides statistical information about the transformation components such as sequencer, Lookup, aggregator, and so on. These transformation components are transformed or converted to the target platform. Job Summary: Lists all the jobs associated with the input files. It also provides information about the complexities, analyzed percentages, the total number of components, and a lot more. Job Sub Job Details: Provides details about all parent and associated child jobs along with their types. Complexity Summary: Provides details about the complexity of files.
ETL	Ab Initio	Source Inventory Analysis	AbInitio Assessment Detail Report	AbInitio Assessment Detail Report: Lists all the files along with the total number of components. It also includes statistical information about the supported and unsupported components, transform components and a lot more.
ETL	Ab Initio	Source Inventory Analysis	assessment_unparsed_etl_files	assessment_unparsed_etl_files: Lists all ETL files that cannot be parsed.
ETL	SSIS	Source Inventory Analysis	SSIS Report	File Summary: Lists all the SSIS input files. It contains the total count of executables, pipelines, components, connections, sub-packages, and so on for every SSIS package. Sub-packages: Packages within another package. It lists all the SSIS packages and the associated sub-packages. Precedence Constraints: Defines the relationship between two precedence constraints or tasks. Procedure: Lists all the procedures. Query: Lists all the SQL queries along with the information about executables, executable types, component types, and so on. Component: Data flow in the SSIS packages. It lists all the components along with the component types. SSIS furnishes three types of components for data flow. Sources: Extract the data from source data stores. Transformations: Modify the data. Destinations: Load the processed data back into data stores or store it in memory. Connection: Defines to implement integration services to move data from one place to another. It lists all the connections along with the connection manager reference ids. Event Handler: Lists all event handlers along with executables and executable types. Script Task: Lists all the external files or scripts in the SSIS packages. It includes information about the languages used in the files, project details, etc. Execute Process: Provides details about the execute process data used to run external files in SSIS packages. Executables: Lists all executables and their types. Connection Manager: Provides details about the data flow components used to implement integration services to move data from one place to another. Package Parameter: Lists all package parameters along with the package name and status.
ETL	SSIS	Source Inventory Analysis	ssis_unparsed_package_details	ssis_unparsed_package_details: Lists all SSIS packages that cannot be parsed.
ETL	Talend	Source Inventory Analysis	Talend Report	File Summary: Lists all the files existing in the Talend source files along with the associated jobs, count of queries, components, expressions, length of expressions, and a lot more. Job Summary: Lists all the jobs associated with the input files and components. It also provides information about the types of components, length of expressions, and a lot more. Connection Summary: Connections are interfaces to connect components. Lists all the connections along with information about files, jobs, meta names, source components, and target components. Context EVN Summary: Lists all the jobs and the associated environments in which the jobs are expected to run. Complexity Summary: Provides the file complexity details.
ETL	Talend	Source Inventory Analysis	assessment_unparsed_etl_files	assessment_unparsed_etl_files: Lists all ETL files that cannot be parsed.
Analytics	SAS	Source Inventory Analysis	SAS_Code_Assessment	Summary: Lists detailed inventory for every SAS file. For instance, it provides information about number of files with compilation errors, parsing errors, missing files, percentage of auto-conversion and manual conversion, common functions used and so on. Complexity Measures: Provides high-level complexity details of each SAS file. It includes information about formula used to derive the complexity, total lines of code, percentage of auto-conversion, number of lines of code which has valid code for conversion, number of macros defined, and a lot more. Discovery: Lists key metrics related to auto-converted code. It includes code parsing status, the number of non-converted code lines, compilation status, percentage of auto-conversion, and likewise. Manual Conversion: Provides more granular auto-conversion metrics such as statements like format, date, length, increment, etc., that need manual intervention. It also provides the count of statements, procs, etc. that need manual intervention in the format "ToDo Automatic Comment <Column Name>". Manual Patterns: Provides details of code blocks that need manual conversion. It includes information about the statement types which are not auto-converted, code for manual conversion, partially auto-converted code but requires minor changes, and describes actions required for manual conversion. Input and Output: Lists all the inputs existing in the SAS file along with its type such as READ, Lookup, New Dataset, etc. It also lists the outputs and its type such as a file, etc. Input Output Resolved: Lists all the inputs existing in the SAS files along with its types such as READ, Lookup, New Dataset etc. and outputs such as a file etc. It also defines the types of input and output as internal or external along with whether the input/output is resolved or not. Variable Reference: Lists all the variables existing in a source SAS file along with its values appearing in the code. It also lists the types of entities such as macro call, LET, etc. Common Functions: Lists all the common functions in the source code file along with their availability and known issues. Compilation Errors: Provides information about the compilation error in each source file. Complexity Calculation Logic: Provides complete high-level details required for complexity calculations. It includes information about the Group Statements - collection of statements and lists all the SAS base functions. It also provides the complexity range based on an established complexity calculation logic, the assessment engine calculates the complexity of SAS scripts and its components and shows it in a range format for each SAS statement type and function.
Analytics	SAS	Source Inventory Analysis	SAS-Analysis-DB	SAS-Analysis-DB: Provides information about the analyzed SAS scripts. It includes information about the complexities, the number of macros, proc SQLs, data steps, etc. for every SAS script.
Hadoop	Hive	Source Inventory Analysis	hive	Assessment Summary: Provides an overview of the assessment summary. It includes information about the total number of source files, queries, entities, and so on. File Analytics: Lists all the files along with their file and query complexity, total number of queries, and type of queries. Query Analytics: Provides details about queries including complexities, types, query analysis status, and so on. Entity Analytics: Provides details about entities including entity types, table types, frequency of use, and so on.
Hadoop	Impala	Source Inventory Analysis	impala	Assessment Summary: Provides an overview of the assessment summary. It includes information about the total number of source files, queries, entities, and so on. File Analytics: Lists all the files along with their file and query complexity, total number of queries, and type of queries. Query Analytics: Provides details about queries including complexities, types, query analysis status, and so on. Entity Analytics: Provides details about entities including entity types, table types, frequency of use, and so on.
Hadoop	MapReduce	Source Inventory Analysis	mapreduce	Code Assessment: Provides an overview of the assessment. It includes the total number of source files, lines of codes, size on disk, and more.
Hadoop	Spark	Source Inventory Analysis	sparkcode	Code Assessment: Provides an overview of the spark code assessment. It includes the total number of source files, lines of codes, size on disk, and more.
Hadoop	SparkSQL	Source Inventory Analysis	sparksql	Assessment Summary: Provides an overview of the assessment summary. It includes information about the total number of source files, queries, entities, and so on. File Analytics: Lists all the files along with their file and query complexity, total number of queries, and type of queries. Query Analytics: Provides details about queries including complexities, types, query analysis status, and so on. Entity Analytics: Provides details about entities including entity types, table types, frequency of use, and so on.