I am reverse engineering (Importing) SSIS packages into ER/Studio in order to produce Data Lineage diagrams. Would someone please help me understand the difference between Activity Driven, Source Driven, and Target Driven summary lineage. Specifically, what business problem is addressed by each lineage type? When would you use one over another?
THANKS!
Jim