• From your sample tables you don't really have a star schema. If possibly you should denormalise your dimension as much as posssible, not split them off into snowflakes

    You need to explain your problem - "I am unable to load my fact table using the LookUp function" - why?

    Normally you get the source system data with source system keys, load it into a staging table, then personally I don't use SSIS lookups, I use a bulk update to set the surrogate keys then load it into the fact.

    Have you read the Kimball Books or the microsoft data warehousing books? Thes concepts come from books, not from technical articles (MSDN, BOL)