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

Exporting Profile Results from Informatica Developer

Exporting Profile Results from Informatica Developer

You can export column profile results to a .csv file or Microsoft Excel file. When you export the profile results to a Microsoft Excel file, the Developer tool saves the information to an .xlsx file.
  1. In the
    Object Explorer
    view, open a profile.
  2. Optionally, run the profile to update the profile results.
  3. Select the
    Results
    view.
  4. Select a column.
  5. Under
    Details
    , select
    Values
    ,
    Patterns
    , or
    Data types
    and click the
    Export
    icon.
    The
    Export data to a file
    dialog box opens.
  6. Accept or change the default file name.
  7. Select the type of data to export. You can select
    Values for the selected column
    ,
    Patterns for the selected column
    ,
    Data types for the selected column
    , or
    All (Summary, Values, Patterns, Data types, Statistics, Properties)
    .
  8. Click
    Browse
    to select a location and save the file locally in your computer.
  9. If you do not want to export field names as the first row, clear the
    Export field names as first row
    check box.
  10. Click
    OK
    .

0 COMMENTS

We’d like to hear from you!