Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Data Engineering Integration
  3. Mappings
  4. Mapping Optimization
  5. Sources
  6. Targets
  7. Transformations
  8. Python Transformation
  9. Data Preview
  10. Cluster Workflows
  11. Profiles
  12. Monitoring
  13. Hierarchical Data Processing
  14. Hierarchical Data Processing Configuration
  15. Hierarchical Data Processing with Schema Changes
  16. Intelligent Structure Models
  17. Blockchain
  18. Stateful Computing
  19. Appendix A: Connections Reference
  20. Appendix B: Data Type Reference
  21. Appendix C: Function Reference

Creating a Single Data Object Profile in Informatica Developer

Creating a Single Data Object Profile in Informatica Developer

You can create a single data object profile for one or more columns in a data object and store the profile object in the Model repository.
  1. In the
    Object Explorer
    view, select the data object you want to profile.
  2. Click
    File
    New
    Profile
    to open the profile wizard.
  3. Select
    Profile
    and click
    Next
    .
  4. Enter a name for the profile and verify the project location. If required, browse to a new location.
  5. Optionally, enter a text description of the profile.
  6. Verify that the name of the data object you selected appears in the
    Data Objects
    section.
  7. Click
    Next
    .
  8. Configure the profile operations that you want to perform. You can configure the following operations:
    • Column profiling
    • Primary key discovery
    • Functional dependency discovery
    • Data domain discovery
    To enable a profile operation, select
    Enabled as part of the "Run Profile" action
    for that operation. Column profiling is enabled by default.
  9. Review the options for your profile.
    You can edit the column selection for all profile types. Review the filter and sampling options for column profiles. You can review the inference options for primary key, functional dependency, and data domain discovery. You can also review data domain selection for data domain discovery.
  10. Review the drill-down options, and edit them if necessary. By default, the
    Enable Row Drilldown
    option is selected. You can edit drill-down options for column profiles. The options also determine whether drill-down operations read from the data source or from staged data, and whether the profile stores result data from previous profile runs.
  11. In the
    Run Settings
    section, choose a validation environment. Choose
    Native
    ,
    Hadoop
    or
    Databricks
    as the validation environment. You can choose
    Native
    ,
    Blaze
    or
    Spark
    as the run-time environment. After you choose
    Blaze
    or
    Spark
    , you can select a Hadoop connection. If you choose
    Databricks
    , you can select a Databricks connection.
  12. Click
    Finish
    .

0 COMMENTS

We’d like to hear from you!