Wednesday, 4 February 2015

Datastage: Datastage Interview Questions/Answers (Part2)

11. What is the difference between DataStage and Informatica?
? DataStage support parallel processing which Informatica doesn’t.
? Links are object in the DataStage ,in Informatica it’s a port to port connectivity.
? In Informatica its easy to implement Slowly Changing Dimensions which is little bit complex in dataStage.
? DataStage doesn’t support complete error handling.

12. What is data aggregation?
An operational data source usually contains records of individual transactions such as product sales. If the user of a data warehouse only needs a summed total, you can reduce records to a more manageable number by aggregating the data.

13. What are the types of server components?
? Repository
? Datastage Server
? Datastage Package Installer

14. WhWhat is datastage job?
DataStage jobs consist of individual stages. Each stage describes a particular database or process. For example, one stage may extract data from a data source, while another transforms it. Stages are added to a job and linked together using the designer.

15. What are the types of stage?
A stage can be passive or active. A passive stage handles access to databases for the extraction or writing of data. Active stages model the flow of data and provide mechanisms for combining data streams, aggregating data, and converting data from one data type to another. There are two types of stage :
Built in stages : Supplied with DataStage and used for extracting, aggregating, transforming, or writing data.
Plug in stages : Additional stages defined in the DataStage Manager to perform tasks that the built-in stages do not support.

16. What is universe stage?
A stage that extracts data from or loads data into a Universe database using SQL. Used to represent a data source, an aggregation step, or a target data table.

17. What is dynamic array?
Dynamic arrays map the structure of DataStage file records to character string data. Any character string can be a dynamic array. A dynamic array is a character string containing elements that are substrings separated by delimiters.

18. What is the difference between DataStage version 5.2 and 6.0?
Version 5.2 doesn’t have – IPC Stage ,Link Partition Stage,Link Collector Stage and Parallel Extender.

19. What are the components of Ascential Data Stage?
Client Components : Administrator, Director, Manager, and Designer.
Server Components : Repository, Server and Plug–ins.

20. What are the types of Containers?
There are two types of containers are :
Local Container
Shared Container
More Questions & Answers :-

No comments:

Post a Comment