top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

When we go for unconnected lookup transformation? and why?

+1 vote
666 views
When we go for unconnected lookup transformation? and why?
posted Sep 1, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

If u want to use the same look up T/R more than one time,you should use compulsory Unconnected lookup.A common use for unconnected Lookup transformations is to update slowly changing dimension tables.I know these 2 uses.

OR

  1. Calling the same lookup multiple times in one mapping

  2. Testing the results of a lookup in an expression

  3. Filtering rows based on the lookup results

  4. Marking rows for update based on the result of a lookup,
    such as updating slowly changing dimension tables

answer Sep 2, 2015 by Manikandan J
...