Joiner Transformation in Informatica Cloud 2024

Welcome to our YouTube channel where we delve into the world of data integration using Informatica Intelligent Cloud Services (IICS). Thanks for watching my channel.
Don't forget to like, share, and subscribe for the latest updates and new releases!"
Please post your questions in comments.

#informaticaiics #informaticaiicstutorial #informaticaiicsforbeginners #informaticaiicsinterviewquestionsandanswers #informaticaiicstraining #informaticaiicsinstallation #informaticaiicstutorialforbeginners #informaticaiicsrestap #informaticaiicsapplicationintegration #informaticaiicsvspowercenter #informaticaiicsfullcourse #informaticaiicsforbeginnerstelugu #informaticaiicsinterview #informaticaiicsand #informaticaiicsdataintegration #informaticaiicsjobs
#informaticaiics
JOINER TRANSFORMATION-
***********************
Joiner transformation is an active and connected transformation. It is used to join data coming from two different data streams based on
the condition and the join type defined in the transformation.

The advantage of joiner transformation is it is able to join data coming from heterogeneous(different sources)

Joiner transformation supports four different types of joins:

1.Normal Join
Includes only rows with matching join conditions. Discards rows that do not match the join conditions.
2.Master Outer
Includes all rows from the Detail pipeline and the matching rows from the Master pipeline. It discards the unmatched rows from the Master pipeline.
3.Detail Outer
Includes all rows from the Master pipeline and the matching rows from the Detail pipeline. It discards the unmatched rows from the Detail pipeline.
4.Full Outer
Includes rows with matching join conditions and all incoming data from the Master pipeline and Detail pipeline.