June 26, 2005, 12:25 PM
<bobby>slowly changing dimension
we are using release 71 i cant see anything build
in product can u plz be more specific.
thanks,
Bobby
This is from the product manager:
---
The answer to how do we handle type 2 dimensions is that in release 71 it's built into the product. You designate which columns in the table require type 2 handling, and whether to use activation dates or activation flag, and we handle the rest.
---
June 27, 2005, 09:03 AM
<ammy>Hi
Bobby
1)In Target Transformation select 'Key Matching Logic' in Load Type
2)select 'Reject the Records' in If Record Exists
try this may help you
Regards
ammy