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
Explain difference between snow flake and star schema.
What is a source qualifier?
Where the applications and where ware house management system is used?
How do you create surrogate key using ab initio?
What is cfapplication tag?
Explain a mapping, session, worklet, workflow, mapplet?
What are the different types of schemas used in data warehousing?
What are components of report studio?
What is a fact, dimension, measure?
What are aggregate transformation?
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?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
How to create different types of templates?
For faster process, what we will do with the universe?
What are the data marts?
