Forum Discussion

turkfoster's avatar
turkfoster
Frequent Visitor
7 years ago
Solved

Data refresh issue

Updating a SQL table with only 1.1m rows shows more than 6m records being refreshed during update. Its the only table where I have refresh turned on. What's going on?
Need Help
  • turkfoster's avatar
    turkfoster
    7 years ago

    The checksum is a good idea. I just want to be able to have confidence in the data that was loaded. Thanks!

turkfoster's avatar
turkfoster
Frequent Visitor
7 years ago

It seems like there may not be an issue but it makes me nervouse that it is reflecting more rows in the refresh process than actually exist. As there are more than 1 m records in the result set I have to trust that they came through correctly but it seems odd to have the refresh showing upwards of 7m records being refreshed from a table that only has about 1m records.

parry2k's avatar
parry2k
Super User
7 years ago

turkfoster without looking at it , it is very hrd to say what is going on.

 

after refersh, if row count matches with your source data then you are good. May be you check sum of few columns with sum on souce data to make sure value matches. 

  • turkfoster's avatar
    turkfoster
    Frequent Visitor
    7 years ago

    The checksum is a good idea. I just want to be able to have confidence in the data that was loaded. Thanks!

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      7 years ago

      Hi turkfoster ,

      Have you solved your problem?

      If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

      If you still need help, please feel free to ask.

      Best  Regards,

      Cherry