'52@0?6=A6;09B12@A523<99<D6;4=9.025<912?@3<?16:2;@6<;A./92@
J CustomAttributeN I'5282F;.:2.@@A<?21/F"!
J USER_DATA_CUST_DIM_1 I'52B@2?1.A.16:2;@6<;A./92;.:2D5605F<B12K;216; &A2=
J DIM_ATTRIBUTE_N I'520<9B:;;.:2D5605F<B12K;216; &A2=
'52@0?6=A.9@<?2>B6?2@F<BA<@=2063FA52=?<=.4.A6<;?B92123.B9AC.9B2.;1.0A6C6AF
@A.AB@3<?2.05)#<?:<?26;3<?:.A6<;./<BAC.9B2@3<?A52@2K291@@22A520<9B:;
12@0?6=A6<;@3<?A52 CTL_UD_TO_UDE_MAPPING A./926;A52 Genesys Info Mart Reference
Manual 3<?F<B?% &
;@B?2A5.AA52123.B9AC.9B2@A5.AF<B@=2063F.?20<;@6@A2;AD6A5A521.A.AF=23<?A52
0<9B:;
3F<BD.;A2;2@F@;3< .?AA<@A<?2.1.A2A6:2C.9B22E=?2@@216;.3<?:.A<A52?A5.;A52
2;2@F@;3< .?A123.B9A3<?:.A3<?1.A2A6:23<?2E.:=92 DD Mon YY 6;@A2.1<3 yyyy-mm-
ddThh24:mi:ss.ff@=2063FA520<;C2?@6<;2E=?2@@6<;6;A52 CONVERT_EXPRESSION K2916;A52
CTL_UD_TO_UDE_MAPPING A./922;A?F3<?A52)#2;2@F@;3< .?A6;09B12@A520<;C2?@6<;
2E=?2@@6<;6;&$@A.A2:2;A@A<0<;C2?AA521.A.
J <? 60?<@<3A&$&2?C2?A520<;C2?@6<;2E=?2@@6<;6@
${schema}.GIM_TO_TIMESTAMP_ISO8601(${})
D52?2
J ${schema} 6@.=9.025<912?3<?A52;3< .?A1.A./.@2@052:.;.:22;2@F@;3< .?A
42A@A52C.9B2<3A52 ${schema} =.?.:2A2?3?<:A52 123.B9A@052:. <=A6<;6;A52;3<
.?A #
J ${} 6@.=9.025<912?3<?A52)#C.9B2A</20<;C2?A21
J GIM_TO_TIMESTAMP_ISO8601 6@.;<BA<3/<E3B;0A6<;D5605K?@A2E20BA2@.;<A52?
<BA<3/<E3B;0A6<; GIM_IS_ISO8601_DATEA<052083<?:.A/23<?20.996;4A52 60?<@<3A
&$&2?C2?@F@A2:3B;0A6<; convert(datetime, ${}, 126) A<0<;C2?AA521.A2A6:2
2E=?2@@6<;6;3<?:.A yyyy-mm-ddThh24:mi:ss.ff.
A6@;<A=<@@6/92A<B@2 convert() D6A5<BAK?@A052086;4A523<?:.A<3A522E=?2@@6<;
/20.B@2<3. 60?<@<3A&$&2?C2?96:6A.A6<;A5.A:.82@A?.;@.0A6<;@B;B@./92.3A2?
:<@A0<;C2?@6<;2??<?@'<0B@A<:6G2A520<;C2?@6<;F<B:B@A12K;2F<B?<D;
0<;C2?@6<;3B;0A6<;6;A521.A./.@2.;1A52;0.99A5.A3B;0A6<;6;A52
CONVERT_EXPRESSION K291B@6;4A52@F;A.E@5<D;./<C2(@2A52
GIM_TO_TIMESTAMP_ISO8601 .;1 GIM_IS_ISO8601_DATE 3B;0A6<;@D5605.?2
12K;216;A52 make_gim.sql .;1 make_gim_partitioned.sql @0?6=A@.@2E.:=92@
3<?F<B?0B@A<:3B;0A6<;@6;0<;7B;0A6<;D6A5% &1<0B:2;A.A6<;./<BA@F;A.E
?2>B6?2:2;A@.;11.A23<?:.A@<;<A:<163FA52<BA<3/<E3B;0A6<;@
J <?"?.092A520<;C2?@6<;2E=?2@@6<;6@
TO_DATE(${},'yyyy-mm-dd'T'hh24:mi:ss')
<?
TO_TIMESTAMP(${},'yyyy-mm-dd'T'hh24:mi:ss.ff')
D52?2 ${} 6@.=9.025<912?3<?A52)#C.9B2A</20<;C2?A21
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612