• Ask a Question
  • Create a Poll
150
Insert Image Size must be less than < 5MB.
    Ask a Question
    Cancel
    150
    More answer You can create 5 answer(s).
      Ask a Poll
      Cancel
      Beginner

      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.

      Asked by pluis on July 24, 2019 in Diyotta Studio.
      1 Answers
      Expert

      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.

      Answered by Yagnika Sanagala on July 31, 2019..