how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answer Posted / prasanna
Using lookup is equivalent to outer join on source table.
As Bhavani said, if you want to join 2 heterogeneous
sources you cannot join in SQ. Then you need to use join.
Ex: you have 2 sources. One is a table in a DB and another
is a faltfile then you can only join using joiner.
Adv: you can perform operations similar to inner, left
outer, right outer and full outer. But using a lookup its
equivalent to left outer join on source.
It's always better to join a table which is small in SQ
then creating a lookup on it for better performance
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is abap? What are idocs?
what is dynamic insert?
Can we create Hierarchies in generic datasources?
What is virtual Data Warehousing?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Explain different types of partitioning?
what is the difference between cardinality and Nullability?
what are the facilities provided by data warehouse to analytical users?
What is the difference between Data Warehousing and Data Mining?
Define slowly changing dimensions (SCD)?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
What is the difference between round-robin partitioning and hash partitioning?
What is partitioning? Explain different types of partitioning?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
What is a staging area? What is the purpose of a staging area?