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.
550Post New Data Warehouse General Questions
What is a view as it relates to system modeling?
Explain me what are data marts?
What is meant by metadata in context of a data warehouse?
Explain why should you put your data warehouse on a different system than your oltp system?
What is Active Datawarehousing?
Can a dimension table contain numeric values?
What is an er diagram?
What needs to be done when the database is shutdown?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What is conformed fact?
What is difference between query studio and report studio?
in general which algorithms for used?
What is surrogate key? Where we use it?
What are components of reportnet?
Explain what is batch and describe about types of batches?