Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tybaltzeke
Starting Member
28 Posts |
 Posted - 2009-04-08 : 11:17:46
|
| My fact table load requires that lookups to the already created dimension tables to update a key. - Should these lookup transforms be done simulataneously or sequentially? I am in SS 2008 so i can use the parallel processing / cache tranform features. - Can the lookup be configured to do the lookup based on concatenated keys. can this be done in the wizard? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-12 : 13:52:05
|
| you can do it based on how you get values. if by the time fact runs all dimension data are available you can use parallel execution.not sure what you mean by concatenated keys can you explain? |
 |
|
|
|
|
|
Preliminary design considerations