SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:09 PM
| ||||
| ||||
 Is there any helpful tool could manage data movement? hi! I join a datawarehouse project which already run in 2 years. There is few document left,so I can't see the whole picture of the project and data movement. Now I've tried to trace these data movement and keep it in record. I wonder if there is a helpful tool could manage these data movement. My project use MS SQL 2005. need some suggestion. thanks a lot!      |
|
02-27-2008, 07:09 PM
| |||
| |||
| Re: Is there any helpful tool could manage data movement? Something like Visio diagrams does the trick. It is suggested you visually diagram out all your ETL packages - so it can help you visualize your data movement and help with actual design of the ETL packages. Sounds like this process would help get you what you want albeit it's after the project instead of early on in development. "YesGoGoGo" <YesGoGoGo@gmail.com> wrote in message news:1190266996.803505.306990@i38g2000prf.googlegr oups.com... > hi! > I join a datawarehouse project which already run in 2 years. > There is few document left,so I can't see the whole picture of the > project and data movement. > Now I've tried to trace these data movement and keep it in record. > I wonder if there is a helpful tool could manage these data movement. > > My project use MS SQL 2005. > > need some suggestion. > thanks a lot! > |
|
02-27-2008, 07:09 PM
| |||
| |||
| Re: Is there any helpful tool could manage data movement? but Visio can't generate the file from a package himself. so you just move the problem... or if it can do this... I'm interesting in the how to do this. I recommend to take a look at the BI metada sample toolkit http://www.microsoft.com/downloads/d...displaylang=en this tool scan the packages and generate a metadata which can be used for documentation and impact analysis purpose. "Joe" <hortoristic@gmail.dot.com> wrote in message news:98A1A621-8D7E-417D-A4CF-F224B6D015FD@microsoft.com... > Something like Visio diagrams does the trick. > > It is suggested you visually diagram out all your ETL packages - so it can > help you visualize your data movement and help with actual design of the > ETL packages. > > Sounds like this process would help get you what you want albeit it's > after the project instead of early on in development. > > "YesGoGoGo" <YesGoGoGo@gmail.com> wrote in message > news:1190266996.803505.306990@i38g2000prf.googlegr oups.com... >> hi! >> I join a datawarehouse project which already run in 2 years. >> There is few document left,so I can't see the whole picture of the >> project and data movement. >> Now I've tried to trace these data movement and keep it in record. >> I wonder if there is a helpful tool could manage these data movement. >> >> My project use MS SQL 2005. >> >> need some suggestion. >> thanks a lot! >> > |
|
02-27-2008, 07:09 PM
| ||||
| ||||
| Re: Is there any helpful tool could manage data movement? Check ou the tools section on this link too - they are free. http://www.u2u.net/res/SQL05_BI.aspx#Tools * Analysis Services Documenter is a tool developed by U2U, which generates documentation for an Analysis Services 2005 Database. It renders an HTML page which describes data sources, data source views, dimensions and cubes. * Analysis Services Best Practise Analyser checks your live OLAP databases against some key Best practises. Currently, it checks for aggregations, attribute relationships and non-empty behavior on calculations. "Jeje" <willgart@hotmail.com> wrote in message news:18C5AA1E-89FA-4B93-B2B2-CCB737F129CF@microsoft.com... > but Visio can't generate the file from a package himself. > so you just move the problem... > or if it can do this... I'm interesting in the how to do this. > > I recommend to take a look at the BI metada sample toolkit > > http://www.microsoft.com/downloads/d...displaylang=en > > this tool scan the packages and generate a metadata which can be used for > documentation and impact analysis purpose. > > > "Joe" <hortoristic@gmail.dot.com> wrote in message > news:98A1A621-8D7E-417D-A4CF-F224B6D015FD@microsoft.com... >> Something like Visio diagrams does the trick. >> >> It is suggested you visually diagram out all your ETL packages - so it >> can help you visualize your data movement and help with actual design of >> the ETL packages. >> >> Sounds like this process would help get you what you want albeit it's >> after the project instead of early on in development. >> >> "YesGoGoGo" <YesGoGoGo@gmail.com> wrote in message >> news:1190266996.803505.306990@i38g2000prf.googlegr oups.com... >>> hi! >>> I join a datawarehouse project which already run in 2 years. >>> There is few document left,so I can't see the whole picture of the >>> project and data movement. >>> Now I've tried to trace these data movement and keep it in record. >>> I wonder if there is a helpful tool could manage these data movement. >>> >>> My project use MS SQL 2005. >>> >>> need some suggestion. >>> thanks a lot! >>> >> |
Linear Mode
