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

DB2 for Linux, UNIX, and Windows Source and Databricks Delta Target

DB2 for Linux, UNIX, and Windows Source and Databricks Delta Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with a DB2 for Linux, UNIX, and Windows source and a Databricks Delta target:
DB2 for Linux, UNIX, and Windows Source Data Type
Databricks Delta Target Data Type
bigint
long
binary(
size
), 1 <= s <= 255
binary
boolean
boolean
char for bit data
binary
char(
size
) for bit data, 2 <= s <= 255
binary
character(
size
), 1 <= s <= 255
string
date
string
decfloat(
precision
), 16 <= p <= 34
string
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
double
double
integer
integer
long varchar
string
long varchar for bit data
binary
real
float
smallint
integer
time
string
timestamp(
precision
), 0 <= p <= 6
timestamp
timestamp(
precision
), 7 <= p <= 12
string
varbinary(
size
), 1 <= s <= 32672
binary
varchar(
size
) for bit data, 1 <= s <= 32672
binary
varchar(
size
), 1 <= s <= 32672
string

0 COMMENTS

We’d like to hear from you!