Explain what is partitioning? What are the types of partitioning?
What are the different types of segments?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
How do we design a universe?
What are different deliverables according to phases?
Explain the differences between normalizer and normalizer transformation?
What are the methodologies of data warehousing?
Explain what are non-additive facts?
Explain the definition of normalized and denormalized view?
Explain what is a cube in data warehousing concept?
The same tier?
Explain about core dimension,
Explain what is analytical or analytic mean?
Explain datawarehousing?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?