in Technology by

What is Lookup transformation?

1 Answer

0 votes
by
  • Lookup transformation is used to look up a source, source qualifier, or target in order to get relevant data.
  • It is used to look up a ‘flat file’, ‘relational table’, ‘view’ or ‘synonym’.
  • Lookup can be configured as Active or Passive as well as Connected or Unconnected transformation. 
  • When the mapping contains the lookup transformation, the integration service queries the lookup data and compares it with lookup input port values. One can use multiple lookup transformations in a mapping.
  • The lookup transformation is created with the following type of ports:
    • Input port (I)
    • Output port (O)
    • Look up Ports (L)
    • Return Port (R)

Related questions

0 votes
    What is meant by Lookup Transformation? Explain the types of Lookup transformation....
asked Mar 27, 2021 in Technology by JackTerrance
0 votes
    Differentiate between joiner and Lookup Transformation....
asked Mar 27, 2021 in Technology by JackTerrance
0 votes
    When do you use SQL override in a lookup transformation?...
asked Mar 26, 2021 in Technology by JackTerrance
0 votes
    What do you mean by lookup transformation?...
asked Dec 28, 2020 in Technology by JackTerrance
0 votes
    What is Lookup change in Informatica?...
asked Jun 7, 2021 in Technology by JackTerrance
0 votes
    What do you understand by the record matching and data lookup features in ServiceNow?...
asked May 24, 2021 in Technology by JackTerrance
0 votes
    Write the Unconnected lookup syntax and how to return more than one column....
asked Mar 29, 2021 in Technology by JackTerrance
0 votes
    What are the types of Caches in lookup? Explain them....
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    State the differences between SQL Override and Lookup Override?...
asked Mar 27, 2021 in Technology by JackTerrance
0 votes
    Name the different lookup cache(s)?...
asked Mar 25, 2021 in Technology by JackTerrance
0 votes
    How many input parameters can exist in an unconnected lookup?...
asked Mar 25, 2021 in Technology by JackTerrance
0 votes
    What are the differences between connected lookup and unconnected lookup?...
asked Mar 25, 2021 in Technology by JackTerrance
0 votes
    What is a “Lookup Relationship” in Salesforce?...
asked Nov 12, 2020 in Technology by JackTerrance
0 votes
    I'm using tweepy to access a large number of tweets. Many tweets are truncated, so I want to get ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 19, 2022 in Education by JackTerrance
0 votes
    My model.py: from django.conf import settings from django.db import models from django.db.models.signals ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 1, 2022 in Education by JackTerrance
...