DataStage Interview Questions-4

  1. What is the latest version of DataStage?
  2. Which version of DataStage are you working on now? 
  3. Have you worked on DataStage 8.1/9.1 version?
  4. What are the new functionalities that you found on DataStage 9.1?
  5. What are the new functionalities that you found on DataStage 11.3?
  6. What is the difference between Server and Parallel jobs?
  7. Have developed any complex server/parallel job till now? If yes, please explain the job design.
  8. How can you generate Sequence number using Transformer stage?
  9. What is the order of execution for Constraints,Loop variables,Stage variables and Derivations in Transformer stage?
  10. Did you use looping in transformer stage, what is the significance of @ITERATION system variable?
  11. What are the differences between Switch stage and Filter stage?
  12. Can we abort the job directly from Transformer stage?
  13. Why we use collection methods? what are they?
  14. How can we remove duplicate records without using Remove Duplicates stage?
  15. How can we remove duplicate records without using Remove Duplicates and Sort stage?
  16. How can we capture unique records those do not have duplicates?
  17. How can we capture duplicate records?
  18. What is the significance of execute command and user variables activity?
  19. What is the count of Min and Max number of output links for a Copy Stage?
  20. Answer: Minimum is zero. When no output link is specified, the copy stage acts as a sink and discards the data without any memory usage. Maximum,you can have any number of output links.

  21. Job 1 writes the data into DS1 with A,B,C,D,E columns specified. Job 2 reads the data from dataset and writes into DB. Column A,B,C are specified in the dataset columns in this job. But DB is using an insert— insert into table X (A,B,C,D) values( ?,?,?,?).Whether this insert will work or not? If yes how, as D is not specified in the dataset.?
  22. Answer: By Checking the Run Time Column Propagation option in the Dataset.

Previous :  DataStage Interview Questions-3       Next :  DataStage Interview Questions-5

Comments

comments

Leave a Reply