Answer Posted / harshad
As this would be not specific DW Concept but rather more on
RDBMS Programming concept.
Cursor is nothing but the pointer of memory addres to your
query result.
Explicit Cursor : User need to specifically declared in
your program (procedure/function)
Implicit Cursor : Any DML; it will handled by RDBMS.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is data warehouse architecture?
Explain difference between snow flake and star schema.
What is pre-emptive and non-pre-emptive?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What are vaious etl tools in the market?
Explain what is data validation strategies for data mart validation after loading process?
What is a view as it relates to system modeling?
What are the different methods of loading dimension tables?
What is a data profile?
What are fact, dimension, and measure?
Explain reference cursor?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What does level of granularity of a fact table signify?
Explain why fact table is in normal form?
What are the various transformation available?
