Snapshot of data warehouse
Write down the snapshot with reference to data warehouse?
Expert
A snapshot is in a data warehouse can be employed to track activities. For illustration, each and every time an employee attempts to alter his address, the data warehouse can be attentive for a snapshot. This means which each snap shot is carried when some event is fired. A snapshot has three constituents which are illustrated below:
How can we remove duplicate rows from the flat file?
Define the term Auto regression? Explain in brief.
Describe how we can add a NOT NULL column to a table?
Explain the Stored Procedure transformation?
Name the main data structures used in these areas: Hierarchical data model, RDBMS and Network data model?
Explain for what the Supervisor module is used?
Write about the term Attribute, Entity and Relationship?
Specify some of the areas where the data warehouses are utilized in the present and in the future?
Write down the latest error handling technique in SQL Server 2005?
Name the triggers which support SQL Server 2000?
18,76,764
1957780 Asked
3,689
Active Tutors
1426981
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!