Under very specific conditions and datatype usage, Informatica Data Service mapping with Joiner transformation that has a single join condition, data type as string and Non-Unicode data, could cause potential data loss. This issue is being tracked as Change Request PLAT-19257 and has been isolated to mappings that have the following characteristics:
Joiner transformations that meet ALL of the following criteria:
- Join type: Equi-Join,
- Datatype: String
- Number of conditions: Single
- Data Transferred: ASCII (dynamically determined based on connection codepages)
- Engine Type: DataIntegrationService (DIS)
- Mode: Native
Informatica Data Quality 10.0/Informatica Big Data Management Edition 10.0
Informatica Data Quality 10.1.0/Informatica Big Data Management Edition 10.1.0
Informatica Data Quality 10.1.1/Informatica Big Data Management Edition 10.1.1
Informatica Data Quality 10.1.1 HotFix 1/Informatica Big Data Management 10.1.1 Edition HotFix 1
Refer to Knowledge base (KB) article, 520801 that has more details on how to check if mappings meet the criteria.
If impacted, apply patch or Emergency Bug Fix (EBF) that is available for download from the FTP location provided below for 10.1.1 HotFix 1.
For all other versions, a workaround is available as mentioned in the KB article.
Informatica strongly recommends that customers apply the patch or workaround suggested in the KB article if they have mappings that fall into the scope defined above.
Location: updates/Informatica10/10.1.1 HotFix1/EBF-10298
Please refer to the attached document for more information.