Areas where data warehouses are utilized
Specify some of the areas where the data warehouses are utilized in the present and in the future?
Expert
Potential subject areas where the data ware houses may be designed at present and also in future are:
a) Census data:
Registrar general and census commissioner of te India decennially compiles the information of all the individuals, villages, population groups and so on. This information is wide ranging just like the individual slip. A compilation of the information of individual households, of which the database of 5%sample is retained for analysis. Data warehouse may be built from this database over which the OLAP techniques may be applied, Data mining can also be carried out for analysis and knowledge discovery.
b) Prices of vital Commodities:
Ministry of the food and civil supplies, Government of the India complies daily basis data for around 300 observation centers within the whole country over the prices of the vital commodities like rice, edible oil and so on, a data warehouse may be built for this data and OLAP methods may be applied for its analysis
How must you modify the function to handle error?
Explain the types of views within Data stage Director?
Write a short note on the difference between a dynamic and materialized view?
Give a brief introduction of the term critical column?
Define the way of passing of variables to a SQL routine.
Write down a short note on the difference between an ERD and EER.
Explain three types of SQL database server architecture?
Write about fossils?
What are true statements regarding implicit cursors?
Contrast a fat and a thin client?
18,76,764
1928724 Asked
3,689
Active Tutors
1421486
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!