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
should this be E?
No, A is correct. In E 2. DimOrganization can be included in 3. DimScenario, DimAccount. Because of this E is 1 load less efficient than A.
Why not D?
Each Item on that list above requires the table to its left to complete in order to get the surrogate key values. So You need to do the fact table last, it needs the other tables to complete. D is almost the opposite order of what you need to do.
Agreed with Henry. during loading Fact table, it will look for keys to dim tables as FK. then failed . we cant load fact table first.
E is not too.DimScenario, DimAccount have no FKs to another tables. why not we load together with DimCurrency.
A