Post reply

Look Ups

  • October 16, 2003 at 9:40 am

    #106531

    I was wondering if anyone uses LookUps.

    If so I would love a high level overview of how they can be effectively used in DTS.

    All examples welcomed.

    Thanks

  • October 16, 2003 at 9:52 am

    #478506

    Here is a quick example of how I use it...

    I have a table called Lookup_Employee with columns Employee Id and Employee Name.

    I read a source DB and before I add the employee to the lookup table I use a lookup saying

    SELECT EMPLOYEE_ID FROM LOOKUP_EMPLOYEE

    WHERE EMPLYEE_ID = ?

    The ? is a variable that I replace.

  • October 16, 2003 at 11:20 am

    #478519

    Thanks for the reply,

    Not quite getting yet how it is used in the DTS.

    From what I understand, and correct me if wrong, Lookups are available while DTSing from a Source to Destination.

    So lets say you are transforming an excel file to table, how is the lookup helpful?

    Thanks

  • October 16, 2003 at 5:18 pm

    #478560

    Lookups in DTS are often used to add, or replace, data to the import process.

    For example, you get a list of products with new prices.

    The source data has,

    ProductName, NewPrice

    Your price table has

    ProductID, Price

    You would have a lookup that used the ProductName to retrieve the relevant ProductID to insert into the price table.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • October 20, 2003 at 3:25 pm

    #478873

    Yes that does help.

    Do you know of any good reading sources on practical applications using Lookups?

  • October 20, 2003 at 6:23 pm

    #478883

    There's not much in the way of practical use of Lookups. Generally, data is imported into a staging table and fields updated as appropriate using a stored procedure. This is a much more efficient method than using lookups. You get maximum throughput in your import, and you can update the whole table in one statement, rather than executing a lookup for each row you're importing.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

Viewing 6 posts - 1 through 5 (of 5 total)

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