--First count the record number of original table.
SELECT COUNT(*)
  FROM table_original A
--Relate with the first dimension table, and capture the record number.  
SELECT COUNT(*)
  FROM table_original A,table_dimension1 B
 WHERE A.ID = B.ID;
--Relate with the second and more dimension table, and capture the 
--record number, to verify the result.
SELECT COUNT(*)
  FROM table_original A,table_dimension1 B, table_dimension2 C
 WHERE A.ID = B.ID
   AND A.ID = C.ID;