number of rows in a fact table


  • Hi,
    I need to  find only the number of rows in a fact table having the following data:
    1000 secondary schools in Italy,about 100 subjects which may be studied at E-level. 100000 students have been enrolled  for E-levels  each year .
    Most of 100000 students study 5 or 6 level subjects.
    • Moved by Raman Iyer Friday, May 15, 2009 5:58 PM (From:Data Mining)
    Wednesday, May 6, 2009 5:26 PM

All replies

  • If I understand your problem correctly (big if !), you need something like
    select count(*)
    from table1, table2, table ...
    table1.pk1 = table2.fk1 and
    table2.pk1 = table3.fk1 ...

    we can't really help you with the conditions as you haven't really shown us how your tables are linked but lit ooks like pretty straight-forward stuff here.
    Monday, June 15, 2009 2:02 PM