I am trying to build a data lineage which include column level mappings. It appears that this is possible by using Data Movement Rules. Does this sound correct, and if so, what are the best practices in using them? The wiki documentation give me how to fill out the dialog box to create a Data Movement Rule. I need to know is the how (best practices) and why to use Data Movement Rules.
Thanks in advance for your advice,