If you have an open cursor on a table, modify the same table and commit, what would happen?
Tracing options available in data warehousing
What are the different tracing options available? Can tracing options be set for individual transformations?
I am not sure if this pertains to the datawarehouse in general but we do have concept of audit dimensions. Also, dimensions with effective dating can help tracing the changes.
I guess, this question should be directed towards particular tools... as a concept, data warehousing would be hard pressed to have any logging...
What is the difference between aggregate table and materliazed view?
Read Best Answer
Editorial / Best Answer
Answered by: joshmohit
Member Since Oct-2010 | Answered On : Nov 3rd, 2010
Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the database specific properties which might not be covered with the generic definition of aggregate tables.
An aggregate table is a table that contains data that is summarized somehow, for example, it contains a summary of Customer by Product by Week. A more granular level of detail would be the transactio...
Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the...
How to use comand "commit"and "rollback" in a transacsion?
commit;
commit work;
commit work 'comment';
rollback;
rollback work;
rollback to savepoint ;
COMMIT:it is used to make the manipulations ENABLE permanently on the table where as ROLLBACK is used to DISABLE the effect of the queries(which were typed a bit above it) on ...
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
NH
changes will save..
To provide read consistency, the same records as per when the cursor was opened will be used till the cursor is closed.