to load data into one fact table from more than one dimension tables . firstly u need to create afact table and dimension tables. later load data into individual dimensions by using sources and transformations(aggregator,sequence generator,lookup) in mapping designer then to the fact table connect the surrogate to the foreign key and the columns from dimensions to the fact.
ravi kumar guturi
Mar 20th, 2006
Noramally evey one use
!)slowly changing diemnsions
2)slowly growing dimensions
if u have any doubts call me 9313186719
Hareesh
Mar 21st, 2006
Hi
after loading the data into dimensions how we will load the data in to the facts from the dimensions that is what my question is?
hi after loading the data into the dimention tables we will load the data into the fact tables ... the reason for this is that the dimention tables contain the data related to the fact table.
to load the data from dimention table to fact table is simple ..
assume (dimention table as source tables) and fact table as target. thats all.....
Hareesh
Apr 3rd, 2006
Kishore,
yaa, dimension table has to be treated as a source, but how 'n' dimensions will be loaded into a single fact table.
like do we use the one dimesion as a source and other dimnsions as a look up table we will load?or else any other logic we will implement?
Hareesh
venu adavelly
Sep 14th, 2007
Take 1 dimension as a source and take look up on remanning dim's pass only the primarykeys of the dim's to the fact table and also you can pass the measuer's. Don't think it's various from other mapping.
Hi Allwhat is the logic will you implement to laod the data in to one factv from 'n' number of dimension tables.