0 Replies Latest reply: Oct 27, 2012 1:53 PM by 954734 RSS

    How to automatically recognize active record in Type 2 SCD ?

    954734
      I have two dimension type 2 scd , A and B. i'm using OWB 11g2
      A: A_SK, A_CODE, A_NAME
      B: B_SK,B_CODE,B_NAME,A_SK,A_CODE

      i connect A_SK attribute (dim A) to A_SK attribute (dim B).
      Then, i change A_NAME attribute (record 1) ( dim A) , run ETL dim A, so dim A generated a new version of record 1.
      Next, i do ETL dim B, but i didn't see anythings changed in dim B.
      I know that To extract the current version of a record, set the "Type 2 Extract/Remove Current Only" property of the Dimension operator to Yes. To extract all records, including historic ones, set the "Type 2 Extract/Remove Current Only" property to No.. I did both two but result was same.
      I try to filter based on "EXP_DATE is null" so I got new version of a record in dim B ( It was my expected result )

      Maybe Type 2 Extract/Remove Current Only isn't working ? can you help me get new version of a record in dim B without filter ( automatically recognize active record from dim A to dim B )