RE: How do we join two tables and load data into a target in Diyotta?

How do we join two tables and load data into a target in Diyotta?

WilliamS Beginner Asked on July 15, 2019 in Connectors.
Add Comment
2 Answers

We can join two or more tables in Diyotta through Joiner transformation. We should create a dataflow under generic or any native databases for which we are licensed and Drag the source tables into the data flow. Add the joiner transform which is available in the Transforms tab.

RE: How do we join two tables and load data into a target in Diyotta?

Mention the condition in the properties tab of the joiner transform. Joiner type has a drop down, in which we can select the type of join we would like to perform.

RE: How do we join two tables and load data into a target in Diyotta?

Add the required attributes in the Attributes tab as below

RE: How do we join two tables and load data into a target in Diyotta?

Create target from the joiner with the attributes added and execute the dataflow. Based on the given condition tables will be joined and loaded into target.

Expert Answered on July 15, 2019.
Add Comment

Your Answer

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