You need to configure an

intelligent structure model

that analyzes unstructured data and discovers its structure.

The following image shows the log file that you want to parse:

Create the

intelligent structure model

in Informatica Cloud. The following image shows the

intelligent structure model

details:

To parse the log file, use a Structure Parser transformation in a mapping to transform the data in the log file.

In the Mapping Designer, you add a source object that is flat file that contains the path to the log file you want to parse.

The following image shows the selected source file properties:

You add a Structure Parser transformation. Configure it to use the

intelligent structure model

that you configured. Select the relational output type.

You connect the source object to the Structure Parser transformation. To map the incoming data to the fields of the transformation, select the Structure Parser transformation. In the

Field Mapping

tab, map

Path

to the Structure Parser Input Fields

Field Path

.

The following image shows the field mapping:

Add a text file target transformation for the parsed output group that you want to process named TargetFile. Add a separate text file target transformation for data that was not identified named Unidentified.

The following image shows the mapping:

Run the mapping to write the data in a structured format to the TargetFile transformation. The mapping sends any data that was not identified by the intelligent structure to the Unidentified transformation.

The following image shows the parsed data output file from the TargetFile transformation:

If you need to further parse the data, you can include additional Structure Parser transformations midstream that will parse the output from the preceding parser.