Post reply

Need pointer with Lookup

  • April 18, 2008 at 9:48 am

    #185561

    Table(A) rate/deduction data for each employee. Each employee has mutiple rows of data. The employee ID is integer column.

    Table(B) list of employee ID

    how do I retreive the list of rows from table(A) based upon the list of employee from table(B)?

    Should I be using lookup transformation or fuzzy lookup transformation? Any advise is appreciated. Thanks.

    Jimmy

  • April 18, 2008 at 10:00 am

    #804469

    If you are trying to get all of the rows from table A for each row in table B, use a merge join.

  • April 18, 2008 at 1:12 pm

    #804561

    Thanks! It works like a charm.

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

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