Multiple choice technology

What are/is the command to be executed in DS Admin to get the job modifications details

  1. SELECT * FROM DS_JOBDETAILS WHERE JOB_NAME = ‘<job name>’

  2. SELECT * FROM DS_AUDIT WHERE INSTANCE = ‘<job name>’

  3. Both Option1 and Option2

  4. Only Option 1
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The DS_AUDIT table in the DataStage repository stores audit trail information about job modifications and other metadata changes. DS_JOBDETAILS stores static job definitions, not modification history. The correct query filters by INSTANCE (job name).

Keep practicing — related questions