SCD Type3 KM in ODI
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):
Description (Required):
Currently there is a KM for handling SCD's .It is more aligned towards type 2 dimension rather than type 3 . I think we need to have a separate KM for Type 3 .I understand we do have UDO, UD1 columns . But that needs some tweaking's. So we can think of a separate KM specifically for Type 3. Same goes for data stores where we need to provide the type 3 columns,
Use Case and Business Need (Required):
To load SCD Type3 dimensions .
Tagged:
2