Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Data Engineering Integration
  3. Mappings
  4. Mapping Optimization
  5. Sources
  6. Targets
  7. Transformations
  8. Python Transformation
  9. Data Preview
  10. Cluster Workflows
  11. Profiles
  12. Monitoring
  13. Hierarchical Data Processing
  14. Hierarchical Data Processing Configuration
  15. Hierarchical Data Processing with Schema Changes
  16. Intelligent Structure Models
  17. Blockchain
  18. Stateful Computing
  19. Appendix A: Connections Reference
  20. Appendix B: Data Type Reference
  21. Appendix C: Function Reference

Analysis Spreadsheet

Analysis Spreadsheet

When you analyze a group of mappings, the analysis produces a report that you can open as a spreadsheet. The report contains detailed information about the mappings that you analyzed.
The spreadsheet contains the following information:
  • Mapping. Mapping path and name.
  • Transformation list. In the Transformations column, you can view a list of the transformations in the mapping.
    For example, the following list shows that the mapping contains a Sorter transformation, two Expression transformations, a Union transformation, and so on:
    {SorterTx:1,ExpressionTx:2,UnionTx:1,FilterTx:1,SourceTx_com.informatica.adapter.hdfs:2,TargetTx_com.informatica.adapter.hdfs:1}
    Note that each entry includes the adapter type for Source and Target transformations. In this example, you can see that the two Source transformations and one Target transformations all used the HDFS adapter to connect to resources.
  • Run-time engine. The last five columns show which run-time engines are configured for each mapping.
By viewing this information organized as a table, you might recognize similarities in mappings and opportunities for improvement.
The image below shows the entire spreadsheet, using Excel as a viewer, and highlighting the example given above.
The image shows data in a spreadsheet format, with columnS showing the path and name of each mapping, a list of transformations in each mapping, and which run-time engines are configured for the mapping.

Accessing the Analysis Spreadsheet

The Developer tool creates the spreadsheet as a text file in the following location:
<Developer tool home>/Clients/DeveloperClient/workspace/
You can use Excel or another tool to open the file and display its information in columns. Columns are delimited using the pipe (|) symbol.


Updated September 28, 2020