Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Profiles
  3. Part 2: Profiling with Informatica Analyst
  4. Part 3: Profiling with Informatica Developer

Profile Guide

Profile Guide

Creating a Complex File Data Object from a JSON or XML File in HDFS

Creating a Complex File Data Object from a JSON or XML File in HDFS

You can create a complex file data object from a JSON or XML source file that uses HDFS, and create a column profile on the data object.
  1. In the
    Object Explorer
    view in the Developer tool, select the project where you want to create the physical data object and column profile.
  2. Click
    File
    New
    Data Object
    .
    The
    New
    dialog box appears.
  3. Select
    Physical Data Objects
    Complex File Data Object
    , and click
    Next
    .
    The
    New Complex File Data Object
    dialog box appears.
  4. Enter a name for the data object. Select the access type as
    Connection
    .
  5. You can create a data object from a JSON or XML file or on a folder that contains multiple JSON or multiple XML files.
    • To create a complex file data object from a JSON or XML file, perform the following steps:
      1. Click
        Browse
        to select a connection.
      2. In the
        Add Resource
        dialog box, click
        Add
        to choose a JSON or XML file.
      3. Click
        Finish
        .
        The data object appears in the project folder.
    • To create a complex file data object on a folder with multiple JSON or multiple XML files, perform the following steps:
      1. Click
        Browse
        to select a connection.
      2. In the
        Add Resource
        dialog box, click
        Add
        to choose a JSON or XML file in the folder.
      3. Click
        Finish
        .
        The data object appears in the project folder.
      4. Select the data object in the project folder and click
        Advanced
        Runtime: Read
        Source file directory
        .
      5. Remove the file name and retain the folder name in the file path.

0 COMMENTS

We’d like to hear from you!