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
What is real-time datawarehousing?
ware house management system is used?
What are the different models used in cluster analysis?
What is the difference between static cache and dynamic cache?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Explain me what are data marts?
What is data analytics in simple terms?
What are non-additive facts in detail?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Explain differences between star and snowflake schemas?
Explain which columns go to the fact table and which columns go the dimension table?
What should I have in mind when building olap solution from scratch?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
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.
