Thursday, September 30, 2021

ODI - Expression component

An expression is a selector component that inherits attributes from a preceding component in the flow and adds additional resuabale attributes. Attributes can be renamed and transformed from source attributes using SQL expressions.

The best use of an expression component is in cases where intermediate transformations are used multiple times such as when pre-calculating fields that are used in multiple targets.

Use case: 

  1. First use a filter on Regions table(where Region_id ='4' )
  2.  and then join them between countries and Regions based on join condition(countries.region_id =regions.region_id)
  3.  and then connect the join with an expression component which inherits all fields from countries and regions tables. 
  4. Now we will use a subquery filter component with expression and locations tables based on conditon  - Expression.country_id =Locations.country_id. 
  5. And then use the subquery result to target table Locations_EXP.

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...