Deduplicate assets

Back Next

Mandatory, required, and optional fields

Each objective on the

Deduplication

tab specifies a set of fields that the deduplication process can analyze at run time. To get the best results from the deduplication operation, provide input data for every mandatory field that the objective specifies and provide data for at least one required field. You can also provide data for the other fields that the objective specifies. The tables in this appendix list the sets of mandatory, required, and optional fields that appear by default for each objective.

The mandatory and required fields can vary according to the index key that you select for the objective. The current index key on any objective is always a current mandatory field. For example, the deduplicate asset specifies Organization Name as a single index key option for the CC Issuer objective, which means that Organization Name is mandatory in all cases for CC Issuer.

The following tables list the default sets of mandatory, required, and optional fields on each objective:

Address

Field	Field Type
Address Part1	Mandatory
Address Part2	Optional
Postal Area	Optional
Telephone Number	Optional
ID	Optional
Date	Optional
Attribute1	Optional
Attribute2	Optional
Geocode	Optional
Code	Optional

Author ISBN

Field	Field Type
Person Name	Mandatory
ISBN10	Required, unless you specify ISBN13
ISBN13	Required, unless you specify ISBN10
Email	Optional

CC Issuer

Because Organization Name is the single index key option on the CC Issuer objective, Organization Name becomes a mandatory key in addition to CreditCard.

Field	Field Type
CreditCard	Mandatory
Organization Name	Required

CC Owner

Field	Field Type
Person Name	Mandatory
CreditCard	Mandatory
Telephone Number	Optional
Address Part1	Optional
Address Part2	Optional
Postal Area	Optional
Date	Optional
Geocode	Optional
Email	Optional

Contact

Field	Field type
Person Name	Mandatory
Address Part1	Mandatory
Organization Name	Required, unless you specify Company Name
Company Name	Required, unless you specify Organization Name
Address Part2	Optional
Postal Area	Optional
Telephone Number	Optional
ID	Optional
Date	Optional
Attribute1	Optional
Attribute2	Optional
Geocode	Optional
Code	Optional
Email	Optional

Corp Entity

Because Organization Name is the single required field on the Corp Entity objective, Organization Name becomes a mandatory field.

Field	Field type
Organization Name	Required
Address Part1	Optional
Address Part2	Optional
Postal Area	Optional

Division

Field	Field type
Address Part1	Mandatory
Organization Name	Required, unless you specify Company Name
Company Name	Required, unless you specify Organization Name
Address Part2	Optional
Postal Area	Optional
Telephone Number	Optional
ID	Optional
Attribute1	Optional
Attribute2	Optional
Geocode	Optional
Code	Optional

Family

Field	Field type
Person Name	Mandatory
Address Part1	Mandatory
Telephone Number	Mandatory
Address Part2	Optional
Postal Area	Optional
Attribute1	Optional
Attribute2	Optional
Geocode	Optional
Code	Optional
Email	Optional

Fields

In the core field list for the Fields objective, all fields are optional. The deduplicate asset identifies the current index key as a manadatory field.

Field	Field type
Person Name	Optional
Organization Name	Optional
Company Name	Optional
Address Part1	Optional
Address Part2	Optional
Postal Area	Optional
Telephone Number	Optional
ID	Optional
Date	Optional
CreditCard	Optional
VIN	Optional
ISBN10	Optional
ISBN13	Optional
Attribute1	Optional
Attribute2	Optional
Geocode	Optional
Code	Optional
Generic Field	Optional
Email	Optional

Generic

Field	Field Type
Generic Field	Mandatory

Geocode

Field	Field Type
Geocode	Mandatory

Household

Field	Field type
Person Name	Mandatory
Address Part1	Mandatory
Address Part2	Optional
Postal Area	Optional
Telephone Number	Optional
Attribute1	Optional
Attribute2	Optional
Geocode	Optional
Code	Optional
Email	Optional

Individual

Field	Field type
Person Name	Mandatory
ID	Required, unless you specify Date
Date	Required, unless you specify ID
Attribute1	Optional
Attribute2	Optional
Code	Optional
Email	Optional

