Which three environment variables are used for reporting on DataStage jobs?
Which three environment variables are used for reporting on DataStage jobs? (Select three)
What three statements are true with regards to restartable mode for an FTP Enterprise stage?
What three statements are true with regards to restartable mode for an FTP Enterprise stage?
(Select three)
What stage should be used for this requirement?
A customer must compare a date column with a job parameter date to determine which output
links the row belongs on. What stage should be used for this requirement?
which two changes could improve sort performance in this scenario?
A 100MB input dataset has even distribution across 400 unique key values.
When run with a 4-node configuration file, which two changes could improve sort performance in
this scenario? (Select two)
How many processes will this job create?
A job design consists of an input SequentialFile stage, followed by a Peek stage, a Transformer
stage, a Sort stage and finally an output Dataset stage. The job executes on an SMP system with
a configuration file defined with 4 nodes.
The environment variable $APT_DISABLE_COMBINATION is set to “True”. How many processes
will this job create?
Which technique is most appropriate?
You have a 3TB dataset hash-partitioned on CustID in a clustered environment. You need to join
this dataset with 1GB of reference data on OrderID. Which technique is most appropriate?
Which two of the following derivations for an output column named OutCol can be used to generate a unique sequ
Which two of the following derivations for an output column named OutCol can be used to
generate a unique sequence of integers across multiple partitions?
Which single stage should you consider to accomplish maintaining parallelism and not introduce re-partitioning
The result of a performance review for one of your job designs indicated this job needs to be split
into two separate jobs. You also have been given the requirement to ensure you maintain
parallelism (no re-partitioning) between these two new jobs.
Which single stage should you consider to accomplish maintaining parallelism and not introduce
re-partitioning between these related jobs?
What are the three aggregation types can be set in the Aggregator stage?
What are the three aggregation types can be set in the Aggregator stage? (Select three)
which three tasks need to be done?
When creating a Wrapper stage, which three tasks need to be done? (Select three)