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?
What two things must you do to update the meta-data repository with the artifacts tagged as version 1?
Your customer is using Source Code Control Integration for Information server and have tagged
artifacts for version 1. You must create a deployment package from the version 1.
Before you create the package you will have to ensure the project is up to date with version 1.
What two things must you do to update the meta-data repository with the artifacts tagged as
version 1? (Select two)
how can you determine when a new row is the first of a new group of Product rows?
Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product
column. Using stage variables, how can you determine when a new row is the first of a new group
of Product rows?
Which two ways might be used to accomplish this without changing how the job functions?
In the job fragment shown in the exhibit, there are two Sort stages: the first (Sort1) sorts the data
by state, the second (Sort2) sorts the data by state and area, No repartitioning occurs between the
stages.
You have been asked to reduce the number of sorts to improve the performance of the job.
Which two ways might be used to accomplish this without changing how the job functions? (Select
two)
what happens when Runtime Column Propagation is disabled for a parallel job?
Which statement describes what happens when Runtime Column Propagation is disabled for a
parallel job?
What are the three automatic conversions?
External data conversions fall in two major types – automatic and manual. What are the three
automatic conversions? (Select three)
Which statement is true when using the SaveInputRecord() function in a Transformer stage.
Which statement is true when using the SaveInputRecord() function in a Transformer stage.
Which two statements are true?
A dataset was created earlier with one partition, with the Preserve Partitioning flag set. A
subsequent job using a 2-node configuration file reads from that dataset, passing data to a
Transformer stage with “Same” partitioning.
Which two statements are true? (Select two)
(Choose two.)
In the Slowly Changing Dimension stage, a dimension columns Purpose code property can trigger
which two actions. (Choose two.)
Which process is the section leader for node2?
Refer to the exhibit.
You submit a job from DataStage Director and then log onto your DataStage Linux server to issue
the command “ps-ef | grepds” and receive the following screen:
Which process is the section leader for node2?