25 Best Data Warehousing Interview Questions and Answers

List of top 25 most frequently asked Data Warehousing interview questions and answers pdf download free

Data Warehousing Interview Questions and Answers List

  1. How can we run the graph? What is the procedure for that? How can we schedule the graph in UNIX?
  2. What is a real-time data warehouse? How is it different from near to real-time data warehouse?
  3. What is difference between drill & scope of analysis?
  4. I have two Universes created by two difference database can we join them in Designer & Report level? How
  5. For faster process, what we will do with the Universe?
  6. What is type 2 version dimension?
  7. What is unit testing?
  8. What is Informatica Architecture?
  9. What is data warehouse architecture?
  10. What is data analysis? Where it will be used?
  11. What are data modeling and data mining? Where it will be used?
  12. What is “method/1”?
  13. After the generation of a report to whom we have to deploy or what we do after the completion of a report?
  14. After the complete generation of a report who will test the report and who will analyze it?
  15. Can you pass sql queries in filter transformation?
  16. Where the Data cube technology is used?
  17. How can you implement many relations in star schema model?
  18. What is critical column?
  19. What is the main difference between star and snowflake star schema? Which one is better and why?
  20. What is the difference between dependent data warehouse and independent data warehouse?
  21. Which technology should be used for interactive data querying across multiple dimensions for a decision making for a DW?
  22. What is Virtual Data Warehousing?
  23. What is the difference between metadata and data dictionary?
  24. What is the difference between mapping parameter & mapping variable in data warehousing?
  25. Explain the advantages of RAID 1, 1/0, and 5. what type of RAID setup would you put your TX logs.

Like This Page...Share on FacebookTweet about this on TwitterPin on PinterestShare on Google+Share on LinkedInShare on RedditShare on StumbleUponShare on TumblrBuffer this pageDigg thisEmail this to someone
This entry was posted in Data Warehousing Interview Questions. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *