150 likes | 260 Vues
Explore the appropriate logic for data operations, determine the volume of data to process, and select the best app for the task. Consider where the application should run and configuration options.
E N D
Operations What logic should be applied to the data? Volume How much data must be processed? Which app is best suited to these operations on this volume of data? For example, use SQL Server or SSIS for sorting data? Application Where should the app run? For example, on a shared server, or on a standalone machine? Location
Text file on Server 1 SQL Server on Server 2
Text file on Server 1 SQL Server on Server 2 Consider the following configuration … Where should SSIS run? (Licensing issues aside)