41. What is a Surrogate Key, why we use it?
42. How can we generate Surrogate Key in DataStage jobs? Explain the options available in the stage.
43. Which are the Partition techniques in the Aggregator stage. which are used in which case?
44. Difference between the Data set and sequential file stages?
45. How DataStage store data sets?
46. Types of Data sets?
47. Can we run the Dataset stage in parallel mode?
48. Can we run the Sequential stage in parallel mode?
49. Can we read multiple files using the sequential stage?
50. Difference between the Data set and file set stages?
51. What data set descriptor file contains?
52. What data set data file contains? where these data files will be stored?
53. Can we delete the data set using the ‘rm’ command?
54. What if we delete the data set descriptor file? can we read the data from the data file?
55. How dataset store data in it?
56. How can we delete data sets permanently?
57. Can we copy one data set to another data set?
58. Can we edit the data in the data set in Unix?
59. How to know the records count in the data set?
60. What are virtual data sets?
You can practice the above questions and along with a few more by watching the below video:
Previous : DataStage Interview Questions-2 Next : DataStage Interview Questions-4
