DWH Interview Question and Answers

29. What is the main difference between Data Warehousing and Business Intelligence?
 
  • DW - is a way of storing data and creating information through leveraging data marts. DM's are segments or categories of information and/or data that are grouped together to provide 'information' into that segment or category. DW does not require BI to work. Reporting tools can generate reports from the DW.
  • BI - is the leveraging of DW to help make business decisions and recommendations. Information and data rules engines are leveraged here to help make these decisions along with statistical analysis tools and data mining tools.
 
Your Name Your Email-ID
Your Answer
30. What is a physical data model?
  During the physical design process, you convert the data gathered during the logical design phase into a description of the physical database, including tables and constraints.
 
Your Name Your Email-ID
Your Answer
31. What is a logical data model?
 
  • A logical design is a conceptual and abstract design. We do not deal with the physical implementation details yet; we deal only with defining the types of information that we need.
  • The process of logical design involves arranging data into a series of logical relationships called entities and attributes.
 
Your Name Your Email-ID
Your Answer
32. Which all databases PowerCenter Server on Windows can connect to?
  PowerCenter Server on Windows can connect to following databases:
  • IBM DB2
  • Informix
  • Microsoft Access
  • Microsoft Excel
  • Microsoft SQL Server
  • Oracle
  • Sybase
  • Teradata
 
Your Name Your Email-ID
Your Answer
12345678910 Page 8 of 10