L

late-arriving dimension scenario (inferred members)

adding during fact load, 105–106

with fact table ETL, 148, 154

handling in fact table ETL, 182

implications on SSAS attributes, 222–223

reasons for, 104–105

specifying in SCD Wizard, 112–118

updating during dimension load, 106–107

late-arriving fact, 148, 154, 187–190

late-binding approach, 26

left outer join, Merge Join transformation, 155

libraries (assemblies)

adding to GAC, 30–35

calling from Script Task, 33

creating, 27–29

referencing from local directory, 30

strong name for, 30–31

testing, 34–35

lineage, data

approaches for, 86–87

definition of, 55, 86

sequence lineage number for, 87–88

load method, 382

loading of data. See ETL (extraction, transformation, and loading)

Local Temp DB Connection Manager, 346

log-based auditing, 68

logging

definition of, 233–234

log file for, unique, 236–237

monitoring data flow of, 235–236

performance of, 368

provider for, creating, 234–235

reporting on, 237

Lookup transformation

for acquiring dimension surrogate key, 149–154

cached, 136–137

correlating data using, 133, 134

for data grain changes, 174

data preparation using, 101

definition of, 97

for identifying fact table changes, 163–166

optimizing, 366–367

loops

For Each Loop container, 19–20, 36, 129

For Loop container, 19, 129