Do Duplicates Exist In The DWH_FIN_TRANSACTION_LN Table?

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When querying the DWH schema, the following table has duplicated transaction_key in the DWH_FIN_TRANSACTION_LN 
table. Is this an issue?

Resolution

Go to Administration > General Settings > System Options > Data Warehouse Options > Languages

The DWH can accept multiple language for translations.

It is normal for the table column DWH_FIN_TRANSACTION_LN.transaction_key to appear many times as for each iteration, it would represent the language.
For example, the additional of another language, e.g. French is normal and a record specifying the language needs to exist.
English - 'en'
French - 'fr'

This is further confirmed as the Load DWH job populates the table and completes.