You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse. You need to est
Posted: Mon Oct 17, 2022 4:48 pm
You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse.
You need to establish the correct order for loading each table to maximize parallel processing.
Which order should you use?
A. 1. DimCurrency, DimScenario, DimAccount in parallel 2. DimOrganization 3. FactFinance
B. 1. DimCurrency, DimOrganization in parallel 2. DimScenario, DimAccount in parallel 3. FactFinance
C. 1. DimCurrency, FactFinance in parallel 2. DimOrganization, DimScenario, DimAccount in parallel
D. 1. FactFinance 2. DimOrganization, DimScenario, DimAccount in parallel 3. DimCurrency
E. 1. DimCurrency 2. DimOrganization 3. DimScenario, DimAccount in parallel
You need to establish the correct order for loading each table to maximize parallel processing.
Which order should you use?
- You Are Develop 1 (10.64 KiB) Viewed 72 times
B. 1. DimCurrency, DimOrganization in parallel 2. DimScenario, DimAccount in parallel 3. FactFinance
C. 1. DimCurrency, FactFinance in parallel 2. DimOrganization, DimScenario, DimAccount in parallel
D. 1. FactFinance 2. DimOrganization, DimScenario, DimAccount in parallel 3. DimCurrency
E. 1. DimCurrency 2. DimOrganization 3. DimScenario, DimAccount in parallel