What is Lookup transformation?



  • 2 Answer(s)

      • It is a type of transformation that is used to get the relevant data by looking up the source qualifier or by the target.
      • The lookup transformation is used to look up the data present in flat files,relational tables and views.

      • There are various types of ports that are used for creating lookup transformation,there are

    • Input port
    • Output port
      Lookup ports
    • Return ports

        Curing configure dynamic caching, the Informatica Server inserts rows into the cache.

    Answered on November 13, 2018.
    Add Comment

    Lookup transformation is a passive transformation used to look up a source, source qualifier, or target to get the relevant data. Basically, it’s a kind of join operation in which one of the joining tables is the source data, and the other joining table is the lookup table.

    Answered on February 22, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.