If you have an open cursor on a table, modify the same table and commit, what would happen?
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.
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?
Answered by: joshmohit
View all answers 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 ...
Has there been a time when you were presented a problem and solved it?
Do you have any questions that you want to ask?
Have you experienced being given too many tasks?
What is your way of building rapport with a person you just met?
Do you seek advice from others when you have a question?
Careers and Higher Education Options for BBA Graduates
What are the career opportunities available for MCA Graduates?
Has anyone asked you for help? What did you do?
What are the things you wish to achieve in 5 years?
Describe a time when you had to work under pressure.
Ask Interview Question?
Have Career Question?
Ask Only Career questions.