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 |
|
ashishm
Starting Member
1 Post |
 Posted - 2011-06-16 : 06:03:59
|
| Hi All,I have populated my dim tables from many base tables via joins USING SCD. That part is working fine.But I dont know how to populate my fact table incrementally using dim tables and base tables through joins.I searched on internet. It is showing me to use lookup transformations but at all the sites I failed to find any demo.Plz put fwd ur ideas.ThanksAshishAshish |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-06-16 : 06:51:57
|
If you have the source system PK in the dim table you add a lookup to the data flow and then you join the source table with the dim table using this primary key in the "columns"-section of the lookup transformation. Then you check the checkbox in front of the surrogate key in the dim table to add that column as output to the data flow. Add an Output Alias to make it easier to find later in the data flow. ->  - LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-06-16 : 06:53:38
|
| ..then when you've done this for all your dimensions you insert the CustomerDimID instead of the CustomerID into the fact table.- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
|
|
|
Populate Fact Tables incrementally SSIS 2005