Explain are data mart and dwh normalized or denormalized? Do both of them exist in
No Answer is Posted For this Question
Be the First to Post Answer
What are the different types of Fatcs? Explain with example only
What needs to be done when the database is shutdown?
Compare aggregates and data marts
Why we use repository connectivity?
Difference between ODS and Staging
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.
What are vaious etl tools in the market?
Explain what is data validation strategies for data mart validation after loading process?
Explain the importance of data warehouse?
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?
Is there any default username & pwd for bo designer & supervisor?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?