Helper VHi Anonymous Alisa, I read through those documents / articles many times before, but I don't think I see any part clarifying Enrichment step experiencing stale data issue (by joining multiple tables) except advising developer to layering dataflows in phases.
My problem is obviously at the join that some of the joining tables may not passing on updated data, rather stale data cached at certain point of time. This is totally throw me out of water for my calculations all based on the final output which I previously confidently using all fields as updated data.
If only I added the Refresh date in, I found the issue at the root table, but hardly could I explain why think like this happened.
This is the data passed on to enrichment step from linked entity.
And this is the original query, which has new data as much frequent as refresh scheduled.