Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.2
  3. Part 2: Version 10.1.1
  4. Part 3: Version 10.1
  5. Part 4: Version 10.0
  6. Part 5: Version 9.6.1
  7. Part 6: Version 9.6.0

Profiles

Profiles

This section describes new Developer tool features for profiles and profile results.

Columns Profiles with JSON and XML Data Sources

Effective in version 10.0, you can use the following methods to create a column profile with JSON and XML data sources:
  • Flat File. In this method, you need to create a text file, and add the JSON or XML file source location into the file. Create a flat file data object with the text file. Create a column profile on the flat file data object.
  • Complex file reader. In this method, you create a complex file data object on the JSON or XML source file, and create a column profile with the complex file data object.
  • JSON or XML file in HDFS. In this method, you need to create a connection with HDFS, and create a complex file data object on the JSON or XML file in HDFS. You can create a column profile with the complex file data object.
  • JSON or XML files in a folder. In this method, you need to consolidate all the JSON or XML files into a folder. Create a connection with HDFS, and create a complex file data object with the folder. You can create a column profile on the complex file data object.
For more information about column profiles with JSON and XML data sources, see the "Data Object Profiles" chapter in the
Informatica 10.0 Data Discovery Guide
.

Decimal Data Type

Effective in version 10.0, you can create profiles with columns that have the Decimal data type with a precision of up to 38 digits.
For more information, see the
Informatica 10.0 Data Discovery Guide
.

Foreign Key Curation

Effective in version 10.0, when you reject an inferred column relationship, all the associated relationships are also rejected.
For more information about curation, see the "Enterprise Discovery Results" chapter in the
Informatica 10.0 Data Discovery Guide
.

JDBC Connectivity

Effective in version 10.0, you can specify a JDBC connection as a profiling warehouse connection for IBM DB2 UDB, Microsoft SQL Server, and Oracle database types. You can create column profiles, rule profiles, domain discovery, and scorecards with a JDBC connection.
For more information, see the
Informatica 10.0 Installation and Configuration Guide
.

Object Versioning

Effective in version 10.0, when the Model repository is integrated with a version control system, the version control system protects objects from being overwritten by other members of the development team. You can check profiles out and in, undo the checkout of profiles, and view and restore historical versions of profiles.
For more information about object versioning, see the "Informatica Developer Profiles" chapter in the
Informatica 10.0 Data Discovery Guide
.


Updated September 25, 2020