I find that a good source-to-target mapping document, along with comprehensive technical documentation and well thought-out comments in the code (I prefer stored procs over SSIS components) goes a long way.
Hi Martin,
a good source-to-target mapping sounds like that I'm searching for.
Our system runs since 2011. Addional Data Marts/Cubes and have been implemented by different developers. We have measures and attributes in different Data Marts which are logical the same objects but different in datatype, length and naming. I think, the best way to get an overview and document to prevent such differences in future is such like a source-to-target mapping.
But, I don't know how to Start. Do you know a tool or strategie? -> except for scanning all SSIS-packages manually 😉
Thanks & kind Regards
Henning