Hi I have created Data model - star schema design from source to staging in visio. Now the requirement is they need documentation about the design so that the DB team would create staging tables. Please let me know what needs to be included in the document?

As per the SDLC model you have to provide the technical document to your team, there is no hard and fast rule for creating the TD but you can include the following points INTRODUCTION ARCHITECTURE Functional Overview Process Flow HIGH LEVEL TECHNICAL SOLUTION & SCOPE TO-BE Scope Assumptions Risks Dependencies Data Model Persistent Table Structures Error Table ETL Error Handling and Restart ability Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

To add to what ETL mentioned you could have a groth planning of data as well.My Blog | Ask Me