Differentiation between metadata and data dictionary
Give a brief differentiation between metadata and data dictionary?
Expert
Metadata depicts about data. It is ‘‘data about data’’. It has information concerning how and when, through whom a certain data was gathered and the data format. It is vital to understand information that is stored in xml-based and web data warehouses applications.
Data dictionary is a file which comprises of the essential definitions of a database. It holds the list of files that are accessible in the database, figure of records in each and every file, and the information about the fields.
Specify the types of dimensions?
Give a brief introduction of the term data cleaning?
Specify the various types of Aggregation?
Write a short note on the difference between a dynamic and materialized view?
How you can detect the loops?
Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display
Specify the different application areas of the data mining.
How teradata ensures that there are no duplicate rows being inserted while this SET table?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Explain briefly the term Web Services?
18,76,764
1929283 Asked
3,689
Active Tutors
1459809
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!