Tag: platforms and products

Questions Related to platforms and products

  1. Set APT_JOB_REPORT to True

  2. Set APT_DUMP_SCORE to True

  3. Set APT_MONITOR_SIZE to true

  4. Set APT_RECORD_COUNTS to true


Correct Option: B
  1. Writes the job’s OSH script to the job log

  2. Automatically sets all environmental variables

  3. Graceful shutdown of datastage engine

  4. Provides a snapshot of a job’s performance


Correct Option: D
  1. Unique sort keys must be set to True

  2. Allow Duplicates must be set to False

  3. Sort Group must include the sort key values

  4. Stable sort must be set to true


Correct Option: B
  1. Environmental variable APT_AUTO_TRANSPORT_SIZE

  2. Environmental variable APT_SORT_MEMORY_SIZE

  3. Sort stage Restrict memory usage property

  4. Sort stage Max memory limit property


Correct Option: C
  1. Create a task with single oracle enterprise stage that executes a custom SQL statement with FETCH ALL, that outputs to an Oracle enterprise stage.

  2. Create a job with three Oracle Enterprise stages to read from the tables and output to a collector stage which in turn outputs the data to an Oracle Enterprise stage.

  3. Create a job with a single Oracle Enterprise stage that executes a custom SQL statement with UNION ALL that outputs the data to an oracle enterprise stage.

  4. Create a job with three Oracle Enterprise stages to read from the tables and output to a Funnel stage which in turn outputs the data to an oracle enterprise stage.


Correct Option: C,D
  1. Auto detect by XML stage.

  2. Check the "Repetition Element Required" box on the output link tab.

  3. Set the key property for the column on the output link to 'Yes'

  4. Set the 'Nullable' property for the column on the output link to 'Yes'


Correct Option: C
  1. Call the DSLoggFatal function from a stage variable derivation

  2. Call the DSStopJob function from a stage or column derivation

  3. Use the SETENV function to set the environmental variable APT_PM_KILL_NOWAIT

  4. Create a dummy output link with a constraint that tests for the condition to abort on; set the 'Abort After rows' property to 1


Correct Option: D
  1. APT_NO_JOBMON

  2. APT_PERFORMANCE_DATA

  3. APT_PM_SHOW_PIDS

  4. APT_RECORD_COUNTS


Correct Option: A
  1. Cleanup resources from a failed datastage job

  2. Start and stop datastage engine.

  3. Provide read access to Datastage configuration file.

  4. Report datastage client connections.


Correct Option: B