What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
No Answer is Posted For this Question
Be the First to Post Answer
Explain what is the metadata extension?
Can you pass sql queries in filter transformation?
What is the difference between metadata and data dictionary?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
Explain what are the advantages and disadvantages of reporting directly against the database?
What is up date strategy and what are th options for update strategy?
How can we do ETL process in SQL Server?
Difference between ODS and Staging
Explain me what are data marts?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What are cursors?