I have a current dataflow that is recursive. I want to make sure the company records that are being snapshotted are.
I am planning to use a field "Snapshot Date" which is the current date timestamp on the recursive.
How would I go about assuring the companies are being snapshotted daily in the ETL? Would I need to match back the final dataflow to the original recursive? Any guidance here would be amazing :)