Explain the data types present in bo n wht happens if we implement view in the designer n report?
What are parallel querys and query hints?
How to define a cube??
What is the main difference between star and snowflake star schema? Which one is better and why?
What is many-to-many dimensional model in datawarehousing ?
What are the various tools? Explain name a few?
List any five applications of data warehouse.
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain what are fact, dimension, and measure?
Explain what does level of granularity of a fact table signify?
Explain degenerate dimension table?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain the hierarchies level data warehousing.
Explain which columns go to the fact table and which columns go the dimension table?
Explain what are the advantages and disadvantages of reporting directly against the database?