Several different factors need to be considered when choosing the best type of load table to use:

  • Source and target database types
  • Locations of source and target databases
  • Available connectivity options and performance
  • Amount of data being loaded
  • Is the data delivered or fetched?
  • For delivered data, what format is it in and does it require processing to make it loadable?

Load Table Decision Tree
The following decision tree can be used when selecting the best type of load table:

 

  • No labels