What are snapshots? What are materialized views & where do we use them?
No Answer is Posted For this Question
Be the First to Post Answer
Explain is olap databases are called decision support system true/false?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What Oracle tools can be used to design and build a W/H?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
What is the difference between snowflake and star schema?
How to create prompts in report net?
What is DTM session?
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 different types of join operations?
What is prompt types of prompts?use of prompts syntax of prompt?
Explain about core dimension,
Can we take backup when the database is opened?