When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?

Question

Options

• AThe analyst must first write DML (Data Manipulation Language) scripts to create the aggregate table.
• BThe Aggregate Persistence Wizard enables you to automate the creation of physical aggregate tables
• CJob Manager can be used to run the Aggregate Persistence script.
• DThe Extraction Transformation and Loading process creates the aggregate tables.

• A
  4% (1)
• B
  78% (18)
• D
  17% (4)

Explanation

B: The Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI Server metadata layer so that they're used when appropriate. C: The wizard then shows me a preview of the script it's going to generate, and asks me if I want to create any more summaries. Here's how the preview script looks - note that it's not SQL, it's a script language that the BI Server understands and uses as the specification for an aggregation job, which it then turns into separate CREATE TABLE, INSERT ... SELECT and so on SQL statements, "optimized" for the particular back-end database platform. for "Seminar - Complete"."Items"("Quantity") at levels ("Seminar - Complete"."Customerdim"."State", "Seminar - Complete"."Productdim"."Category", "Seminar - Complete"."Timedim"."Year") using connection pool "custdw"."CUSTDW_Pool" in "custdw".."CUSTDW";

No community discussion yet for this question.