sql server - Fact table referencing another fact table? -
we started working on our data warehouse. have technicians, salespersons, date, branch, customer our dimensions. have transactional tables in oltp such sales orders, agreements, referenced each other in situations. i'm planning put sales order, agreements info in fact tables. so, reference above mentioned dimensions in both fact tables. but, here comes problem. sales orders , service agreements need referenced each other. in cases, agreements information need referenced in sales orders. can reference 2 fact tables each other in fact table? sales orders table in oltp consists million records, , agreement table holds half million records(minimum). can let me know if can reference these 2 in fact table?
do have agreementid can added each fact table , used drill across? degenerate dimension - dimension key without dimension table.
Comments
Post a Comment