Explain difference between view and materialized view?
No Answer is Posted For this Question
Be the First to Post Answer
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?
What are the tools available for etl?
Explain meta data?
how do you use commit frequencies? how does it affect loading performance?
What is data validation strategies for data mart v?
Explain what are fact, dimension, and measure?
What is scd1 , scd2 , scd3?
Explain what is data validation strategies for data mart validation after loading process?
Explain dimension table ?
What is IQD file?
What are different deliverables according to phases?
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.