Guys,
         I have been trying to locate the proper resources in Data Warehousing for SQL Server 2005. I have this question if anyone can help pls.

Q1) I am starting a Project in Data Warehousing Field. I have a relational Database with lots of tables. I need to create a data warehouse/mart from my existing relational database and eventuall create Cube for data analyzation. When I looked at the tutorial at SSAS and SSIS in 2005, I did not find tutorials on how to create fact tables and dimensions from the existing relational data source. In SSAS 2005, tutorial starts up with the AdventureWorksDW and go forward on how to create cubes etc but does not tell me how they created the facts and dimensions from the relational database AdventureWorks. I read that i have to have a UDM and then start from there. Does any one have any good link to resources or suggestion on this issues.

Q1) lets say I have a table in RDBMS called "Employee " and it has a date field called "Hire Date" of datatype smalldatetime. I want to to create a fact table using the Time Dimension table and "Employee" table. How do I create surrogate key and the Fact table, is there a wizard or need to create manually doing the Joins? I saw the sample DB AdventureWorksDW  that come with SQL'05 and wanted to know the steps on how the fact tables were created?

Q3) what schema should I use if I have multiple fact table and multiple Dimensions. Is that SNOWFlake Schema? Any resources on this? All I see in the examples is One fact table and Multiple Dimension, all joining to the same fact table. Any resources or live sample,

Thanks Again!