Database Reference
In-Depth Information
The weapon to Slay Bad Data is in your hands in the form of this chapter. use these
harrowing, but true, stories of the malignant impact of bad data, a conceptual argument
for good data, how not to mend data, and, finally, a fully documented solution that illus-
trates how to ensure good data ends up in your database.
I look forward to a world where no one ever worries about the foundation of a sound
Essbase database. may universal referential integrity rule. go forth and not only do
good data, but do good data well.
2.6 appenDix: the CoDe
The following sections list the oDI, Essbase, and relational objects used to build the Slay
Bad Data solution described in this chapter. The full code stream is here; you can copy
the code in the variables, Procedures, and maxL scripts to use in your own projects or
simply download the code from the topic Web site.
2.6.1 ODI Objects
2.6.1.1 ODI Objects
2.6.1.1.1
Subfolder 1: Extract
Ty p e
Name
Purpose
Package
Pkg_Extract_ASosamp
Extract all dimensions of ASosamp.Sample to the table
Dimensions using compiled Scenarios of extract
Interfaces. This Package is not used as the Load Plan
PLAn_ASosamp executes the Interfaces.
Interface
Int_ExtractAge
Int_Extractgeography
Int_ExtractIncomeLevel
Int_Extractmeaures
Int_ExtractPaymenttype
Int_ExtractProducts
Int_ExtractPromotions
Int_ExtractStores
Int_Extracttime
Int_Extracttransactiontype
Int_Extractyears
Each Interface reverses a single Essbase dimension.
Scenario
SCn_Int_ExtractAge
SCn_Int_Extractgeography
SCn_Int_ExtractIncomeLevel
SCn_Int_Extractmeaures
SCn_Int_ExtractPaymenttype
SCn_Int_ExtractProducts
SCn_Int_ExtractPromotions
SCn_Int_ExtractStores
SCn_Int_Extracttime
SCn_Int_Extracttransactiontype
SCn_Int_Extractyears
Compiled Interfaces for use in Package and Load Plan.
SCn_Pkg_ExtrACt_ASoSAmP
Compiled Package called by the Load Plan
PLAn_ASosamp.
Procedure
n/A
