Discussion Post: SQL Server Analysis Services
In planning for this project, there are several issues that need to be addressed. In 250 to 500 words, answer the questions below so you can plan accordingly to execute the project:
• Discuss some of the immediate issues you may encounter when loading the package and matching to the database data.
• Explain what a delimiter is with regard to importing data. Include discussion of why a flat file is important.
• 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.
The response must include a reference list. Using one-inch margins, double-space, Times New Roman 12 pnt font and APA style of writing and citations.