Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Could some help me get out of this Query
i have Fact table and Multiple Dimention Tables
How can i use Dimention Table Fields in Fact Table
Linking between Fact Table and Dimention Table
Thanks & Regards
Niranjan
Hi,
A common field name in both Fact and Dimension table automatically links the tables.
Regards,
Jagan.
Hi jagan,
No common Field ,Multiple Dimension Tables Fields how to link Fact table
I think one to many relation ship
if i am wrong plz correct me
Thanks & Regards
Niranjan
if you have different names in your fiels you can rename for example;
table1:
Load
Key_Customer
Amount
from FactTable.qvd(qvd);
table2:
Load
field1 as Key_Customer
field2 as Description
from catalogs.qvd (qvd);
this way the qliview linked both table by Key_customer because the names of the fields now are the same name.
otherway is using left, rigth,outer join.
table1:
Load
Key_Customer
Amount
from FactTable.qvd(qvd);
left join
table2:
Load
field1 as Key_Customer
field2 as Description
from catalogs.qvd (qvd);
YOU HAVE A GREAT DAY!!!!
Hi Niranjan,
Check here. And this one may give some idea to get start:
[Fact]:
Load
Dim1F1 &'|'& Dim1F2 &'|'& Dim1F3 AS [_LinkDim1],
Dim2F1 &'|'& Dim2F2 AS [_LinkDim2],
FactVal1,
FactVal2;
From Fact;
[Dim1]:
Load
Dim1F1 &'|'& Dim1F2 &'|'& Dim1F3 AS [_LinkDim1],
Dim1Val;
From Dim1;
[Dim2]:
Load
Dim2F1 &'|'& Dim2F2 AS [_LinkDim2],
Dim2Val;
From Dim2;
........................
Regards,
Sokkorn