Tell me the Top 10 features of oracle that supports
Answers were Sorted based on User's Feedback
Answer / radhakrishnansk
1. Materialized views.
|Is This Answer Correct ?||6 Yes||2 No|
Answer / sj
2. Bitmap indexes
|Is This Answer Correct ?||3 Yes||0 No|
how to calculate sum(sal) with out using aggregator satge
what is query optimizer? what are different types of optimizer s supported by oracle ?
What is Analysis Services?
How can you define a transformation? What are different types of transformations in Informatica?
what are the all possible features supported modify stage?
which automation tool is used in data warehouse testing?
How Materialized Views are linked with Oracle DataWare house?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
5.Explain ODS ?
2.What is staging area ?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
Difference between slicing and dicing with example?