You are performing incremental loads to an ASO database during the day, providing near
real time data to the SaleDtl ASO database. Before the incremental load, you need to clear a
specific set of data in the fastest amount of time possible. What is the best solution?
A.
Partial clears are supported for ASO
B.
Perform a logical clear, using MDX to specify the region to be cleared
C.
Perform a physical clear, using MDX to specify the region to be cleared
D.
Run a calc script containing the CLEARDATA command and a set of FIX statements that
isolate the desired data set
E.
Run a calc script containing the CLEARBLOCK command and a set of FIX statements
that isolate the desired data set
Explanation:
http://docs.google.com/viewer?a=v&q=cache:SGNuBKbS4BAJ:cobb.typepad.com/cubegeek
/files/Essbase11Preview.pdf+essbase+oracle+Before+incremental+load+ASO+database+pa
rtial+clear,+logical+clear,+physical+clear&hl=en&gl=in&pid=bl&srcid=ADGEESj9MSHsvWp
WZ4XdL3cUaNkYxSE8WKyYYwj5R_ZU4eOWUdudVPUtd8c_IqjFJ3h0wnVoaYmwzkCBdD
KcPXYxHZMxyKLGYwbC_BReBgzmaDZUMo4OIIQ7R-
10Ie8oesO_lKGKX_a&sig=AHIEtbQF1KpCDBIgJv7BRQtEHdrnsESzcwslide 23-25