merge join

  • I would like to create a teacher extract file. The teacher table is in Oralce database.

    it has teacher firstname, lastname, id, loginID.

    But the loginID only populated for some of the teachers.

    so we would like to join a SQlserver table that also have teacher firstname, last name, initials and networkid.

    The only thing we can do is to join firstname and last name and some initials to get the teacher networkID.

    because the two source tables they don't have other keys to join.

    What I prefer is if oracle table loginID is not null then use loginID as networkID, but if it is null then join

    the two sources by using last name and first name. and using left join, for I would like to keep all the records in the oralce source.

    Is that possible to do this using merge join?

    Also when I use left join, I mean both firstname and last name match then get the networkID, I don't want if only one of the two matches then get the networkID, is that merge join doing?

    Whenver I use merge join, I feel it is not flexible.

    Thanks,

  • I would probably use the merge join to pull all the records into a staging table and then do additional manipulations via creating a view, etc.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply