How to handle multi value dimensions?
Explain why are oltp database designs not generally a good idea for a data warehouse?
Explain about core dimension, balanced dimension, and dirty dimension?
When should you use a STAR and when a SNOW-FLAKE schema?
What is the function of etl when used in data warehousing?
What is hybrid slowly changing dimension?
What is static and local variable?
How to provide security in frame work manager for a query subject?
what is parallel query?
Explain how to get the first 100 rows from the flat file into the target?
How can you set the session management?
Explain is olap databases are called decision support system true/false?
Explain if a flat file cotains 1000 records how can I get first and last records only?