top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

When we go for unconnected lookup transformation? and why?

+1 vote
284 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 Google+ Share Button LinkedIn Share Button Multiple Social 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
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...