Hi All,
I am getting following error while creating star schema through infoassist webconsole wizard
"The Fact table is the central table of a star schema.
The table that you selected (appolapdb/) cannot be joined, as a result no star schema can be generated.
A likely reason is missing foreign keys or matching field names.
"....

Please suggest me the solution for this....

following is the test database structure I created:

create table dim_datedetail(
datedetail_dateid numeric(18, 0) primary key,
datedetail_year nvarchar(50) null,
datedetail_quarter nvarchar(50) null,
datedetail_month nvarchar(50) null,
datedetail_day nvarchar(50) null,
);

create table dim_productdetail(
productdetail_productid numeric(18, 0) primary key,
productdetail_productname nvarchar(50) null,
productdetail_productfamily nvarchar(50) null,
productdetail_productgroup nvarchar(50) null,
productdetail_productsubcategory nvarchar(50) null,
productdetail_costperunit numeric(18,0) null
);

create table dim_salespersondetail(
salespersondetail_id numeric(18, 0) primary key,
salespersondetail_firstname nvarchar(50) null,
salespersondetail_lastname nvarchar(50) null,
);

create table dim_storedetail(
storedetail_storeid numeric(18, 0) primary key,
storedetail_country nvarchar(50) null,
storedetail_state nvarchar(50) null,
storedetail_city nvarchar(50) null,
storedetail_store nvarchar(50) null,
);

create table fact_salesdetail(
salesdetail_dateid_fk numeric(18, 0) references dim_datedetail(datedetail_dateid),
salesdetail_productid_fk numeric(18, 0) references dim_productdetail(productdetail_productid),
salesdetail_storeid_fk numeric(18, 0) references dim_storedetail(storedetail_storeid),
salesdetail__salespersondetail_id_fk numeric(18, 0) references dim_salespersondetail(salespersondetail_id),
salesdetail_sales numeric(18, 0) null,
salesdetail_units numeric(18, 0) null,
salesdetail_total_cost numeric(18, 0) null,
) ;

This message has been edited. Last edited by: kumud.vaish,

Hi kumud.vaish,

what is the primary key of your fact table fact_salesdetail?? I think you will need one!!

Regards

Christian

Hi Christian,

Well the issue is resolved now. The conclusion I took out is we dont need to include the foreign keys during synonym creation in the wizard.

Please correct me If i am wrong here

-Regards
-Kumud Vaish