1. User Guide
  2. Big Data in OFSDF
  3. OFSDF Big Data Architecture
  4. Workarounds in the Staging and Results on Hive
  5. Workarounds

12.2.3.2 Workarounds

The list of workarounds in OFSDF Hive (Staging and Results on Hive deployment process) is:

· The process of data access, modification, and representation is different in HDFS compared to that of RDBMS. Therefore, the mechanism for Data Protection also varies.

Workarounds:

§ Data Redaction

The process of enabling Data Redaction for Hive can be performed using CDH Manager (Cloudera Distribution Hadoop Manager). For more information, see the section Sensitive Data Redaction in the Cloudera Security Guide.

§ Right to Forget

The Right to Forget feature enhancement is planned for future releases. However, prior to loading in the Hive instance, Anonymization of Party PII data can be done at the source. This process provides the flexibility to secure the PII information, and in addition, to drop the PII upon a request from the Party.

· Mappers are supported using AM/HM screens in OFSDF (RDBMS). However, development of the underlying functionality for AM/HM feature in OFSDF Hive is planned for future releases. Therefore, the Mappers will be supported during future releases.

Workaround:

The Views defined on these Mappers in RDBMS are converted to Tables in Hive. Therefore, these Mappers must be loaded manually:

§ MAP_BAL_CAT_STD_BAL_CAT

§ MAP_CRDLN_PUR_STD_CRDLN_PUR

§ MAP_CRDLN_TYP_STD_CRDLN_TYP

§ MAP_CREDIT_SCR_MDL_REG_MDL_DDL

§ MAP_CREDIT_SCR_MDL_REG_MDL_VWI

§ MAP_DIM_IRC_STD_IRC

§ MAP_DIM_LOB_STD_LOB

§ MAP_GL_CODE_REP_LINE

§ MAP_MITG_TYP_STD_MITGN_TYP

§ MAP_PARTY_TYP_STD_PARTY_TYP

§ MAP_PROD_CODE_STD_PROD_TYPE

§ MAP_DIM_GL_ACCT_STD_GL_TYPE

§ MAP_VEHCL_TYP_STD_VEHCL_TYP

§ MAP_RECVR_TYP_STD_RECVR_TYP

§ MAP_WRTOFF_STD_WRTOFF_REASN

· Data is not populated in the target table FSI_INTRA_COMPANY_ACCOUNT.

Workaround:

FSI_REG_LEGAL_ENTITY_HIER load references POP_REG_LE_HIER DT, which is not supported in OFSDF Hive. FSI_REG_LEGAL_ENTITY_HIER must be loaded to make use of the T2T for FSI_REG_LEGAL_ENTITY_HIER because that T2T consists of an inner join on FSI_REG_LEGAL_ENTITY_HIER.

Similarly, Dimension tables for Unsupported SCDs must be loaded to make use of the T2Ts that reference them.

· In Hive, the exchange rates population for cross currencies is not being derived using exchange rates values for a base currency.

Workaround:

Source the corresponding Exchange Rate value.

· When performing Big Data installation for OFSDF Hive, the following error is logged in the file OFS_BFND_installation.log:

Error:ORA-00942: table or view does not exist

ORA-06512: at "<Atomic_Schema_Name>.FSI_CREATE_SEQUENCE", line 6 Workaround:

This error can be ignored.