What are aggregate tables and aggregate fact tables?
Explain where do we use semi and non additive facts?
What is pre-emptive and non-pre-emptive?
What are cluster analysis in data warehousing?
What are the various methods of getting incremental records or delta records from the source systems?
What is operational data source (ODS)?
if source contain 10records how you identify header and footer
How can you communicate with web server (apache or iis) from coldfusion?
Explain the main difference between inmon and kimball philosophies of data warehousing?
Explain how are the dimension tables designed?
What is the use of tabular model, tabular sql, tabular reference in real time application?
Disply the dname wise maximum salary
Where the cache files stored?