Question

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.

Answer 1

`Hey,

Note: Brother in case of any queries, just comment in box I would be very happy to assist all your queries

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.

Kindly revert for any queries

Thanks.