Can you explain how analysis service works?
Answer / azhar
analysis service works by making use of both OLAP and data
mining.
| Is This Answer Correct ? | 0 Yes | 1 No |
Explain normalization?
What is data stream and data adaopter. Is it same are different? Explain?
What are the different types of data warehouses?
Explain what are the vaious etl tools in the market?
Can a dimension table contain numeric values?
What is application.cfm?
What are parallel querys and query hints?
What is a ETL/ How does Oracle support the ETL process?
what is a hot file, why we need in datawarehousing, where we used in general
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
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?
Explain what is a view as it relates to system modeling?