Are you looking for details about what are the different types of indicators used in the Informatica Master Data Management (MDM) system? Are you also interested in knowing what are the valid values for these indicators and what those values mean? If so, then you reached the right place. In this article, we will understand different indicators such as HUB_STATE_IND, CONSOLIDATION_IND, etc and their values in detail.
Indicators in the Informatica MDM:
Informatica MDM maintains several types of indicators and those are used during internal MDM processing. The indicators maintained in the MDM system are
1. HUB_STATE_IND
2. CONSOLIDATION_IND
3. DIRTY_IND
4. DELETED_IND
5. AUTOMERGE_IND
A) HUB_STAE_IND indicator
This field present in BO, XREF tables. These indicator fields represent whether the record is in the active, deleted or pending state.
B) CONSOLIDATION_IND indicator
This filed present in the BO table. This indicator field represents whether the record is gone through the match process or not.
C) DIRTY_IND indicator
This field present in the BO table but it is no more in used. It was used for the tokenization process in the earlier release. But now instead of this field, <BO>_DRTY table is used for the tokenization process. Valid values are 1 and 0 for this field. 0 means record is ready for tokenization and 1 means record went through tokenization process.
D) DELETED_IND indicator
This field present in BO and XREF Tables. It is reserved for future purposes.
E) AUTOMERGE_IND indicator
This field present in MTCH and HMRG tables. The valid values are 0 and 1.
Indicators in the Informatica MDM:
Informatica MDM maintains several types of indicators and those are used during internal MDM processing. The indicators maintained in the MDM system are
1. HUB_STATE_IND
2. CONSOLIDATION_IND
3. DIRTY_IND
4. DELETED_IND
5. AUTOMERGE_IND
A) HUB_STAE_IND indicator
This field present in BO, XREF tables. These indicator fields represent whether the record is in the active, deleted or pending state.
Value
|
Meaning
|
1
|
Active Record
|
0
|
Pending Record
|
-1
|
Inactive Record
|
B) CONSOLIDATION_IND indicator
This filed present in the BO table. This indicator field represents whether the record is gone through the match process or not.
Value
|
Meaning
|
4
|
The new record (Unmerged record)
|
3
|
The record has gone through the match process and ready for
consolidation
|
2
|
Queued for the Merge process
|
1
|
Consolidated or Golden record
|
9
|
The record is on hold. Normally data steward keep
records on hold
|
C) DIRTY_IND indicator
This field present in the BO table but it is no more in used. It was used for the tokenization process in the earlier release. But now instead of this field, <BO>_DRTY table is used for the tokenization process. Valid values are 1 and 0 for this field. 0 means record is ready for tokenization and 1 means record went through tokenization process.
D) DELETED_IND indicator
This field present in BO and XREF Tables. It is reserved for future purposes.
E) AUTOMERGE_IND indicator
This field present in MTCH and HMRG tables. The valid values are 0 and 1.
Value
|
Meaning
|
1
|
Records are queued for auto-merge
|
0
|
Records are queued for manual merge
|