a2zinterviews

56.	What are an Entity, Attribute and Relationship?
	An entity represents a chunk of information. In relational databases, an entity often maps to a table. An attribute is a component of an entity and helps define the uniqueness of the entity. In relational databases, an attribute maps to a column. The entities are linked together using relationships.
	Discuss Your Name Your Email-ID Your Answer

57.	What is the difference between data warehousing and OLAP?
	The terms data warehousing and OLAP are often used interchangeably. As the definitions suggest, warehousing refers to the organization and storage of data from a variety of sources so that it can be analyzed and retrieved easily. OLAP deals with the software and the process of analyzing data, managing aggregations, and partitioning information into cubes for in-depth analysis, retrieval and visualization. Some vendors are replacing the term OLAP with the terms analytical software and business intelligence.
	Discuss Your Name Your Email-ID Your Answer

58.	How to join the multiple sources?
	An entity represents a chunk of information. In relational databases, an entity often maps to a table. An attribute is a component of an entity and helps define the uniqueness of the entity. In relational databases, an attribute maps to a column. The entities are linked together using relationships.
	Discuss Your Name Your Email-ID Your Answer

59.	What all the types of Jobs you developed?
	Server Job Parallel Job Sequencer Job Container Job
	Discuss Your Name Your Email-ID Your Answer

55.	What is the difference between Server Job and Parallel Jobs?
	Server Jobs works in sequential way while parallel jobs work in parallel fashion (Parallel Extender work on the principal of pipeline and partition ) for I/O processing.
	Discuss Your Name Your Email-ID Your Answer