There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?

1

Resolved

Inferred Dimension Members Being Deleted

description

I have a situation that causes some dimension row to arrive quite late. My fact table load handles these situations by loading an inferred member dimension. I have an inferred member identifier that is indicated in the kscd. The problem I am having is
that if the dimension load runs after the inferred member row is created before the actual dimension member arrives, the kscd sends the row to the deleted output because there is no match from the source system. Any ideas on how to handle this?

file attachments

No files are attached

Closed
by

comments

I believe I have found the issue - my inferred member indicator is a bit and it looks like the kscd inferred member only supports integer types. I have changed my inferred member to an int and we are in business!

I've confirmed this is a bug. The only way you could possibly mitigate it until I fix is by monkeying with the Data Flow outside of the KSCD. Perhaps with a Conditional Split on the Deleted to filter out Inferred members.