Explain the difference between view and materialized view?
What is partitioning? What are the types of partitioning?
What are the different ways to represent the loading of dimension tables?
What is ETL process in Data warehousing?
How can we import and export using BCP utility?
Explain difference between snow flake and star schema.
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What are loops in Datawarehousing?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
what are the different views that are considered when building an object-oriented software system?
0 Answers InfoAxon Technologies,
What are Data Marts?
What are the tools available for etl?
Explain what is fact less fact table? Where you have used it in your project?