What is equivalent of lookup transformation in Diyotta?
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.