9 Replies Latest reply: Feb 14, 2018 10:48 AM by Vamshi Krishna Reddy Singireddy RSS

    How do I exclude/delete records in a fact table based on a value in another table?

    Vamshi Krishna Reddy Singireddy

      Fact Table:

      Order#AmountOrderStatus
      1100FIRM
      2200CANCELLED
      3300DELETED

       

      DeleteOrderStatus:

       

      OrderStatus
      CANCELLED
      DELETED

       

      Desired Output in Fact Table:

       

      Order#AmountOrderStatus
      1100FIRM

       

      After loading the Fact table, I would like to delete records that have certain OrderStatus that are in 'DeleteOrderStatus' table. Using KEEP/INNER JOIN, I was able to include certain records. Is there a way I can exclude certain records based on another table?

       

      Thanks in advance.