explain joiner transformation? Difference between connected and unconnected transformations.

Joiner transformation joins two related heterogeneous sources residing in different locations or files.

--What are the types of joins in joiner in the joiner transformation?

Normal

Master outer

Detail outer

Full outer

Difference between connected and unconnected transformations.

*   Connected transformation is connected to another transformation with in a mapping.

* Unconnected transformation is not connected to any transformation with in a mapping.