Explain what is power center repository?
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 is surrogate key? Where we use it? Explain with examples.
What is data stream and data adaopter. Is it same are different? Explain?
What are the various methods of getting incremental records or delta records from the source systems?
What are the differences between datamart vs. Reporting cube?
Compare aggregates and data marts
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What are the different types of fact tables used in data warehousing?
Explain what are conformed dimensions?
What are the reasons to use a chameleon method in data warehousing?
What is loop in data warehousing?
What is the function of etl when used in data warehousing?