distribution (planning function)
after execute a distribution (planning function), the reference data must be automatically deleted? because i m executing this distribution function, which register new rows but it does not delete the rows used as reference.
is that the way it works? would be I missing something?
In general, the reference data is not deleted.
When we use distribute by keys, we need to explicitly specify the ratio for the distribution.
Distribution by reference is one step ahead, wherein, we need not specify any ratio explicitly. Instead, we specify some reference data. The system automatically calculates the ratio from the reference data and uses it for doing the distribution.
Please award points if helpful.