Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
No Answer is Posted For this Question
Be the First to Post Answer
Why should you put your data warehouse on a different system than your oltp system?
What are the advantages and disadvantages of reporting directly against the database?
What is Bulk Insert?
Where the applications and where ware house management system is used?
Explain piconet?
Explain how are the dimension tables designed?
What is Discover and Execute in XMLA?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
What are the main steps to build the data warehouse?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
Disply the dname wise maximum salary
What is data stream and data adaopter. Is it same are different? Explain?