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.
1075Post New Data Warehouse General Questions
Explain what is difference between query studio and report studio?
What is batch processing?
What are the design methods of data warehousing?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Explain me what is vldb?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
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?
what are relationships?
Explain ddl (data definition language)?
Is there any rownum object from which we can do this?
Explain what is a three tier data warehouse?
How to handle multi value dimensions?
What is your spectra photometer working principles?
Explain degenerate dimension table?
What is real-time datawarehousing?