Explain bus schema?
What is hash partition?
What is multi-dimensional analysis?
Explain what are the advantages and disadvantages of reporting directly against the database?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What is the difference between datawarehouse and bi?
What is XMLA ?
4.Explain Snowflkeschema ?
6 Answers EDS, HCL, IBM, iFlex, TCS,
Explain the importance of data warehouse?
What is surrogate key? Where we use it?
Tell me what is full load & incremental or refresh load?
What is vldb(very large databases)?
three ways sql*loader could load data, what are those three types?