RE: What is equivalent of lookup transformation in Diyotta?

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.

pluis Beginner Asked on July 24, 2019 in Diyotta Studio.
Add Comment
1 Answers

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.

RE: What is equivalent of lookup transformation in Diyotta?

I am trying to join both the tables based on the “SUPPLIER_ID” field as below

RE: What is equivalent of lookup transformation in Diyotta?

Here it looks for the SUPPLIER_ID in the secondary table and loads result into target.

Expert Answered on July 31, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.