To successfully preview data from a local complex file or run a mapping in the native environment with a local complex file, you must configure the INFA_PARSER_HOME property for the Data Integration Service in Informatica Administrator. Perform the following steps to configure the INFA_PARSER_HOME property:
Log in to Informatica Administrator.
Click the Data Integration Service and then click the
tab on the right pane.
to add an environment variable.
Enter the name of the environment variable as
Set the value of the environment variable to the absolute path of the Hadoop distribution directory on the machine that runs the Data Integration Service. Verify that the version of the Hadoop distribution directory that you define in the INFA_PARSER_HOME property is the same as the version you defined in the cluster configuration.
Verify that a Databricks connection is created in the domain. If you want to read NULL values from or write NULL values to an Azure source, configure the following advanced properties in the Databricks connection:
Configure Azure Blob Storage Access in Azure Databricks Cluster
Verify that a cluster configuration is created in the domain. You need to set your Azure Blob Storage account name and account key under
in your Databricks cluster configuration to access the Azure Blob Storage. Add "spark.hadoop" as a prefix to the Hadoop configuration key as shown in the following text: