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
How many types of facts and what are they?
What is difference between e-r modeling and dimensional modeling?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are the differences between star and snowflake schema?
How to drill through from a powerplay cube to reportnet?
How to load the time dimension?
What is the extension of file to save template?
Explain the hierarchies level data warehousing.
Who needs data warehousing?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain the differences between normalizer and normalizer transformation?
Explain what are non-additive facts?
How we are using this function?
What is perform recovery?
Where the applications and where ware house management system is used?