Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We are facing problem in removing synthetic key from our datamodel.
I am attaching snapshot of it.
Kindly help to resolve the problem.
Thanx
Gauraw
Hi,
Isvn_Account_Rx_Mthly_Fact
%Issp_Sales_Hoerarchy_Id,
%Isvn_Account_Dim_Id as Key,
\\means make one column name alias
Thanks.
Hi Narender ........ Thanx for Response..........
We renamed %Isvn_Account_Dim_Id to %Isvn_Account_Dim_Id1 but the numbers in two fact tables are not matching. Both the fact tables numbers match when synthetic key is there in the datamodel.
Is there any other way to remove it?
Thanx
Gauraw
Qualify *;
Unqualify FieldLink, SameFieldLinkDifferentName;
Load
*, FieldLink, SameFieldLinkDifferentName
from Dim;
Load
*, FieldLink
from fact;
Load
*, SameFieldLinkDifferentName
from aggrfact;
Hi,
You can also make them syntatic key
%Issp_Sales_Hoerarchy_Id & '-' & %Isvn_Account_Dim_Id as Key,
.With this key can either repeat %Issp_Sales_Hoerarchy_Id or %Isvn_Account_Dim_Id this column means only one column in 1 table according to situation of join.
like
Table1:
%Issp_Sales_Hoerarchy_Id,
%Issp_Sales_Hoerarchy_Id & '-' & %Isvn_Account_Dim_Id as Key,
Note:dont use %Isvn_Account_Dim_Id as Key in Table1 .
Thanks.