My Oracle Support Banner

Questions on Loading Data via DIH When Using Hive for OFSAA (Doc ID 2814013.1)

Last updated on OCTOBER 20, 2021

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Data Integration Hub (DIH)
Oracle Financial Services Data Foundation (FSDF)

Goal

Q1: Why are duplicate records getting inserted from Hive to RDBMS with no failed message?  A Primary Key is not enabled in FSDF-Hive but you still expect duplicates to cause the load to fail.

Q2: Why are the not null constraints defined in tables not recognized during the load?  While Hive cannot identify the not null constraints and allows the null data, the load process should not allow it.

Q3: All attributes are stored as a string in Hive and get loaded into Hive irrespective of size.  How can you prevent values too large for the target column from being loaded from Hive to RDBMS?  This can cause an "ORA-12899: value too large for column".

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.