Web Technologies
Android
Angular
BootStrap
ECMAScript
HTML
Image Processing
JavaScript
MVC
Onsen UI
React JS
SOAP UI
Vue.js
Cloud/DevOps Technologies
Amazon EC2
Ansible
Augmented Reality
AWS
Azure
Big Data
Cache Teachniques
Cassandra
Commercial Insurance
Cloud
CD
CI
Data Handling
Data using R
Data Science
DevOps
Gradle
Hadoop
HBase
HDFS
Hive
IOT
Jenkins
Machine Learning
MangoDB
NGINX
SOAP UI
Latest Technologies
5G Network
Agile
Android
Arduino
Augmented Reality
Commercial Insurance
C#
C++
Cyber Security
Data Handling
Data using R
Data Science
DBMS
Design-Pattern
Fortify
Ethical Hacking
Framework
GIT
GIT Slack
Image Processing
Java
Jenkins
Jira
JUnit
Kibana
Linux
MangoDB
Oracle
PHP
Python
QTP
R Language
Regression Analysis
Robotic
Salesforce
SAP
Selenium
Service Discovery
Service Now
Spark SQL
Testing
TOGAF
Research Method
Virtual Reality
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?
0
votes
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
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
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
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
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
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
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
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
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
+1
vote
Explain sessions and also shed light on how batches are used to combine executions.
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
(
2.6k
points)
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Only positive scenarios are validated in _____ testing
asked
Jan 13, 2020
in
Big Data | Hadoop
by
AdilsonLima
(
5.7k
points)
Bigdata-questions-answers
Hadoop-questions-answers
...