Organization

Field	Field type
Organization Name	Required, unless you specify Company Name
Company Name	Required, unless you specify Organization Name
Address Part1	Optional
Address Part2	Optional
Postal Area	Optional
Telephone Number	Optional
ID	Optional
Date	Optional
Attribute1	Optional
Attribute2	Optional
Geocode	Optional
Code	Optional

Person Name

Field	Field type
Person Name	Mandatory
Address Part1	Optional
Address Part2	Optional
Postal Area	Optional
Telephone Number	Optional
ID	Optional
Date	Optional
Attribute1	Optional
Attribute2	Optional
Geocode	Optional
Code	Optional
Email	Optional

Publisher ISBN

Field	Field Type
Organization Name	Required, unless you specify Company Name
Company Name	Required, unless you specify Organization Name
ISBN10	Required, unless you specify ISBN13
ISBN13	Required, unless you specify ISBN10
Address Part1	Optional
Address Part2	Optional
Postal Area	Optional
Geocode	Optional

Resident

Field	Field type
Person Name	Mandatory
Address Part1	Mandatory
Address Part2	Optional
Postal Area	Optional
Telephone Number	Optional
ID	Optional
Date	Optional
Attribute1	Optional
Attribute2	Optional
Geocode	Optional
Code	Optional
Email	Optional

VIN Manufacturer

Field	Field Type
VIN	Mandatory
Organization Name	Required, unless you specify Company Name
Company Name	Required, unless you specify Organization Name
Address Part1	Optional
Address Part2	Optional
Postal Area	Optional
Geocode	Optional

VIN Owner

Field	Field Type
VIN	Mandatory
Address Part1	Mandatory
Organization Name	Optional
Company Name	Optional
Person Name	Optional
Address Part2	Optional
Postal Area	Optional
Attribute1	Optional
Attribute2	Optional
Date	Optional
Geocode	Optional
Code	Optional
Email	Optional

Wide Contact

Field	Field type
Person Name	Mandatory
Organization Name	Required, unless you specify Company Name
Company Name	Required, unless you specify Organization Name
ID	Optional
Attribute1	Optional
Attribute2	Optional
Code	Optional
Email	Optional

Wide Household

Field	Field type
Address Part1	Mandatory
Telephone Number	Mandatory
Person Name	Optional
Address Part2	Optional
Postal Area	Optional
Attribute1	Optional
Attribute2	Optional
Geocode	Optional
Code	Optional
Email	Optional

Appendix A: Field types and identity objectives

Download Guide

Watch

Comments

Cloud Data Quality Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Sam Greene - April 13, 2023

I am using the individual objective and there is a field to be mapped called 'GroupKey' which is mandatory - it is not listed in this documentation and I'm not sure what it should represent.

Informatica Documentation Team - April 14, 2023

Hi Sam,

We’re working to address your comments and will get back to you.

Thanks,

Informatica Documentation team

Informatica Documentation Team - October 12, 2023

Hi Sam,

We’re happy to let you know that we addressed your feedback in the documentation. Please see the following link for information about the working of the GroupKey field: https://docs.informatica.com/integration-cloud/data-integration/current-version/transformations/deduplicate-transformation/groups-in-duplicate-analysis.html

Please also see the following link for general information on sorting data into groups for duplicate analysis: https://docs.informatica.com/data-governance-and-quality-cloud/data-quality/current-version/deduplicate-assets/introduction-to-deduplicate-assets/duplicate-analysis-operations.html

Thanks,

Informatica Documentation team

Rename Saved Search

Table of Contents

Deduplicate assets

Deduplicate assets

Mandatory, required, and optional fields

Mandatory, required, and optional fields

Address

Author ISBN

CC Issuer

CC Owner

Contact

Corp Entity

Division

Family

Fields

Generic

Geocode

Household

Individual

Organization

Person Name

Publisher ISBN

Resident

VIN Manufacturer

VIN Owner

Wide Contact

Wide Household