Datastage Interview Question and Answers

61. What are the types of input links in datastage?
 
    DataStage supports two types of input link:
  • Stream : A link representing the flow of data. This is the principal type of link, and is used by both active and passive stages.
  • Reference : A link representing a table lookup. Reference links are only used by active stages. They are used to provide information that might affect the way data is changed, but do not supply the data to be changed.
 
Your Name Your Email-ID
Your Answer
62. Define dynamic arrays?
  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.
 
Your Name Your Email-ID
Your Answer
63. Where the DataStage stored his repository?
  DataStage stored his repository in IBM Universe Database.
 
Your Name Your Email-ID
Your Answer
64. What are the command line functions that import and export the DS jobs?
 
  • dsimport.exe : imports the DataStage components.
  • dsexport.exe : exports the DataStage components.
 
Your Name Your Email-ID
Your Answer
65. What is the use of datastage jobs?
  A DataStage job consists of individual stages, linked together to describe the flow of data from a data source to a final data warehouse or data mart. Each stage describes a particular database or process.
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 13 of 15