アプリケーション取り込みとレプリケーション

前へ次へ

SAP ODPソースとAmazon Redshiftターゲット

次の表は、SAP ODPソースとAmazon Redshiftターゲットを使用した

設定の推奨データ型マッピングを示しています。

SAP ODPソースデータ型	Amazon Redshiftターゲットデータ型
accp(6)	character varying(24)
char(p), 1 <= p <= 255	character varying(p), 4 <= p <= 1020
clnt(p), 1 <= p <= 3	character varying(p), 4 <= p <= 12
cuky(p), 1 <= p <= 5	character varying(p), 4 <= p <= 20
curr(p,s), 1 <= p <= 38, 0 <= s <= 16	numeric(p,s), 1 <= p <= 38, 0 <= s <= 16
d16d(p,s), 1 <= p <= 38, 0 <= s <= 16	numeric(p,s), 1 <= p <= 38, 0 <= s <= 16
d16r	double precision
d34d(p,s), 1 <= p <= 38, 0 <= s <= 16	numeric(p,s), 1 <= p <= 38, 0 <= s <= 16
d34r	double precision
dats	date
dec(p,s), 1 <= p <= 38, 0 <= s <= 16	numeric(p,s), 1 <= p <= 38, 0 <= s <= 16
fltp	double precision
int1	smallint
int2	smallint
int4	integer
int8	bigint
lang(1)	character varying(4)
lchr *	character varying (65535)
lraw *	binary varying (1024000)
numc(p), 1 <= p <= 255	character varying(p), 4 <= p <= 1020
quan(p,s), 1 <= p <= 38, 0 <= s <= 16	numeric(p,s), 1 <= p <= 38, 0 <= s <= 16
raw(p), 1 <= p <= 255	binary varying(p), 1 <= p <= 255
sstr(p), 1 <= p <= 1333	character varying(p), 4 <= p <= 5332
strg *	character varying (65535)
tims	time without time zone
unit(p), 1 <= p <= 5	character varying(p), 4 <= p <= 20
* SAPでは、これらのデータ型の最大長は指定されていません。