a2zinterviews

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.
	Discuss 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.
	Discuss 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.
	Discuss 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
	Discuss Your Name Your Email-ID Your Answer