Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kalaiselvan
Posting Yak Master
112 Posts |
 Posted - 2013-09-04 : 13:15:25
|
| Hi, Got a Transformed Data using SSIS (Pivot, Unpivot and Aggregrate). Need to Join the Transform Output to Other SQL Tables to get the Destination Data.Ex: TableA (Transformed Output)[Country] [Brand] [Cat] [Month] [Vol] IND PG A JAN12 500 IND PG A FEB12 500 IND PG B JAN12 300 IND PG B FEB12 200 IND ET A JAN12 400 IND ET B FEB12 350 IND ET A JAN12 200 IND ET B FEB12 400Country (ID,NAME) 1-INDMONTH (ID,MONTH) 0112-JAN12, 0212-FEB12Product (ID,Brand,Cat) 101 - PG & A, 102 - PG & B, 103 - ET & A, 104 - ET & BReq.Output: (Joining Above Tables to get the Result with Lookup)[CountryID] [ProdID] [MonthID] [Vol] 1 101 0112 500 1 101 0212 500 1 102 0112 300 1 102 0212 200 1 103 0112 400 1 103 0212 350 1 104 0112 200 1 104 0212 400And Above Output need to compare with Existing Table for Duplicates or for any New ProductsPlease Help me How can I Use the 1st Output in Multiple Lookup and 2nd Output for Compare.Regards,Kalai |
|
|
|
|
|
Multiple Look Up & Source File Compare