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

Data model with two similar facts - Please Help!

Sasidhar K



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 -