APPEND and REPLACE
Hi,
How dataset APPEND, REPLACE and ETL(Update Method only new rows) work internally? Does DOMO create a unique key internally and only update the modified or newly entered records from source?
Suppose, we have some trillions of data in SFMC(salesforce marketing cloud). First, I will create a app cloud connector to SFMC. Now, what is the best approach to have this working? Which will work faster way with no performance issue? If I schedule it to run on daily basis, as per my knowledge, APPEND will cause duplicates , REPLACE will completely truncate the dataset and reload it all over again, which will be time taking approach, and creating ETL(only new rows), will work for only dataflow, dataset still have all appended data? Please advise, for better performance how internally DOMO works, what would be the best option for million and trilions of data from SFMC.
Thanks,
Neeti
Comments
-
Try reviewing some of the suggestions in this documentation:
https://knowledge.domo.com/Administer/Implementing_Single_Sign-On/Enabling_SSO_with_Salesforce.com
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 703 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive