Why can't you update the correct value in DimDimension table.
You said you want only row number 2.You did not give any business logic on how to get it.
If the given data is all the data you have then you can add a filter in where condition saying where dimkey=2
or
If you don't want to update the data and use the filter for dimkey...
do you have any logic to filter the data for dimkey=2.like ordering the rows by certain date?
Vinay Valeti| If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer
No comments:
Post a Comment