Scriptbasiertes Deployment mit Oracle Warehouse

!"
#
%
&
#
)
" '(
* +
*
+
+
0
8
5
1
:
!
6
3
#
,
+
##
#
*
2
$#
"
3
30 <
,
30
5 0
0
3
4
3 *
5
65
5
=
?
3
-
;
5
1
3
@
.+ , -/0
!
1 5 16 5
5
9
5 3
3
<
1
0
><
<
1
3<
#1
+ , -"7
0
*
3
3
+ 16 5
=
5
*
#
4 3
3
*
5
9 =
5
1
2
0
9#A"
<1
1
A( D A"#
9
2
4
- #1
-
3
7
B1
+, 5C
= 3
3
3
<
F
3
3
5
6
+, - 5
3 <
3
=
01
3
@
<
3 B
< 9@
#1
3
E
:
5
#1
5
02
5C
D A"
#1
!
#1
5
0
+ , -"7
30
3
3 0
3 0
9
0
3
4
3
8
3
*
0
1
5
3
#1
3
5
3
<
9
9
3 !
0
<
2 3
3
1
3
"
=
5
9
3
3
3
7
7
3
1 5
<
1
3
*
1
0
3
3
3
0
3
=1
0
7
3
3
!
!
*
"0
3 ,
3 <
0
3
*
1
30
3
#
3
3
,
5
3
3 1
3
7
-
5
!
3
!
3 <
9
4
3
3
=
1 3
3
!
3 5
3
3
0
1
0 <
1
;
5
3 1
1
"
3
0
<
"#
$
$% &$ '&%
'
()
" '(
A
.
!-
3"!
+ , -"7
<
+ -G
1
0
2
<1
+
+, - 1
+ -G
<
C3
-"
5
+
*
"
=5
5
=
+
5 0
1
0
3
3
-G
*
+, -
3 <
3
5
5
.
3
5
+
/
+ , -"
6
-G
01
-
30
H "1
65
+ -G
I3
3
5C
+ , -"
J
OMBCC '/MY_PROJECT/DATA_MART';
foreach Map [ OMBLIST MAPPINGS ] {
OMBALTER MAPPING '$Map' \
SET PROPERTIES (GENERATION_MODE) VALUES('SET_BASED');
}
:
4
3
< 6
3
3 3
3
5
=5
5
-
3
1
0
1 5
3
+, 3
33 C
3
0
<
1
=
@
= 3 1
<
0 <
9
= 3 1
3
*"
3
K
1
<
3"
!
:
9
1
0
3"
#
5C
*
!
#
4
0
7
3
5
*"!
# 35
#
0
1
=1
< +
,
"
.:
+ , -" 3
+
-G
5 0
3 <
0
9@
/0
3
+ , -"+ 16 5
3 <
2
3 5C
65
=
3
3
>
3 <
1
5
A1
3
*
"
65
0
5C
2 1
1
3
!
1
5"
"#
$
9
3
5 0
+ , -"2
$% &$ '&%
'
3
65 "
<1
' ()
?
3
+ , -"2
+ -G
2
7
=
" *
C3
0
4
2
2
5
0
C3
= 1
5C
1
IB
5
4
5
<3
33
3
0 3
<
*"4 5
5 <1
+, 3
+ 16 5
3
4
A1
9@
4
+, -
3
-
4 5
4< 7
4
65
8
1
3
5
0
5
3 "# 1
3
A
#1
!"
=
3
*
"?
3
1
8
*
•
0
37
9@
4 5
5
3
5
B
# 35
3
9
0
5
3
/
=
5
A
3
<
9
#=>9
3
4 5 "# 1
3 3=
3
3
J
=#=L =7#
4
0
*
1
5
*
<
1
•
;
5 1
+ , -"2
A1
3
3
3
91
H9@
3
:
5C
5
<
5
"
9
-G
"=
=
,
+ , -"2
A1
@<
5
37
4
=
+
3
4
3 3
3
=
7
1
4
3 "# 1
3
3 C
0
=
#1
0
@
0
1
79=#9
C
•
E
<
•
#1
3 "# 1
7
0
1
4 5 "# 1
!
. 3
45
<
3H 1 5
<
=
4<
3 "# 1
<
3
A
1
1
3
"&
6
3
•
!"
1
1
#$
0
#1
#
1
,
I/3
3
3 <
•
3
3 <
<
1
",
0
8
3 3
=#=L =7#
A 1
3
D A"
3 <
3
0
8
79 A= 9
3 <
!
"#
$
1
5
%
"&
>7=E #"3
5C
3
<
1
#
# "&
30
*
$% &$ '&%
?
3 <
4<
3
3
<
'
& ()
F
2
<3
5
A1
33
' (
•
=
*
)
<
-
3
*+ ,* ' J
' (
7+ / <
3
"
A
<
+ 16 5
+ 16 5
1
*
0
?
5
3
.-
79=#9
8
1
5
*
•
)
1
*+ ,* ' <
1
13
D A"
5
3
*
<
1
1
= 3
3
3
3
J
# Include Configuration Files
IncludeFile $::G_CFG_DIR/common.ini
IncludeFile $::G_CFG_DIR/config_PROD.ini
IncludeDir $::G_TVDOMB_DIR/lib112
# Connection to Repository and Control Center
ConnectRepository ::REP_CONN
ConnectControlCenter ::RTREP_CONN
# Register Locations
IgnoreErrors $::G_CFG_DIR/ignore_register_errors.lst
RegisterLocation MART_LOCATION ::MART_CONN
RegisterLocation STAGE_LOCATION ::STAGE_CONN
# Drop Existing Stage Tables
IgnoreErrors $::G_CFG_DIR/ignore_deploy_errors.lst
DeployFileToCC "MY_PROJECT" "$::G_CFG_DIR/release_1_2.lst" "STAGE"
"TABLE" ";" "DROP"
# Deploy All Stage Tables and New Dimension Tables
IgnoreErrors ""
DeployFileToCC "MY_PROJECT" "$::G_CFG_DIR/release_1_2.lst" "STAGE DATA_MART"
"TABLE" ";" "CREATE"
# Migration of Existing Fact Tables
ExecuteSQLScript ::MART_CONN $::G_SQL_DIR/reorg_fact_tables.sql
# Grant Access Rights on Tables
ExecuteSQLScript ::STAGE_CONN $::G_SQL_DIR/grant_stage.sql
ExecuteSQLScript ::MART_CONN $::G_SQL_DIR/grant_mart.sql
# Deploy Mappings for Staging Area and Data Mart
DeployFileToCC "" "$::G_CFG_DIR/release_1_2.lst" "STAGE DATA_MART"
"MAPPING" ";" "REPLACE"
# Disconnect from Repository and Control Center
DisconnectRepository
DisconnectControlCenter
: 3 1 3
1 5
?
3
5
3
?
3
A
0:
0
0
C
3
3 1
=
8
!
"#
"
0
3
3
3
$
*
$% &$ '&%
*
65
M1
3 <
'
0
4
()
!
3
3
?
-
$#
3 1 3
4
<
5
"
0
"
,
3
4 5
# 35
0
<1
5
3
5
E 1
3
=
9
1
2
9
5
2
31
#
=>
9
"
K"$
>
!
J
3 1
9
+ , -"9
5
7
35
3 <
<
1
0
5
=
3
2
65
*
3
3
331
2
J
6
0
3
0
3 .9
5 30# 0
5
/
@5 3
3
5
@
, K" *
=
3
#
"?
"
<
# J
4 @J
1 33
3
0
3
>
<3
3
: 3 1
5
3
3 1
3
!
N& . /&&"$ $ %
N& . /&&"$ $ %
J
!
"#
$
$% &$ '&%
'
) ()