Wednesday, 4 February 2015

50 TOP DataStage Interview Questions and Answers (Part1)

1. What are the components of datastage?
  Datastage consists of a number of client and server components. Datastage has four client components :
? Datastage Designer
? Datastage Director
? Datastage Manager
? Datastage Administrator

2. What are the main features of datastage?
  DataStage has the following features to aid the design and processing required to build a data warehouse :
? Uses graphical design tools. With simple point and click techniques you can draw a scheme to represent your processing requirements.
? Extracts data from any number or types of database.
? Handles all the metadata definitions required to define your data warehouse.
? You can view and modify the table definitions at any point during the design of your application.
? Aggregates data.
? You can modify SQL SELECT statements used to extract data.
? Transforms data. DataStage has a set of predefined transforms and functions. you can use to convert your data. You can easily extend the functionality by defining your own transforms to use.
? Loads the data warehouse.

3. What are the types of jobs availabe in datastage?
? Server Job
? Parallel Job
? Sequencer Job
? Container Job

4. 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.

5. Where the DataStage stored his repository?
  DataStage stored his repository in IBM Universe Database.

6. What are the types of datastage clients?
? Datastage Administrator
? Datastage Designer
? Datastage manager
? Datastage Director

7. What is metadata?
Data about data. A table definition which describes the structure of the table is an example of meta data.

8. What is the difference between maps and locales?
Maps : Defines the character sets that the project can use.
Locales : Defines the local formats for dates, times, sorting order, and so on that the project can use.

9. Define job?
A collection of linked stages, data elements, and transforms that define how to extract, cleanse, transform, integrate, and load data into a target database.

10. What is datastage director?
The DataStage Director is the client component that validates, runs, schedules, and monitors jobs run by the DataStage Server.
More Questions & Answers :-

No comments:

Post a Comment