index_L

L

Lag and lead functions, 109, 120-21

defined, 120

example, 120

uses, 121

See also SQL functions

LAST function, 121

Level-based dimensions, 435-36

Lift

computing, 480-81

defined, 480

See also Oracle data mining

LIMIT command, 441

Linear regression analysis, 122

LIST BACKUP command, 359

LIST command, 359

List partitioning, 80-81

defined, 80

example, 81

illustrated, 81

See also Partitioning

Loading data, 209-78

dimensions, 253-55

dimension tables, 225-26

direct path load of single partition, 238-39

with duplicate dates, 237

ETL process and, 209-11

with external tables, 247-55

fact table, 226

initial population, 209

in parallel, 237

parallel direct load, 242

postload operations, 273-77

in single partition, 237

with SQL*Loader, 226-46

with transportable tablespaces, 256-60

See also Data warehouses; ETL process

Load Wizard, 227-35

accessing, 228

illustrated, 227

load monitoring, 233

load scheduling, 232

SQL*Loader advanced options, 232

SQL*Loader modes of operation, 231

See also Oracle Enterprise Manager; SQL*Loader

Local indexes, 90-92

defined, 90

nonprefixed, 91-92

partitions of, 374

prefixed, 90-91

types of, 90

See also Partitioned indexes

Lossless join, 181