Which order should you use?

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 loadingeach table to maximize parallel processing. Which order
should you use?

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 loadingeach table to maximize parallel processing. Which order
should you use?

A.
1. DimCurrency, DimScenario, DimAccount in parallel
2. DimOrganization
3. FactFinance

B.
l. 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
4. FactFinance

Explanation:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms139892.aspx
http://msdn.microsoft.com/en-us/library/ms141261.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Howie

Howie

A.
1. DimCurrency, DimScenario, DimAccount in parallel
2. DimOrganization
3. FactFinance