1 / 8

Joiner Transformation PPT

Visualpath is the best Informatica Cloud Online Training Institute in Ameerpet. We are providing Online & Classroom Training classes by real-time faculty with real time Projects. Informatica Cloud Training Online. You will get the best course at an affordable cost. Call on - 91-9989971070.

navyateja1
Download Presentation

Joiner Transformation PPT

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Joiner Transformation +91-9989971070 www.visualpath.in

  2. Joiner transformation is an active and connected transformation. It provides the option of creating joins in the Informatica. By using the joiner transformation, the created joins are similar to the joins in databases. • The two input pipelines include a master and a detail pipeline. We need to join the output of the joiner transformation with another source to join more than two sources. And to join n number of sources in mapping, we need n-1 joiner transformations. www.visualpath.in

  3. In joiner transformation, there are two sources which we are using for joins, such as: • Master Source • Detail Source • In the properties of joiner transformation, we can select which data source can be a Master source and which source can be a detail source. www.visualpath.in

  4. Types of Joins • In Informatica, the following joins can be created using joiner transformation, such as: • Master outer joinIn Master outer join, all records from the Detail source are returned by the join, and only matching rows from the master source are returned. www.visualpath.in

  5. Detail outer joinIn detail outer join, only matching rows are returned from the detail source, and all rows from the master source are returned. • Full outer join.In full outer join, all records from both the sources are returned. Master outer and Detail outer joins are equivalent to left outer joins in SQL. • Normal joinIn normal join, only matching rows are returned from both the sources. www.visualpath.in

  6. Blocking Transformation • The joiner Transformation is called as the blocking transformation. • The integration service blocks and unblocks the source data depending on whether the joiner transformation is configured for sorted input or not. www.visualpath.in

  7. CONTACT For More Information About Informatica Cloud Online Training Address:- Flat no: 205, 2nd Floor, Nilgiri Block, Aditya Enclave, Ameerpet, Hyderabad-16 Ph. No : +91-9989971070 Visit : www.visualpath.in E-Mail : online@visualpath.in

  8. THANK YOU Visit: www.visualpath.in

More Related