You can preview hierarchical data within a mapping in the Developer tool. You can choose sources and transformations as preview points in a mapping. Previewing hierarchical data helps to design and debug big data mappings.
When you preview data with hierarchical types, the Data Integration Service passes the request to the Spark engine. When you view the results, you can view the complex data types, the schema, and values. You can also navigate through the structure with breadcrumbs. You can export the results to a JSON file.
Data preview on hierarchical data is available for technical preview. Technical preview functionality is supported but is unwarranted and is not production-ready. Informatica recommends that you use in non-production environments only.
Data preview is supported for the Spark engine only. You cannot preview hierarchical data in a mapping configured for the Databricks Spark engine.