SQL Server Analysis Services

 

In planning for this project, there are several issues that need to be addressed. In 250-500 words, answer the questions below so you can plan accordingly to execute the project:

  1. Discuss some of the immediate issues you may encounter when loading the package and matching to the database data.

  1. Explain what a delimiter is with regard to importing data. Include discussion of why a flat file is important.

  1. Considering the database is constantly being updated, discuss some of the possible issues that may be encountered if the manager wants the same extract each month. Discuss the recommendations you would make after analyzing the potential risks. Justify the recommendations with reasons, facts, and examples.
Tags: No tags