Importing empty or null data
When Creating ingest jobs, you can import empty or null values into the Oracle Unity data model.
Learn more about Ingesting Empty or Null Data using the Oracle Unity API from the Oracle Unity Developer Help Center.
Different ways to represent empty or null data in source files
You have the option of representing data without a value as either an empty or null value.
Review the restrictions on inserting empty or null data in the Oracle Unity data model.
The example below shows a record that can be imported with either an empty or null value.
| ID | FirstName | LastName | MiddleName |
|---|---|---|---|
| 100 | John | Doe |
The customer record doesn't have a middle name, so that value will be imported as an empty or null value.
You can represent the middle name data in the following ways.
Example 1: Empty value
The source file encloses all values for the record in double quotes, so the middle name value is imported as an empty value.
ID,FirstName,LastName,MiddleName
"100","John","Doe",""
Example 2: Empty value
The source file encloses the null value only in double quotes, so the middle name value is imported as an empty value.
ID,FirstName,LastName,MiddleName
100,John,Doe,""
Example 3: Empty value
The source file encloses some data values and the middle name value in double quotes, so the middle name value is imported as an empty value. One data value (Doe) is optionally parsed with commas instead of double quotes.
ID,FirstName,LastName,MiddleName
"100","John",Doe,""
Example 4: Null value
The source file doesn't use double quotes to parse data. Instead, the comma is the delimiter that parses the data. Parsing the middle name data with two consecutive commas means it is imported as a null value.
ID,FirstName,LastName,MiddleName
100,John,Doe,,
Example 5: Null value
The source file encloses all values in double quotes except for the middle name value. Parsing the middle name data with two consecutive commas means it is imported as a null value.
ID,FirstName,LastName,MiddleName
"100","John","Doe",,
Restrictions on empty or null data
You can't insert empty or null values to the following Data types:
-
Boolean
-
Array
You can't insert empty or null values into the following attributes for any data objects:
-
ID
-
TenantID
-
SourceID
-
CreatedBy
-
ModifiedBy
-
CreatedTS
-
ModifiedTS
-
RowCreatedTS
-
RowModifiedTS
-
SourceObjectID