Forum Discussion

congDA's avatar
congDA
Frequent Visitor
4 years ago

Duplicate Value

Evething is okay until yesterday but I got an refresher error this morning. It said that FACT_ORDERS table contains a duplicate value, so I go to the database and write a simple query to check: there...
Data Modeling
Reports
otravers's avatar
otravers
Community Champion
4 years ago

Are you using incremental refresh on this table?

  • congDA's avatar
    congDA
    Frequent Visitor
    4 years ago

    Yes, I am. Does it make this error? Could you explain for me? Thank you

    • otravers's avatar
      otravers
      Community Champion
      4 years ago

      Check that you're using < RangeEnd, not <= in your filter.

      • congDA's avatar
        congDA
        Frequent Visitor
        4 years ago

        I'm using < RangeEnd ğŸ˜­ I still don't know why this happened. Why is it related to RangEnd and incremental refresh?