4 Replies Latest reply: Mar 14, 2012 10:36 AM by Sasidhar K RSS

Data model with two similar facts - Please Help!

Sasidhar K

Hi,

 

Could anyone look into my issue and provide some inputs. Thanks much in advance for your help.

 

Curently I've dimensions D1,..D7 and Fact (F1) [Star schema] and I need to bring in another fact F2, which is a subset to the existing F1.

 

Can I get this keeping the field names same in both F! and F2? Could any one let me know the way to add F2 so that I'll have a star1 as D1..D7 and F1, similarly Star2 as D1-D7 and F2?

 

I tried using NoConcatinate and it is creating a Synthetic key for all the field existing in F1/F2 as their names are similar. Also I'm getting the error before the load process starts for Fact2 (F2) as below.

 

SQL##f - SqlState: S0022, Error Code: 904, ErrorMsg: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00904:

 

I need some help from you.

 

Kindly advise if you are aware of any solution for the same.

 

Thanks -

Sasi