It might be because somebody check-out and never check-in. Then somebody else check-out again.


In the above example, it is the Account dimension with problem.

1. Open a new query window from SQL server end

2. Check how many rows of below 5 tables: 

  • Select count(*) from DS_Account
  • Select count(*) from S_DS_Account
  • Select count(*) from O_DS_Account
  • Select count(*) from O_HS_Account_Account 
  • Select count(*) from S_HS_Account_Account 
3. There 5 tables should have the same number of rows.
4. If any of these five tables have too many or too few rows, pls truncate those tables. 
5. Then re-insert them with the right table or run ETL procedure from ETL database.