Home
Q&A
Education
Technology
Credit
General
Health
Insurance
Questions
Ask a Question
What is Lookup transformation?
Home
Technology
What is Lookup transformation?
asked
Mar 25, 2021
in
Technology
by
JackTerrance
What is Lookup transformation?
interview-question-answer
technology-questions-answers
1
Answer
0
votes
answered
Mar 25, 2021
by
JackTerrance
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
Q: What is meant by Lookup Transformation? Explain the types of Lookup transformation.
What is meant by Lookup Transformation? Explain the types of Lookup transformation....
asked
Mar 27, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: Differentiate between joiner and Lookup Transformation.
Differentiate between joiner and Lookup Transformation....
asked
Mar 27, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: When do you use SQL override in a lookup transformation?
When do you use SQL override in a lookup transformation?...
asked
Mar 26, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: What do you mean by lookup transformation?
What do you mean by lookup transformation?...
asked
Dec 28, 2020
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: What is Lookup change in Informatica?
What is Lookup change in Informatica?...
asked
Jun 7, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: What do you understand by the record matching and data lookup features in ServiceNow?
What do you understand by the record matching and data lookup features in ServiceNow?...
asked
May 24, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: Write the Unconnected lookup syntax and how to return more than one column.
Write the Unconnected lookup syntax and how to return more than one column....
asked
Mar 29, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: What are the types of Caches in lookup? Explain them.
What are the types of Caches in lookup? Explain them....
asked
Mar 28, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: State the differences between SQL Override and Lookup Override?
State the differences between SQL Override and Lookup Override?...
asked
Mar 27, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: Name the different lookup cache(s)?
Name the different lookup cache(s)?...
asked
Mar 25, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: How many input parameters can exist in an unconnected lookup?
How many input parameters can exist in an unconnected lookup?...
asked
Mar 25, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: What are the differences between connected lookup and unconnected lookup?
What are the differences between connected lookup and unconnected lookup?...
asked
Mar 25, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: What is a “Lookup Relationship” in Salesforce?
What is a “Lookup Relationship” in Salesforce?...
asked
Nov 12, 2020
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: Tweepy lookup of extended tweets for multiple tweets at a time?
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
pythonapitwitter
0
votes
Q: Related Field got invalid lookup: title_icontains
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
pythondjangoclassview
...