Datastage Interview Question and Answers

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.
 
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.
 
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.
 
Your Name Your Email-ID
Your Answer
59. What all the types of Jobs you developed?
 
  • Server Job
  • Parallel Job
  • Sequencer Job
  • Container Job
 
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.
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 12 of 15