dwhprofessional

 Profile Answers by dwhprofessional Questions by dwhprofessional

• Mar 20th, 2006

 

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?

gazulas

 Profile Answers by gazulas Questions by gazulas

• Apr 2nd, 2006

 

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.