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
Code the tables statement for a single-level (most common) frequency?
In microstrategy, how can we direct the sql generated to use a specifc table?
How to pivot row data using informatica?
What is is a star schema?
What are the other names given to data warehousing?
What is a cube in data warehousing concept?
Fact table is in normalized or de-normalized form?
How to test report in reportnet?
What are the different types of segments?
Describe a data warehouse.
How to generate the cubes in framework manager?
What is real-time datawarehousing?
How can we schedule the graph in unix?
What are the different methods of loading dimension tables?
Can we take backup when the database is opened?
