InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 08:47:36 GMT20http://www.sqlservercentral.com/Forums/Topic1423884-363-1.aspxIt is quite similar to what we are using now but I can certainly pick up some bits from this and put it in our template.Looks like excel is the tool for this! I was hoping there would be some other tool custom built for this. Thanks for the info.Wed, 27 Feb 2013 21:44:37 GMTchess-288252http://www.sqlservercentral.com/Forums/Topic1423884-363-1.aspx[quote][b]chess-288252 (2/25/2013)[/b][hr]Hi,I was wondering what do you guys use to map the data flow in ETL. I am looking at the field level flow of data. By this, I mean a document that can be passed on to the ETL developers which maps source table.column to destination table.column and the transformation logic between source and destination. This is also handy on the reporting side to map out the fields and logic in report. Currently we use a mix of excel and word to map this. I was wondering whether there is a better way/tool to do this?[/quote]On Ralph Kimball's website, there is a MS Excel spreadsheet under the tools/resources for the 'Microsoft Data Warehouse Toolkit' book that we use. It's probably pretty similar to what you've developed.[url]http://www.kimballgroup.com/wp-content/uploads/2012/07/Ch02_MDWToolkit_Datamodel_Spreadsheet_4.0_2008R2.zip[/url]HTH,RobWed, 27 Feb 2013 14:54:38 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1423884-363-1.aspxHi,I was wondering what do you guys use to map the data flow in ETL. I am looking at the field level flow of data. By this, I mean a document that can be passed on to the ETL developers which maps source table.column to destination table.column and the transformation logic between source and destination. This is also handy on the reporting side to map out the fields and logic in report. Currently we use a mix of excel and word to map this. I was wondering whether there is a better way/tool to do this? Thanks in advance :-)Mon, 25 Feb 2013 23:09:14 GMTchess-288252