Recently, i got a simple requirement with following detail.
1. I am have two excel files(Each Excel file is having three Sheets)
i.e Excel 1---> Sheets --> 1.Company( CID,CNAME)
2.Product(PID,PNAME)
3.Sales (SID,PID,Sales,Date)
Excel 2---> Sheets --> 1.Company( CID,CNAME)
2.Product(PID,PNAME)
3.Sales (SID,PID,Sales,Date)
2. Based on the above sources we need to create Fact and Dimention Tables in SQLSERVER DB and load the source date into this tables by using SSIS.
Can any one have idea to achieve above requirement.