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?
No Answer is Posted For this Question
Be the First to Post Answer
Explain conformed fact?
Describe the differences between a data warehouse and data mart.
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Explain degenerate dimension table?
Can decision tree be implemented using SQL?
What we will do with the universe for faster process?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is recovering sessions?
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 ??????
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Database in use is oracle?
Explain me what is vldb?