Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Bolo.

Table of Contents

Search

  1. Introducing Mass Ingestion
  2. Getting Started with Mass Ingestion
  3. Connectors and Connections
  4. Mass Ingestion Applications
  5. Mass Ingestion Databases
  6. Mass Ingestion Files
  7. Mass Ingestion Streaming
  8. Monitoring Mass Ingestion Jobs
  9. Asset Management
  10. Troubleshooting

Mass Ingestion

Mass Ingestion

Oracle Source and Databricks Delta Target

Oracle Source and Databricks Delta Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with a Oracle source and a Databricks Delta target:
Oracle Source Data Type
Databricks Delta Target Data Type
binary_double
double
binary_float
float
char(s byte), 1 <= s <= 2000
string
char(s char), 1 <= s <= 2000
string
date
timestamp
float(
precision
), 1 <= p <= 126
string
integer
string
long raw
binary
long(2147483648 byte)
string
nchar(s char), 1 <= s <= 2000
string
number
string
number(*,s), -84 <= s <= 127
string
number(p,s), 1 <= p <= 38, -37 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
number(p,s), 1 <= p <= 38, -84 <= s <= 127
string
nvarchar2(s char), 1 <= s <= 4000
string
raw(
size
), 1 <= s <= 4000
binary
rowid
string
timestamp(
precision
) with time zone, 0 <= p <= 6
timestamp
timestamp(
precision
) with time zone, 7 <= p <= 9
string
timestamp(
precision
), 1 <= p <= 6
timestamp
timestamp(
precision
), 7 <= p <= 9
string
varchar2(s byte), 1 <= s <= 4000
string
varchar2(s char), 1 <= s <= 4000
string

0 COMMENTS

We’d like to hear from you!