Sparse Snapshot Loading
I was able to load data based on changed date I.e if any change occurred between yesterday and today by using below statement in Update query
UpdateDate - datatype is DateTime
this method is working only for daily loads and not Intra day loads (intra day loads factors in time as well).
? ->considers only dates and not time ?? if so then how should we address this issue