What are the key columns in Fact and dimension tables?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What needs to be done when the database is shutdown?
How can you communicate with web server (apache or iis) from coldfusion?
Start a batches with in a batch?
When should you use a STAR and when a SNOW-FLAKE schema?
What is a ETL/ How does Oracle support the ETL process?
How can we load the time dimension?
Explain what is the difference between power center & power mart?
What are fundamental stages of data warehousing?
What is Active Datawarehousing?
How did you plan your Data ware house project?
What is a general purpose scheduling tool?