This content has been marked as final. Show 1 reply
First design the data model for your document taking into account the field names and tables, and specify the fact table(s) and dimensions.
Then load from each source in turn:
- set the connection string for the first source using CONNECT
- load the data from this source, organised per your analysis.
- connect to the second source (this automatically disconnects the first)
- load the data from this source
- and so on for all your sources ...
- perform any final transformations etc