Running a Column Profile on JSON and XML Data Sources

Back Next

Running a Column Profile on JSON or XML Data Sources

After you create a flat file data object or complex file data object with JSON or XML data sources, you can create a column profile on the data object.

In the Object Explorer view, select the physical data object for the JSON or XML file.

Click

File

New

Profile

The

New

dialog box appears.

Select

Profile

. Click

The

New Profile

dialog appears.

In the

New Profile

dialog box, add a name for the profile and an optional description.

Select

Process Extended File Formats (XML/JSON)

option. Click

The following image displays the

New Profile

wizard with the

Process Extended File Formats (XML/JSON)

option:

Process Extended File Formats (XML/JSON). Select this option to process data sources in JSON or XML format.

In the

Single Data Object Profile

page, select the columns and options under

Column Selection

and

Data Domain Discovery

as required. Click

Finish

When the Developer server is in Linux and the physical data object is a flat file data object with a text file, then you must:

Update the

Precision

value in the

Overview

tab to include the number of characters in the file path of the data source in the server.

Update the file path of the data source to the location in the server after you create a profile on the flat file data object. To update the file path, click

Runtime: Read

Source file directory

in the

Advanced

tab, and add the file path.

Right-click the profile, and select

Run Profile

The profile results appear.

Column Profile

Download Guide

Watch

Comments