Re: Dynamic key while joining tables? or any other solution?
Thankyou for your reply Jonathan,
As i understand , in this case we are replacing the Old IDs with New IDs matching the valid from and upto from update table , but my old ids need to stay in the table(in the ID column) since ID is joined to other facts or dimensions accordingly.
Is there any way wherein i can have both columns OLD ID and NEW ID in the fact and join the dimension using a logic?