Independent and dependent data marts
Write about the independent and dependent data marts.
Expert
Dependent data marts are retrieved directly from the enterprise data warehouses, whereas, Independent data marts refer to the data that is captured from one (or) more operational systems (or) external information providers (or) data produced locally within the particular department (or) geographic area.
Define the RETURN statement.
Write a short note on an ERD?
Define the term data aggregation?
Describe the some drawbacks of a standard language like SQL?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
What is an Operational Data Store?
Write down a short note on the Volatile Temporary tables (VTT).
In Sybase illustrates the term Table Partitioning?
Explain what are the roles performed by the SQL?
Describe the difference between complexType elements and simple elements?
18,76,764
1945150 Asked
3,689
Active Tutors
1436749
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!