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.
No Answer is Posted For this Question
Be the First to Post Answer
Can you brief about the Data warehouse project you worked on?
What is the difference between view materialized view and view?
Is there any difference in testing database and data ware housing?
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 meetthe condition.
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain what is the difference between view filter and report filter?
What is edw?
What is a fact table?
Explain why should you put your data warehouse on a different system than your oltp system?
What are universe requirements?
What is the difference between metadata and data dictionary?
Explain the main difference between inmon and kimball philosophies of data warehousing?