Can we have more than one time dimensions in a Schema(Star or Snowflake)
What are the possible data marts in retail sales?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
How can we run the graph?
Explain what is partitioning? What are the types of partitioning?
What are the different methods of loading dimension tables?
What is data cleaning? How can we do that?
Explain how to export mappings to the production environment?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Difference between DSS & OLTP?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
Suppose we want to display zero when null values coming to report how can we do that?
What is Conceptual, Logical and Physical model?