Informatica · Mappings in advanced mode (Source transformation)

The file or partition directory is not valid

Short answer

This Informatica parsing error in an advanced mode mapping means the JSON source file has a top-level array of primitives without a field name. Wrap the top-level array in a struct element before reading the file in the Source transformation, for example {"numbers":[10,20,30,40,50,0]}.

VerifiedLast verified

01Error text

Informatica error
The file or partition directory [<path>/<JSON file>] is not valid.
[Unexpected character 1 at 1]

02Likely causes

  • The JSON file has an array of primitives without a field name, for example [10,20,30,40,50,0].

03How to fix it

  1. Wrap the top-level array in a struct element before reading the file in the Source transformation, for example {"numbers":[10,20,30,40,50,0]}.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Informatica work:Open Informatica jobsInformatica rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.