DataStage Interview Questions-3

  1. What is a Surrogate Key, why we used it?
  2. How can we generate Surrogate Key in DataStage jobs? Explain the options available in the stage.
  3. Which are the Partition techniques in Aggregator stage.which are used in which case?
  4. Difference between Data set and sequential file stages?
  5. How DataStage stores data sets?
  6. Types of Data sets?
  7. Can we run the Dataset stage in parallel mode?
  8. Can we run the Sequential stage in parallel mode?
  9. Can we read multiple files using sequential stage?
  10. Difference between Data set and file set stages?
  11. What data set descriptor file contains?
  12. What data set data file contains? where these data files will be stored?
  13. Can we delete data set using ‘rm’ command?
  14. What if we delete data set descriptor file? can we read the data from the data file?
  15. How data set stores data in it?
  16. How can we delete data sets permanently?
  17. Can we copy one data set to another data set?
  18. Can we edit the data in data set in Unix?
  19. How to know the records count in the data set?
  20. What are virtual data sets?

Previous :  DataStage Interview Questions-2        Next :  DataStage Interview Questions-4



Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: