Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Merged Queries not working in Dataflow and Datamart

We have on-premises gateways that are clustered.   We have data from a lot of data sources.  Some of these are large and some small. When we try to do dataflows or datamarts using merged queries, th...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Solution - Get your data into the workspace storage first.  Just get the data, no transformations.  I label these stageTablename.

     

    Make a reference to the stage tables, these will appear with a lightning bolt icon and are called Computed Tables.  Dataflows will stage all of your data before doing anything with Computed Tables.

     

    Do all of your tranformations in the Computed Tables.  Perform merged queries with Computed Tables only.

     

    Dataflows are an ETL tool.  Extract your data, transform it, then load it.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Solution - Get your data into the workspace storage first.  Just get the data, no transformations.  I label these stageTablename.

 

Make a reference to the stage tables, these will appear with a lightning bolt icon and are called Computed Tables.  Dataflows will stage all of your data before doing anything with Computed Tables.

 

Do all of your tranformations in the Computed Tables.  Perform merged queries with Computed Tables only.

 

Dataflows are an ETL tool.  Extract your data, transform it, then load it.