Synthetic Key Problem

[#1]

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

[narender123]

Hi,

Isvn_Account_Rx_Mthly_Fact

%Issp_Sales_Hoerarchy_Id,

%Isvn_Account_Dim_Id as Key,

\\means make one column name alias

Thanks.

[#3]

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

[calvindk]

Qualify *;

Unqualify FieldLink, SameFieldLinkDifferentName;

Load

*, FieldLink, SameFieldLinkDifferentName

from Dim;

Load

*, FieldLink

from fact;

Load

*, SameFieldLinkDifferentName

from aggrfact;

[narender123]

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.