June 25, 2014 at 7:26 am
I have also looked and not been able to find anything. And although in general I'm a big fan of Ralph Kimball's books, I find it disappointing that he talks about the importance of lineage without making any practical suggestions to go about doing that.
June 26, 2014 at 12:20 pm
Some ETL tools such as Informatica have data lineage built in. To my knowledge, SSIS does not. You'll have to either build on SSIS's auditing features or maybe find a third-party add on.
July 3, 2014 at 3:19 pm
Hi,
Thank you for the replies. Our workflows are made in informatica, but for the lineage info they ask for extra money, so we need to do it ourselves :-).
We will eventually do it step by step and improve it as we go along.
Basically we created a metadata db that will be populated from the informatica workflows.
If I find anything useful, I will post it here, but I'm not very optimist:-).
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply