Which three statements are true about File Sets?
Which three statements are true about File Sets? (Choose three.)
Which two statements are correct about XML stages and their usage?
Which two statements are correct about XML stages and their usage? (Choose two.)
What is the correct method to process a file containing multiple record types using a Complex Flat File stage?
What is the correct method to process a file containing multiple record types using a Complex Flat
File stage?
Which job design technique can be used to give unique names to sequential output files that are used in multi-
Which job design technique can be used to give unique names to sequential output files that are
used in multi-instance jobs?
Which two tasks will accomplish these objectives?
You have been given operational requirements to introduce data recovery to one of your parallel
job designs. Additionally, you have been told that you are to use flat files as your intermediate data
structure. Which two tasks will accomplish these objectives? (Choose two.)
What would give the best performance improvement for the job?
A customer is complaining of poor performance from the job shown in the exhibit, which
aggregates and joins on ZIP code. Currently all partitioning is set to “Auto” and sort/partition
insertion is allowed.
What would give the best performance improvement for the job?
What could the original developer have done to make this task easier for maintenance purposes?
You are assigned to correct a job from another developer. The job contains 20 stages sourcing
data from two Data Sets and many sequential files. The annotation in the job indicates who wrote
the job and when, not the objective of the job. All link and stage names use the default names.
One of the output columns has an incorrect value which should have been obtained using a
lookup. What could the original developer have done to make this task easier for maintenance
purposes?
Which two statements are true regarding this change to the parallel shared container?
You have a parallel shared container that is used by other parallel jobs within your project. Part of
the logic in this shared container has been changed. Which two statements are true regarding this
change to the parallel shared container? (Choose two.)
which design change would improve the performance of this job?
The given job processes large volumes of data using default partitioning, with sort/partition
insertion enabled. Both source Data Sets are partitioned and sorted on the merge key. Assuming
that the business logic allows all of the following actions, which design change would improve the
performance of this job?
Which two roles are required to allow a user to edit DataStage jobs?
You are setting up user roles on Information Server Web console. Which two roles are required to
allow a user to edit DataStage jobs? (Select two)