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
- 16334 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / k bhavani durga
this can be used to join two sources coming from two
different locations or from the same locayion.for this
there mist be atleast one matching port and it is must to
specify one source as master and the other as detail.
it supports the following types of joins
1.normal
2.master outer
3.detail outer
4.full outer
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
Answer / k.rameshyadav
Lookup T/R is always is an alternate for joiner.
If the sources are same i.e homogenous we can perform join at database level.
| Is This Answer Correct ? | 1 Yes | 1 No |
What do you understand by active and passive transformations?
Explain about the data integration suite features?
Explain different types of partitioning?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
What are three tier systems in etl?
how would u estimate the size of Aggregator transform data and index cache?
What is data cleaning?
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
What is tracing level?
what are the different Reporting and ETL tools available in the market?
what happens if the info.server doesn't find the session parameter in the parameter file?
how do u set the size of block buffer?
Teradata 
