M

Management Studio

accessing packages from, 288–289

administration of DTS packages using, 335

assigning package roles using, 297–299

running DTExecUI.exe utility from, 290–297

Maximum insert commit size option, OLE DB destination, 375

MDAC (Microsoft Data Access Components)

providers for, 61

sources from, 56

32-bit and 64-bit issues regarding, 307

measure groups (SSAS)

definition of, 123

processing of, 192

measures, in fact tables

calculations for, 159–161

definition of, 143, 145

memory utilization, 357–360

Merge Join transformation

for acquiring dimension surrogate key, 149, 155

for data grain changes, 174

for identifying fact table changes, 167–169

joining source data to dimension data, 133–136

Merge transformation, for data grain changes, 174

metadata

definition of, 86

in fact tables, 145

Microsoft Data Access Components (MDAC)

providers for, 61

sources from, 56

32-bit and 64-bit issues regarding, 307

Microsoft Data Warehouse Toolkit (Wiley), 102

Microsoft Distributed Transaction Coordinator (MSDTC), 243

Microsoft Providers

for DB2, 331

for Oracle, 327, 328

mining models (SSAS), 196.

See also data mining objects (SSAS)

mining structures (SSAS), 196.

See also data mining objects (SSAS)

msdb database

Package Store in, 287–288

roles in, used by package roles, 298

MSDTC (Microsoft Distributed Transaction Coordinator), 243

MsDtsServer service. See SSIS Service

MsDTSSrvr.exe executable, 354

MsDtsSrvr.ini.xml file, 284, 285

Multicast transformation

change identifier columns using, 77

data staging using, 66–67, 368