Which two statements are true about Data Sets?
Which two statements are true about Data Sets? (Choose two.)
How would you accomplish this task?
You are asked to convert a relational source, as shown in the exhibit, into three separate XML
files. How would you accomplish this task?
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 two actions will help you improve the performance without changing the business logic?
Refer to the exhibit.
You are responsible for improving performance for a given job. From reviewing the job dump
score, you notice that many tsort operators are inserted. Join_1 is on columns “account”,
“po_date” and “hdr_number”. Join_2 is based on “account”, “hdr_number”, “paid_date”.
Which two actions will help you improve the performance without changing the business logic?
(Select two)
what are two export column type property values allowed for the combined single output column result?
When using the Column Export stage, what are two export column type property values allowed
for the combined single output column result? (Choose two.)
Which Oracle data type conversion is correct?
Which Oracle data type conversion is correct?
Which two file stages allow you to configure rejecting data to a reject link?
Which two file stages allow you to configure rejecting data to a reject link? (Choose two.)
What would explain this result?
A job is using the Load method in the DB2 and Oracle Enterprise stage for parallel loading into a
single table. The job fails at runtime and you see there are new table rows added. What would
explain this result? (Select two)
Identify two items that are created as a result of running a Balanced Optimization on a job that accesses a Ha
Identify two items that are created as a result of running a Balanced Optimization on a job that
accesses a Hadoop distributed file system as a source? (Choose two.)
Which two job design techniques can be used to provide unique names to sequential output files that are used i
Which two job design techniques can be used to provide unique names to sequential output files
that are used in multi-instance jobs? (Select two)