I am converting an ETL tool design logic into Diyotta. I have a lookup transformation in the flow. What equivalent transformation I use in Diyotta for this. An example will be really helpful.
Equivalent to look up transformation in Diyotta is Joiner transformation.
Suppose say, we have a table called “Supplier” in Teradata and we are trying to look up for a value in “Store” table of Oracle.
I am trying to join both the tables based on the “SUPPLIER_ID” field as below
Here it looks for the SUPPLIER_ID in the secondary table and loads result into target.