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.
State difference between Passive and Active transformation?
Explain the term iConv and oConv?
How would the developer describe all variables using referential data types?
Illustrates the ETL data integration software?
Describe briefly Aggregate transformation?
What is meant by the term Context?
Describe the process that takes place to execute a stored routine.
Illustrates the case statement present into stored procedure?
Illustrate briefly the term insertion and deletion anomalies?
Illustrate the term data mart. What do you mean by it?
18,76,764
1944450 Asked
3,689
Active Tutors
1456913
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!