Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
What are the types of lookup transformation?
Home
Big Data | Hadoop
What are the types of lookup transformation?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
(
2.6k
points)
What are the types of lookup transformation?
Bigdata-questions-answers
Hadoop-questions-answers
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Mar 10, 2020
by
Hodge
(
2.6k
points)
There are four different types of lookup transformation:
Relational or flat file lookup
: It performs lookup on relational tables.
Pipeline lookup
: It performs lookup on application sources.
Connected or unconnected lookup
: While the connected lookup transformation receives data from source, performs lookup, and returns the result to the pipeline, the unconnected lookup happens when the source is not connected. It returns one column to the calling transformation.
Cached or uncached lookup
: Lookup transformation can be configured to cache lookup data, or we can directly query the lookup source every time a lookup is invoked.
Related questions
+1
vote
Q: Differentiate between Joiner and Lookup transformations.
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
(
2.6k
points)
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: What can we do to improve the performance of Informatica Aggregator Transformation?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
(
2.6k
points)
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: Define OLAP. What are the different types of OLAP?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
(
2.6k
points)
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: To see the data types details of only a column notthetable we should use the command
asked
Apr 3, 2020
in
Big Data | Hadoop
by
Tate
(
883
points)
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: Differentiate between various types of schemas in data warehousing.
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
(
2.6k
points)
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: What are the advantages of Informatica?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
(
2.6k
points)
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: What are the advantages of using Informatica as an ETL tool over Teradata?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
(
2.6k
points)
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: What are the features of Informatica Developer 9.1.0?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
(
2.6k
points)
Bigdata-questions-answers
Hadoop-questions-answers
...