Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a doubt on synthetic keys, that is - what kind of scenario we can keep Synthetic keys in our Data model.
Thank you.
did you read this?
If you use an INTERVAL MATCH it will create a synthetic key which you will have to keep.
If you get synthetic keys due to source tables you should definitely resolve them into bridge tables/link tables so you verify the need for them for yourself and others. It gives you the opportunity to put sensible field names on the generated synthetic fields also - which is important.