in Technology by

What is meant by Lookup Transformation? Explain the types of Lookup transformation.

1 Answer

0 votes
by

Lookup transformation in a mapping is used to look up data in a flat file, relational table, view, or synonym. We can also create a lookup definition from a source qualifier.

We have the following types of Lookup.

  • Relational or flat file lookup. To perform a lookup on a flat file or a relational table.
  • Pipeline lookup. To perform a lookup on application sources such as JMS or MSMQ.
  • Connected or unconnected lookup.
    • A connected Lookup transformation receives source data, performs a lookup, and returns data to the pipeline.
    • An unconnected Lookup transformation is not connected to a source or target. A transformation in the pipeline calls the Lookup transformation with a: LKP expression. The unconnected Lookup transformation returns one column to the calling transformation.
  • Cached or un-cached lookup.We can configure the lookup transformation to Cache the lookup data or directly query the lookup source every time the lookup is invoked. If the Lookup source is Flat file, the lookup is always cached.

Related questions

0 votes
    What do you mean by lookup transformation?...
asked Dec 28, 2020 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 is Lookup transformation?...
asked Mar 25, 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
    a. State the number of bytes occupied by char and int data types. b. Differentiate between = and == ... implicit type conversion. Select the correct answer from above options...
asked Dec 6, 2021 in Education by JackTerrance
0 votes
    a. State the number of bytes occupied by char and int data types. b. Differentiate between = and == ... implicit type conversion. Select the correct answer from above options...
asked Dec 5, 2021 in Education by JackTerrance
0 votes
    a. State the number of bytes occupied by char and int data types. b. Differentiate between = and == ... implicit type conversion. Select the correct answer from above options...
asked Nov 26, 2021 in Education by JackTerrance
0 votes
    What Is Meant By Insulation Voltage In Cables? Explain It?...
asked Dec 12, 2020 in Technology by JackTerrance
0 votes
    What is meant by representation? Explain the various methods of representation? (a) Meaning (b) Electoral (c) Non-electoral (d) Non-official Please answer the above question....
asked Aug 4, 2022 in Education by JackTerrance
0 votes
    What are the types of groups in router transformation?...
asked Mar 26, 2021 in Technology by JackTerrance
0 votes
    What are the various types of transformation?...
asked Mar 26, 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
    In the context of Ansible, what is meant by “facts”?...
asked Jan 28, 2023 in Technology by JackTerrance
0 votes
    What is meant by Ad-Hoc commands? Give one example....
asked Jan 28, 2023 in Technology by JackTerrance
...