I have two dimension type 2 scd , A and B. i'm using OWB 11g2
A: A_SK, A_CODE, A_NAME
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 )