Hierarchy Parser Transformation in Mappings

To preserve the hierarchical structure when you read data from Google BigQuery and write data to relational targets, you must use a Hierarchy Parser transformation.

The transformation processes JSON input from the source transformation and provides relational output to the target transformation. The Hierarchy Parser transformation converts hierarchical input based on the sample schema of the Google BigQuery table that you associate with the transformation and the way that you map the data.

For more information on using the Hierarchy Parser transformation with Google BigQuery Connector, see the Informatica How-To Library article, "Using a Hierarchical Parser Transformation with Google BigQuery Connector": https://kb.informatica.com/h2l/HowTo%20Library/1/1077-UsingaHierarchichalParserTransformationforGoogleBigQueryConnector-H2L.pdf