Question about the surrogate keys.

[Bern]

Hi everybody,

I've got a question about the surrogates keys.
Imagine you receive an unknown ID, and this ID is not in the specify dimension.

Can Data Manager insert this data in the Fact Table, without rejecting the key and then insert this key in the dimension table with a default value and a new surrogate key?

Thanks for your help! :)

[UseCog]

it depends on the version of the data manager. If you are using 8.3 or 8.4, then you can accept those and directly insert into fact table.

~Best regards,
UG

[Bern]

it depends on the version of the data manager. If you are using 8.3 or 8.4, then you can accept those and directly insert into fact table.

~Best regards,
UG

Unfortunatly I use 8.2, so this option seem to be not available. :-\

Thanks again UseCog!
Regards!

[UseCog]

you can derive some logic to do this... I can remember somebody have already answered this question in this forum. Please check

[elealos]

You can write new values to the dim, assign a surrogate and deliver the new surrogate to the fact table on the fly. TO do so you will need a lookup that uses a template as the data source, and you will need to configure on the dimension element "allow unmatched" and "Save unmatched members via reference structure".

[Bern]

You can write new values to the dim, assign a surrogate and deliver the new surrogate to the fact table on the fly. TO do so you will need a lookup that uses a template as the data source, and you will need to configure on the dimension element "allow unmatched" and "Save unmatched members via reference structure".

OK, thanks. So we can do something similar, but it's not inmediate.