Datastage Interview Question and Answers

1. 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.
 
Your Name Your Email-ID
Your Answer
2. What are the components of Ascential Data Stage?
 
  • Client Components - Administrator, Director, Manager, and Designer.
  • Server Components - Repository, Server and Plug-ins.
 
Your Name Your Email-ID
Your Answer
3. What are System variables?
  System variables comprise of a set of variables which are used to get system information and they can be accessed from a transformer or a routine. They are read only and start with an @.
 
Your Name Your Email-ID
Your Answer
4. What are the enhancements made in datastage 7.5 compare with 7.0?
  Many new stages were introduced compared to datastage version 7.0. In server jobs we have stored procedure stage, CDC Stage ,command stage and generate report option was there in file tab. In job sequence many stages like startloop activity, end loop activity,terminate loop activity and user variables activities were introduced. In parallel jobs surrogate key stage, stored procedure stage were introduced.
 
Your Name Your Email-ID
Your Answer
5. What is DataStage?
 
  • Design jobs for Extraction, Transformation and Loading(ETL).
  • Ideal tool data integration projects such as data warehouses, data marts and system migrations.
  • Import,export,create and managed metadata for use within jobs.
  • Schedule, run and monitor jobs all within DataStage
  • Adminsters your Datastage development and execution environments.
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 1 of 15