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 loading each 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 loading each 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:
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 *


Error 0x80040E14

Error 0x80040E14

Those explanation links go to two pages about SSIS.

The reason it is A, is because DimOrganisation has a foreign key tie with DimCurrency, thus DimOrganisation cannot be loaded ahead of or in parallel to DimCurrency and likewise FactFinance has a foreign key tie with three of the dimension tables so must be loaded after these.

I used some info from this link to supplement my own ideas.

http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/why-do-we-load-dimension-table-before-fact-table-5306716