In addition to Load Date Time in satellites, do we really need to have Load End Date Time as well to sunset the old record when the new record comes in.
This is different from the business start and end date.
Please share your valuable suggestions.
You dont need that. The new record gets a later loaddate, this means that the old row is inactive from that time.
Thanks for your response.
In case of a search involving two load dates using between clause, having load end date may help to avoid searching all other records.
Is there any way to tackle this situation?
Yes, create an index on bk and include the loaddate. After that you can write queries that fetches max ld per bk very fast. Use that query as an inner query and then join back to the satellite table on bk and ld.