Thursday, December 27, 2012

Lookup Transformation

Explain about Lookup Transformation

Lookup Transformation is a passive transformation which allows you to perform look up on relational table, flat files, synonyms and views
When a mapping contains a Lookup Transformation the integration service queries the look up data and compares it with look up input port values

The Lookup Transformation is created with the following ports

1. Input port (I)
2. Output port (O)
3. Lookup port (L)
4. Return port (R)

The Lookup Transformation supports horizontal  merging such as equi-join and non equi-join
Use Lookup Transformation to perform following tasks
       Get a related value 
       In updating Slowly Changing Dimension (SCD)


Connected and Unconnected Lookup will be discussed later




16 comments:

  1. I read this post two times, I like it so much, please try to keep posting & Let me introduce other material that may be good for our community.

    Devops training in Chennai
    Devops training in Bangalore
    Devops Online training
    Devops training in Pune

    ReplyDelete
  2. I simply wanted to thank you so much again. I am not sure the things that I might have gone through without the type of hints revealed by you regarding that situation.
    fire and safety courses in chennai

    ReplyDelete

  3. Hello! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us useful information to work on. You have done an outstanding job.

    AWS Online Training | Online AWS Certification Course - Gangboard
    AWS Training in Chennai | AWS Training Institute in Chennai Velachery, Tambaram, OMR
    AWS Training in Bangalore |Best AWS Training Institute in BTM ,Marathahalli

    ReplyDelete
  4. Nice tutorial. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated tutorials…
    python training in chennai
    python training in Bangalore
    Python training institute in chennai

    ReplyDelete
  5. Casinos near me - MapyRO
    Best Casinos near me - 2021 MapyRO. 여주 출장마사지 Casino. Casino. Casino. 동두천 출장안마 Hotel. Hotel. Fun and 보령 출장샵 friendly 양주 출장샵 city centre. Casino. Resort. Casino. Hotels. Rating: 8.1/10 · 충청북도 출장샵 ‎5 votes

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...