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 mean by aggregate aware?
What is an er diagram?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
Explain what is the difference between olap and datawarehosue?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Explain conformed fact?
Explain differences between star and snowflake schemas?
How to stop a batch?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain me what are data marts?
Explain what are the vaious etl tools in the market?
Explain the versions of reportnet?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is "method/1"?
Store (and count) non-fact records?