Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
- 5 Answers
- 16269 Views
- I also Faced
- E-Mail Answers
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
How to increase performance without changing anything in mapping.( In prod)
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Which transformation we use to convert 'NA' to 'Not Available'
Explain the use lookup tables and Aggregate tables?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
what is session partitioning?
What is staging area referring to?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
explain the methodology of Data Warehousing?(Polaries)
What is data modeling and data mining?
what is the difference between cubes and package in cognos
What is etl process. How many steps etl contains explain with example?
What is etl process? How many steps etl contains?
Difference between flat files and relational sources?
