What is the use of a Lookup transformation

Question

Mageshwaran R · Answer

Hi Mahra, https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/lookup-transformation#:~:text=For%20example%2C%20the%20Lookup%20transformation,be%20added%20to%20new%20columns.

Ben Martin · Answer

The Lookup transformation is used to look up a source, source qualifier, or target to get the relevant data. You can look up the flat file and relational tables. The Lookup transformation in Informatica works on similar lines as the joiner, with a few differences. For example, lookup does not require two sources. Lookup transformations can be connected and unconnected. They extract the data from the lookup table or file based on the lookup condition. The lookup transformation is created with following type of ports Input port (I) Output port (O) Look up Ports (L) Return Port (R) The lookup transformation supports horizontal merging such as equijoin and nonequijoin. I hope this is helpful Ben Martin

Guest User · Answer

Query change is utilized for performing queries by joining information in input segments with segments in the reference dataset. The reference table can be another table or a current table, see, or the SQL result inquiry result.

What is the use of a Lookup transformation

Answers (3)