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 zOS Source and Databricks Delta Target

Db2 for zOS Source and Databricks Delta Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with a Db2 for zOS source and a Databricks Delta target:
Db2 for zOS Source Data Type
Databricks Delta Target Data Type
bigint
long
binary(
size
), 1 <= s <= 255
binary
char for bit data
binary
char(
size
) for bit data, 2 <= s <= 255
binary
char(
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
float
double
integer
integer
long varchar
string
long varchar for bit data
binary
real
float
rowid
binary
smallint
integer
time
string
timestamp(
precision
) with time zone, 0 <= p <= 12
string
timestamp(
precision
), 0 <= p <= 6
timestamp
timestamp(
precision
), 7 <= p <= 12
string
varbinary(
size
), 1 <= s <= 32704
binary
varchar(
size
) for bit data, 1 <= s <= 32704
binary
varchar(
size
), 1 <= s <= 32704
string

0 COMMENTS

We’d like to hear from you!