Linking Fact tables

[NavinReddy]

Hi All,

I have a problem could some help me

im getting three Fact Tables How can i linking those Three Fact Table

any body help me

Thanks & Regards

Niranjan

[sushil353]

If they have similar fields then use concatenate statement..

also you can link them using composite key if they have multiple common fields.

HTh

Sushil

[#3]

for linking  all three table , one field must be unique . if no any field are unique in all,then write

Rowno() as key  in all three

[#4]

sample1:

fact1:

load

A,

B,

C , rowno() as key

FROM FACT1;

fact2:

load

D,

E,
rowno() as key

FROM fact2;

fact3:

load

F,

G, rowno() as key

FROM fact3;

****************************************

[#5]

Hi,

    If you three fact tables then you can form a single Link Table composing of these 3 Fact Tables .

Because there will be possibility that these fact tables might be sharing more than 1 dimension table in common .

So you can try to have a single Link table.

Regards

Yusuf

[NavinReddy]

Hi All,

Thank you guys for Quick repose

really its help full to me

Thanks & Regards

Niranjan

[#7]

hi

if your problem resolved then marked it as either correct or helpful according to your question so that it might be helpful for other developer

Regards

vishwaranjan