Wednesday, September 29, 2021

ODI - sets conponent - Union operarion

A set component is a projector component that combines multiple input flows into one using set operation such as Union, Intersect, except, Minus and others.

Use case: We will same 2 Location tables as source tables and then use a filter on them and then union and store to Target table.

Steps:

Step1: Drag and drop 2 same locations table and 2 filters and define the filter conditions.



Step2: Drag and drop a set component from the component palette into the logical diagram.


Step3: Drag and drop Target table and connect the set to the target. In the properry inspector, select the Operators tab and select cells in the operator column to choose the appropriate set operators. UNION is choosen by default.



No comments:

Post a Comment

Featured Post

OIC - How to Retrieve Email Attachments Using Microsoft Graph API: Automating Payment File Processing

Retrieving Email Attachments Using Microsoft Graph API: Automating Payment File Storage in Object Storage Use Case: A finance team needs t...