fact table ETL
acquiring dimension surrogate key
with Execute SQL Task, 149
Fuzzy Lookup transformation for, 149, 155–159
for historical changes, 148
for inferred members, 148, 154
for large dimensions, 154
for late-arriving facts, 148, 154
Lookup transformation for, 149–154
Merge Join transformation for, 149, 155
for missing dimension records, 148
definition of, 147–148
for late-arriving facts, 148, 154, 187–190
measure calculations, 159–161
for missing dimension records, 148, 181–186
fact tables
changes to, handling
approaches for, 161–163
data deletions, 170
data inserts, 170
data updates, 170–172
Lookup transformation for, 163–166
Merge Join transformation for, 167–169
data grain changes
example of, 175–181
forms of, 173
transformations for, 173–175
definition of, 4, 143–144
dimension surrogate keys in, 95, 143–144
loading of, adding inferred members during, 105–106
mapping source files to, 144
measures in, 143, 145
metadata in, 145
relating to dimensions, 94–95
snapshot fact tables, 145–146
transaction fact tables, 145
Failure() method, 37
FastParse property, flat file source adapter, 58–60
file system, Package Store on, 287–288
file watcher task, building, 252–254
FireError() method, 37–39
firewall port settings, 299
fixed attribute (Change Type 0)
definition of, 102
implications on SSAS attributes, 222–223
Fixed Attribute Output, SCD Wizard, 120
Flat File Connection Manager
for file with multiple record types, 317, 318
migration to SSIS, 350–351
flat file source adapter
change identifier columns in, 82–83
using, 58–60
For Each Loop container, 19–20, 36, 129
For Loop container, 19, 129
full cache, 366
full outer join, Merge Join transformation, 155
full process, for SSAS dimensions, 193
Fuzzy Lookup transformation, for acquiring dimension surrogate key, 149, 155–159