The purpose of this is to become familiar with the fundamentals of SQL Server An

Question

The purpose of this is to become familiar with the fundamentals of SQL Server Analysis Services (SSAS).

The regional sales manager has asked you demonstrate your knowledge of importing a custom Excel report based on preferred clients into the database using SSAS. He has also requested an exported data table after attaching updated sales figures to his data, and he would like you to demonstrate your export skills. The manager has asked you schedule a meeting to present a quick import/export demo.

Part 1:

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.

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

3 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.

Explanation / Answer

1.Define your own view, and make whatever changes are needed in them. This affects its basic schema which will not get updated in the database. So refresh the view to update the changes in the underlying database.

In the view, you can modify or remove tables,columns,rows and can also add your new rows and columns to existing tables as tables cannot be created in a a view.

It is better to define a view that requires a SQL query to retrieve data fast.

Have to build proper hierarchy relationships in such a way that it does not allow users to query all attributes.

Then build a good attribute relationship that makes processing easier.

2. Delimiter files adds extra characteristics like adds commas between data or add spaces or add special characters.

They have a lot of performance issues that is, it requires some extra time in identifying and locating the required data.

Comparatively a flat file does not require such formatting.A database with a flat file will have only a single flat file with all data in it.

3.To constantly updated a database every month, the possible issues can be:

There can be data redundancy(duplication of data during updation).

Concurrency issues are also possible. to avoid this, you can use locks.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.