Differences between a data warehouse and data mart
Write a brief note on the differences between a data warehouse and data mart?
Expert
A data warehouse is for the enterprise and contains numerous subjects. A data mart is for a specific functional region and focuses on one subject. A data warehouse is data-oriented and flexible and contains detailed historical data. A data mart is project-oriented and restrictive and contains some historical data.
Explain the term object?
Specify the types of the tracing level?
Explain the stage variables?
Elucidate what are the basic requirements to join two sources in the source qualifier?
Specify the types of join that are available?
Explain how teradata ensures that there are no duplicate rows being inserted when it’s a SET table?
Which data providers can be combined in one report?
Explain the user objects?
Briefly describe the employ of aggregate tables and lookup tables?
States the term Global temporary.
18,76,764
1950752 Asked
3,689
Active Tutors
1424208
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!