June 2, 2008 at 1:37 pm
Hi,
Here is the task.....I know it is quite difficult to read and understand such a large post with different tables and relations....But I ve no other option....Please suggest me the best way to implement this...any help would be appreciated...Thanks in advance...
My task is to create and populate a table called :
-tblActivity(datetime, transactionid, groupsid, officesid, usersid, accountnumber, locationcode, lowvolume)
From the below tables--
-tblActivityapril(eventcode, usernid, referralnid, providernid, patientnid)
(*We can take Usernid from above table to compare and extract data from the other tables*).
-tblUserDimension (usersid,usernid,officenid,roleid,user_oid,firstname,lastname)
(*From usernid we ll get usersid, officenid*)
-tblOfficeDimension(officesid,officenid,groupnid,name,address,zip,phone)
(*from officenid we ll get officesid,groupnid*)
-tblMHSOffice(serviceOID,OfficeNID,accountnumber,lowvolume,locationcode,transactionid)
-tblGroupDimension(groupsid, groupnid,groupstatusid,name,address,zip,phone)
June 2, 2008 at 11:55 pm
Hey,
I dont quite understand what the problem is?
You want to populate the destination table with a bunch of sources. Merge join would suffice. Lookups will suffice as well.
Depends on what you want to do in between that will determine which one of the two will work for you...
Merge join is the same as doing a join on the RDBMS, but now you do it in SSIS. You can do inner, left, right, full outer.
The nice thing about lookups is that you can work with the error stream, and define that rows not matching go to a rejection table or something.
The proviso is that you know what your left table is.
Good luck!
~PD
June 3, 2008 at 3:43 am
Thanks a lot...you almost gave me the solution...I would try using merge join...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply