Exam Ref 70-767 Implementing a SQL Data Warehouse

Index

A

additive measures 21

administrative tasks 237

administrator role types 237

Advanced Editor 180–181

alternate key columns 5, 6

asynchronous transforms 140–143

attributes

business rules for 244–245

changing 127

changing values of 10–11

columns 5–7

creating 235–237

dimension tables, determining 2–4

fixed 127

grouping related 4

implementing 243

auditing 16–17

audit logging 160

Audit transform 137–139

B

backup files 46, 47

Balanced Tree (B-Tree) structure 25

blocking transforms 140

breakpoints 171–174

built-in connectors 79

business rules 244–246, 256

C

cache limitations 145

calendar hierarchy 8

CDC. See Change Data Capture

Centralized approach 254

Change Data Capture (CDC) 83, 146, 147–148

components of 155–156

control task 155–156

in SSIS ...