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 data file?
  15. How data set stores data in it?
  16. How can we delete data sets permanently?
  17. Can we copy onedata set to another data set?
  18. Can we edit the data in data set in Unix?
  19. How to know the records count in data set?
  20. What are virtual data sets?

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



Leave a Reply