Interested to Buy Any Domain ? << Click Here >> for more details...
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 to handle multi value dimensions?
can anybody mail me the FAQS for hyperion essbase amd planning
How to generate the cubes in framework manager?
Explain what are the advantages of query studio compared to report studio?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What are the steps involved in creating dimensional modeling process?
What a static and local variable?
What is defined as partial backup?
How can you communicate with web server (apache or iis) from coldfusion?
Explain what are the advantages data mining over traditional approaches?
Explain how are the dimension tables designed?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what are conformed dimensions?
Explain what does level of granularity of a fact table signify?
