Using DataFlow, what is the difference between adding Transforms and adding Output DataSets?

user05850
user05850 Member
in Magic ETL

I am new to MySQL DataFLow in Domo. Can someone explain the difference between Transforms and Output DataSets, and when to use each one?

 

Thanks!

Best Answers

  • user05850
    user05850 Member
    Answer ✓

    Thanks for the reply! Would you happen to know of any pages or documents specifically around MySQL dataflow transforms?

  • AS
    AS Coach
    Answer ✓

    Yep, try http://knowledge.domo.com?cid=sqldataflows.

     

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • AS
    AS Coach

    Hi!

    When you have a process that will take multiple steps, each transform takes care of those steps, then you have an output dataset at the end which results in a new dataset in your data center.  The transforms are only steps to get you to that final point.

    In theory, you could write a query with a bunch of subqueries within it instead of transforms.  That's harder to manage and administer, though, so it's not recommended.

     

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • user05850
    user05850 Member
    Answer ✓

    Thanks for the reply! Would you happen to know of any pages or documents specifically around MySQL dataflow transforms?

  • AS
    AS Coach
    Answer ✓

    Yep, try http://knowledge.domo.com?cid=sqldataflows.

     

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories