F


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, 5860

file system, Package Store on, 287288

file watcher task, building, 252254

FireError() method, 3739

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, 1920, 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, 155159



Expert SQL Server 2005 Integration Services
Expert SQL Server 2005 Integration Services (Programmer to Programmer)
ISBN: 0470134119
EAN: 2147483647
Year: 2004
Pages: 111

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net