Oracle9iR2 Data Warehousing

W

Warehouse Fact Table Editor, 288–89

Warehouse keys, 23–24

generating, 222–24

looking up, 262–63

operational system, 223

surrogate, 222–24

Warehouse Module Editor, 286, 287

Warehousing tools, 279–328

choosing, 279

Oracle Discoverer, 300–328

Oracle Warehouse Builder (OWB), 279–300

Web

data published on, 400

data warehousing and, 399–425

distributing reports to, 410–12

functions, 400–401

report building for, 421–25

See also Internet; Intranet

What-if analysis, 124–25, 430–31

WHEN clause, 267

WHERE clause, 111, 143, 174, 392

WIDTH_BUCKET() function, 115

Window aggregate functions, 109, 115–18

WITH clause, 129–30

benefits, 129

defined, 129

use example, 129–30

Workbook, 318, 320

Workload

defined, 197

filter, 197–98

hypothetical, 205

loading, 197, 200

user-defined, 200–201