how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
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 |
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
What are cubes and olap cubes?
When do we go for the tools in the market?
Difference between flat files and relational sources?
where we cannot use sorter Transformation. if we use then we will not get correct data?
what is meant by drill through?(Mascot)
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?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
Two default user groups created in the repository are____and_____.
Can there be sub steps of etl steps?
What are the steps involved in etl process?
how do u set partition points in the mapping?